Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?

On Tue, Apr 2, 2013 at 10:53 AM, David Guyot <
david(dot)guyot(at)europecamions-interactive(dot)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(dot)hunley(at)gmail(dot)com)
Twitter: @hunleyd Web:
douglasjhunley.com
G+: http://goo.gl/sajR3