Setting up Postgres Databases for Streaming Replication

Streaming replication allows a standby server to stay more up-to-date than is possible with file-based log shipping. When data is replicated between the Postgres database servers, the information remains consistent throughout the entire Server Cluster.

There are two phases to this process:

  1. Setting up the Postgres Master database
  2. Setting up the Postgres Standby database