PostgreSQL Connection Guide
Data Bridge Pro supports PostgreSQL 10 and later, including Amazon RDS, Azure Database for PostgreSQL, and Google Cloud SQL.
Connection Settings
| Setting | Description | Example |
|---|
| Host | Hostname or IP | postgres.company.com |
| Port | Default: 5432 | 5432 |
| Database | Database name | production |
| SSL Mode | Security level | require |
SSL Modes
| Mode | Description |
|---|
| disable | No SSL (not recommended) |
| prefer | Use SSL if available |
| require | Require SSL connection |
| verify-full | Verify certificate and hostname |
Connection String
Host=myserver;Port=5432;Database=mydb;Username=myuser;Password=****;SSL Mode=Require;
Required Permissions
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO app_user;
GRANT USAGE ON SCHEMA public TO app_user;
Cloud Providers
- Amazon RDS: Use the RDS endpoint, port 5432, SSL required
- Azure: Host format
servername.postgres.database.azure.com, username user@servername