Comments on How To Set Up A Postgresql 9.0 Hot Standby Streaming Replication Server With Repmgr On OpenSUSE 11.4
How To Set Up A Postgresql 9.0 Hot Standby Streaming Replication Server With Repmgr On OpenSUSE 11.4 This is a tutorial how to set up a postgresql replicated hot standby server with streaming replication, and we also set up the repmgr to monitor and manage the replication cluster. Unlike most tutorials that copy the database file from master to slave (or standby) in the middle of running pg_start_backup() and pg_end_backup(), repmgr is used to simplify the whole procedure. (But I still think that procedure helps you a lot to understand how postgresql warm standby, pitr, and hot standby replication work.)
3 Comment(s)
Comments
wal_keep_segments=5000
Before fully understanding the implications of that configuration variable, I set it to 5000 on our production database. The result was that the pg_xlog eventually used up all of the available disk space on and brought the server down. I changed the value to
wal_keep_segments=32
as is recommended in http://deepakmurthy.wordpress.com/2011/06/03/postgresql-hot-standby-replication/, and the PostgresQL documentation itself. The pg_xlog went from consuming 47GB to only 7GB afterwards, and the slave continues to sync with no problems.
Regards,
Bill
Parameter
hot_standby ignored on a master server.
Your post helped me a lot. Thanks!