Skip to main content
This guide explains how to connect Coalesce Quality 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.
Coalesce Quality uses the pg_monitor role by default, which reads/executes various monitoring views and functions. See more in the Postgres documentation. The following setup:
  1. Creates a dedicated user and user group for Coalesce Quality
  2. Grants the necessary permissions

​
Create a dedicated 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;

​
Network Configuration

Depending on your database configurations, you may need to whitelist Coalesce Quality’s IP addresses in your firewall or security groups. See IP Whitelist for the complete list of IP addresses by region.

​
Input data in the 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