HOWTO Database
The infrastructure has a central PostGreSQL database which can be used by various services.
Managing tables
A Webbased database manager (pgAdmin) has been installed at https://apitestbed.geonovum.nl/pgadmin, which can be used to verify content in tables and administed tables and users. You can also create new tables and populate it using SQL queries (generated from a local database).
Uploading data to PostGreSQL from QGIS
The testbed database exposes its port to the web for conveniance purposes, this is not very common in production situations. This allows QGIS to directly connect to the database. And you can use the QGIS DB manager to upload data.
- Open the Data source manager to be able to add the testbed database to QGIS
| key | value |
|---|---|
| service | |
| host | apitestbed.geonovum.nl |
| port | 5432 |
| database | gis |
| SSL | allow |
| user | geopost |
| pw | xxxxx |
- Open DB Manager and select the testbed database
- Click the 'Import Layer/File' button and complete the wizard
Connecting GeoServer to the central PostGreSQL
From GeoServer admin you can create a store which connects to the central database. After which you can set up feature collections originating from that store.
- On the stores page, create a
store. Select a store of type PostGIS (not jndi). - Fill in the connection details:
| key | value |
|---|---|
| host | postgis |
| port | 5432 |
| database | gis |
| schema | public |
| user | geopost |
| pw | xxxxx |
- From the layers screen, create a new layer.
- Select the PostGreSQL store
- Select the relevant table from the database.
- Fill in the Layer fields, at minimum calculate the bounds of the layer.
- Save and preview the layer
Uploading data to PostGreSQL from QGIS Bridge
As part of the data publication process of QGIS Bridge, you can configure the data to be stored on PostGreSQL. Two options exist (as configuration on a server connection):
- Bridge will send the data to GeoServer. And GeoServer will insert the data in PostGres.
- Bridge will connect directly to the remote PostGreSQL and insert the data