While point-in-time recovery is nice, it might not be enough. In many cases, people want an up-to-date standby server that can also serve as a read-only slave. A feature called streaming replication is exactly what is needed in this case.
Setting up streaming replication is easy and can be performed in a handful of steps:
postgresql.confon the master server.
pg_hba.confto allow remote base backups.
pg_basebackupto get an initial copy.
To set up
postgresql.conf, the following settings are needed:
wal_level = hot_standby max_wal_senders = 5 hot_standby = on
The first two settings are mandatory on the master. The
wal_level field tells the server to create enough
xlog to allow streaming ...