addadd-thickarrow-downaxebreadcrumb dividercameracc-compulsarychatclosecontactdata-usersdebugdevelopersdismissdocumentserrorglossaryinfolinkpublisherssearchselect-dropdownsuccesstableswarning

Publishers

Everything you need to know to publish and share data.

  1. Home
  2. Publishers
  3. Upload & Import Data
  4. Connect to a PostgreSQL database

Connect to a PostgreSQL database

A PostgreSQL database is an open source database system. With a network link, Koordinates is able to connect to designated PostgreSQL databases, search available data and identify data to make available for import on your site. For databases configured with PostGIS (an extension to PostgreSQL that supports geometry), we can also add geospatial data layers.

Connect to a PostgreSQL database

1

Select 'Sources' from the Admin menu

2

Click 'Add a Source' and select 'PostgreSQL'

3

Add connection details

You'll be asked to add: 

  • Host
  • Port
  • Database
  • Schema (leave this blank to scan every schema)
  • Username
  • Password

4

Give your source a meaningful title and choose an Owning Group

Owning Groups are used to categorise and manage permissions on data. Don't worry if you're not sure—you'll be able to change the Owning Group before importing any data into your data service.


5

Click 'Connect'

If correctly configured, your Koordinates Data Service will immediately connect and scan your data source. 

Manage your PostgreSQL source

1

Select 'Sources' from the Admin menu

2

Click on your chosen data source

3

Edit Connection details for your source

4

Click 'Save'