Postgres

Integrating Postgres with SYNQ

This guide explains how to connect SYNQ to Postgres securely.

We need this information so we can collect metadata about your tables.

To be able to finish this guide, you’ll need the following:
→ Access to modify your Postgres configuration

⏱️ Estimated time to finish: 10 minutes.

SYNQ, by default, uses the pg_monitor, which reads/executes various monitoring views and functions. See more in the Postgres documentation

The following setup does several separate steps:

1. It creates a dedicated SYNQ user and user group
2. It grants SYNQ the necessary permissions

Create a dedicated SYNQ user with sufficient permissions

CREATE USER synq_user WITH PASSWORD '<password>';
CREATE GROUP synq_group;
ALTER GROUP synq_group ADD USER synq_user;
GRANT pg_monitor TO synq_group

Grant permissions to the relevant schemas

GRANT USAGE ON SCHEMA "schema" TO GROUP synq_group;
GRANT SELECT ON ALL TABLES IN SCHEMA "schema" TO GROUP synq_group;
ALTER DEFAULT PRIVILEGES IN SCHEMA "schema" GRANT SELECT ON TABLES TO GROUP synq_group;

Whitelist IP

Depending on your database configurations, you may have to whitelist the SYNQ IP: 34.105.135.39

Input data in the SYNQ UI

Integration name

E.g., postgres

Database

The name of your Postgres database

Host

The name of your host, e.g., database-1.<host>.eu-north-1.rds.amazonaws.com

Port

The default is 5432

Username and password

Username and password you specified earlier in the guide