Share Tweet Share





The official documentation on how to set up binary replication (or “hot standby”) for version 9.0 are kind of daunting. So I thought I’d give you the 5 minute replication setup version: if you have a very simple setup and you can afford to shut down the master database, getting replication running can be simple indeed.

5 Minutes to Simple Replication

This is the easiest way to set up replication between a master and standby. It requires shutting down the master; other methods are detailed later in this guide.

Prerequisites

You must have the right setup to make this work:

2 servers with similar operating systems (e.g both Linux 64-bit).

The same release of PostgreSQL 9.0 installed on both servers.

PostgreSQL superuser shell access on both servers.

Knowledge of how to start, stop and reload Postgres.

PostgreSQL 9.0 running on Server1.

A database created and loaded on Server1.

A postgres user or root user who has network