Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? - Mailing list pgsql-admin

From Douglas J Hunley
Subject Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?
Date
Msg-id CALxYTP6ZCEh4_oWuAcuXZFpGks9ONd3qd0YT7GTgk104ohomFg@mail.gmail.com
Whole thread Raw
In response to Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?  (David Guyot <david.guyot@europecamions-interactive.com>)
List pgsql-admin

On Tue, Apr 2, 2013 at 10:53 AM, David Guyot <david.guyot@europecamions-interactive.com> wrote:
Thank you for your answer. I had in mind that this line was for the initial start of the standby; should I just comment it before promoting the standby, or is this line useless for the day-to-day standby service?

If you're going to do WAL shipping, your 'archive_command' on the master needs to be copying over to the standby (rsync or whatever). Then the standby's recovery.conf would be a simple 'cp /path/to/wal-archive' type of command. 


--
Douglas J Hunley (doug.hunley@gmail.com)
Twitter: @hunleyd                                               Web: douglasjhunley.com
G+: http://goo.gl/sajR3

pgsql-admin by date:

Previous
From: David Guyot
Date:
Subject: Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?
Next
From: Douglas J Hunley
Date:
Subject: Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?