PostgreSQL destination setup

Review this guide to learn how you can set up PostgreSQL destination for a number of supported by Coupler.io data sources.

1. Select PostgreSQL destination

2. Add destination account

Click '+Add Account' and enter your PostgreSQL server and credentials.

> Host - your host on which the PostgreSQL server is running. The value can be a host name, IPv4 address, or IPv6 address.
> Port - specify the port. The default port number is 5432.
> Database - name of the database to connect to.
> User - user name of the PostgreSQL account to use for connecting to the server. (Make sure user has needed permissions for the database and table you would like to import data to)

Following permissions are required:

CREATE privilege on the database level

CREATE privilege on the schema level

INSERT privilege on the table, you want to import data into

> Password - corresponding password of the PostgreSQL account used for connecting to the server.

Note: you’ll need to allowlist Coupler.io IP addresses if your organization only allows access from “selected networks” . Those IP addresses are:

34.123.243.115

34.170.96.92

3. Specify a schema & table, where you would like to import data to.

You can type either existing schema/table name or enter a new one. By typing in a new name that doesn’t exist yet, Coupler.io will create a new schema/table and then import data.

4. Pick the right import mode

Replace - fully replaces all previously imported data with the latest information available in your data source.
Append - places your newly imported data under previously imported entries; is suitable for tracking historical data changes.

For Append mode: if schema of your data is changed you need to make adjustments in PostgreSQL table first (e.g. add new column) and then re-run the importer.

5. Set up an automatic data refresh

5.1. Set up a schedule for data refresh

Specify Interval, Days of the week, Time of the day, and Schedule time zone to run the Automatic data refresh.
Learn more about Automatic data refresh.

5.2. Save the changes

Click SAVE AND RUN to save the parameters and run the initial import right away.