This article describes how to connect a Postgres database to Peliqan. This is referred to as an “external DB connection” in Peliqan, a direct DB connection is made to query data, without duplicating the data to the Peliqan data warehouse.

<aside> ☝

Note that Peliqan offers a built-in data warehouse where Postgres is one of the options. This article covers “external” Postgres DBs, not the built-in data warehouse.

</aside>

Connect Postgres

In Peliqan, go to Connections > Add Connection > Select Postgres in the list > Enter the details of your Postgres instance:

SSL

Peliqan will connect with SSL enabled first. If that fails, Peliqan will try to connect without SSL.

IP whitelisting

Make sure to add Peliqan’s IP addresses if IP whitelisting is active on your database. More info:

IP whitelisting

Permissions in Postgres

Make sure to configure following permissions in Postgres, so that Peliqan can discover schemas and tables in your DB.

Create user

CREATE USER peliqan WITH PASSWORD 'xxxxxxxxxxxxx';

Grant all permissions

Grant all permissions:

GRANT ALL PRIVILEGES ON DATABASE "mydb" to peliqan;