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)

Add comment

Please register in our forum first to comment.

Comments

By: Bill

Thank you for the informative step-by-step tutorial.  I found it very helpful in setting up and understanding repmgr and what postgres configuration variables are pertinent to streaming replication.  One think I would note about your postgresql.conf settings is the the `wal_keep_segments` value you are proposing seems to be excessively high.

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

By: Anonymous

 Parameter

hot_standby ignored on a master server.

By: Xiao

Your post helped me a lot. Thanks!