Set up PostgreSQL as a data connection for replication pipelines in the Data Integrity Suite.
Before you configure PostgreSQL as a replication connection, ensure you have the following:
- PostgreSQL database server hostname or IP address
- Database port number (default is 5432)
- Database name
- User credentials (username and password or Key Vault credentials)
- An agent configured to access the database
PostgreSQL can be configured as both a source and target for replication. You can set up continuous replication to keep data synchronized in real-time or near-real-time.
- In the Data Integrity Suite, navigate to .
- Click Add connection or select an existing PostgreSQL connection to edit.
- For detailed configuration instructions, refer to the PostgreSQL documentation.
- Toggle ON the replication option and choose the replication engine from the dropdown list
- Click Test Connection to verify that the connection is configured correctly.
- Click Save to save the PostgreSQL replication connection.
You've successfully configured PostgreSQL as a replication connection. The connection is now available for use in replication pipelines. You can now create or edit replication pipelines that use this PostgreSQL connection as a source or target.