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

Mister,

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?

Thank you in advance.

Regards.

Le 02/04/2013 16:47, Douglas J Hunley a écrit :
>
> On Tue, Apr 2, 2013 at 10:29 AM, David Guyot (English)
> <david(dot)guyot(at)europecamions-interactive(dot)com
> <mailto:david(dot)guyot(at)europecamions-interactive(dot)com>> wrote:
>
> restore_command = 'rsync -av
> 192.168.0.80:/var/lib/postgresql/WAL/%f %p'
>
>
> You're telling the recovery process to get the files off the (now
> dead) master here...
>
>
> --
> Douglas J Hunley (doug(dot)hunley(at)gmail(dot)com <mailto:doug(dot)hunley(at)gmail(dot)com>)
> Twitter: @hunleyd Web:
> douglasjhunley.com <http://douglasjhunley.com>
> G+: http://goo.gl/sajR3

--
David Guyot
Administrateur système, réseau et télécommunications
Europe Camions Interactive
Moulin Collot
F-88500 Ambacourt

Tel: +33 (0)3 29 30 47 85
Fax : +33 (0)3 29 31 31 31