Author: Amzad Ali

5 Dec by Amzad Ali Tags: ,

PostgreSQL Streaming Replication

  Master Server / Primary Server Set Up 1. Configuration Changes in file “postgresql.conf“ [crayon-5c193287ef9c3764954420/]   2. Configuration Changes in file “pg_hba.conf” Make an entry for replication user with Slave server IP: [crayon-5c193287ef9cc450848985/]   3. Restart the PostgreSQL service in Primary for changes to get impact: [crayon-5c193287ef9cf183868866/]   Slave Server/ Secondary Server Set Up 1.Stop […]