|The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 274 pages
RRP £9.95 ($14.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
11.2.3 Preparing the Master for Standby Servers
Set up continuous archiving on the primary to an archive directory accessible from the standby, as described in section 10.3 Continuous Archiving and Point-In-Time Recovery (PITR). The archive location should be accessible from the standby even when the master is down, i.e. it should reside on the standby server itself or another trusted server, not on the master server.
If you want to use streaming replication, set up authentication on the
primary server to allow replication connections from the standby
server(s); that is, provide a suitable entry or entries in
‘pg_hba.conf’ with the database field set to
replication. Also ensure
max_wal_senders is set
to a sufficiently large value in the configuration file of the primary
Take a base backup as described in section 10.3.2 Making a Base Backup to bootstrap the standby server.
|ISBN 9781906966072||The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration Guide||See the print edition|