Skip to content
Help

Connect to a PostgreSQL database

PostgreSQL is an open source database system. Koordinates can connect to a PostgreSQL database, find the data in it and make that data available to import to your site. If the database uses PostGIS (an extension to PostgreSQL that supports geometry), Koordinates can also import geospatial layers from it.

Connect to a PostgreSQL database

Section titled “Connect to a PostgreSQL database”

  1. Open the Data Manager

    Select Manage in the navigation menu.

  2. Select New, then PostgreSQL

    Select New. The tools menu opens at Data sources. Select PostgreSQL to open the Connect to PostgreSQL Source window.

  3. Add the connection details

    • Host and Port (the default port is 5432).
    • Data Gateway: if your site has a Data Gateway and the database is inside your own network, choose the gateway to connect through. Otherwise leave Don’t Use Data Gateway selected. This option only appears if your site has a Data Gateway.
    • Database: the name of the database.
    • Schemas: a comma-separated list of the schemas to scan. Leave it blank to scan only the default schema, or enter * to scan every schema.
    • Authentication: choose Username & Password and enter the credentials Koordinates should use, or None if the database doesn’t need them.

    Select Next.

    The Connect to PostgreSQL Source window on the Connection step, with Host, Port, Database and Schemas fields and a choice of None or Username & Password authentication.

  4. Add a title and owning group

    Give the source a meaningful Title, and choose its Owning Group. Members of the owning group can configure the source, run scans and import data from it. You can change the owning group later.

  5. Select Connect

    Koordinates connects to the database and starts scanning it. After a few seconds you’re taken to the source, where you can import the data it finds.

Manage your PostgreSQL source

Section titled “Manage your PostgreSQL source”

  1. Find your source

    In the Data Manager, select the Sources tab and select your source. To find it, type part of its name in Find source…, or sort and filter the list by type.

  2. Select Settings

    The Configure source window opens. The Details tab has the source’s title, group and description. The Connection tab has its connection details. To keep the saved password, leave Password blank.

  3. Select Save changes

To delete the source, select Remove source… in the Configure source window.

To learn how to run and review scans, see Scan and manage connected data sources.