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.
→ Access to modify your Postgres configuration⏱️ Estimated time to finish: 10 minutes.
pg_monitor
, which reads/executes various monitoring views and functions. See more in the Postgres documentation
The following setup does several separate steps:
- It creates a dedicated SYNQ user and user group
- It grants SYNQ the necessary permissions
Create a dedicated SYNQ user with sufficient permissions
Grant permissions to the relevant schemas
Network Configuration
Depending on your database configurations, you may need to whitelist SYNQ’s IP addresses in your firewall or security groups. See SYNQ IP Whitelist for the complete list of IP addresses by region.Input data in the SYNQ UI
Integration name
E.g.,postgres
Database
The name of your Postgres databaseHost
The name of your host, e.g.,database-1.<host>.eu-north-1.rds.amazonaws.com
Port
The default is5432