Skip to main content
Skip table of contents

PostgreSQL architecture for streaming replication

Transaction logs or Write-Ahead Logging (WAL) is replayed from the source to the dSource to ensure data synchronization between the two.

The architectural setup involves the following steps:

  1. Ensure that the end-user application connecting to the PostgreSQL connector source database can perform both the read/write queries on the database.

  2. Understand that the database changes are recorded as WAL segments in the PostgreSQL connector database under the directory pg_xlog or pg_wal.

  3. Configure the source PostgreSQL connector server as a Standby Node.

  4. Configure replication security by creating a replication user and specifying the authentication protocol.

  5. Initiate a base backup on the standby environment.

  6. Configure postgresql.conf file as per the source environment.

  7. Start the standby server.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.