From: David Guyot <david.guyot@europecamions-interactive.com>
To: Douglas J Hunley <doug.hunley@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?
Date: Tue, 02 Apr 2013 16:53:12 +0200
Message-ID: <515AF0D8.2010702@europecamions-interactive.com> (raw)
In-Reply-To: <CALxYTP6sxtHSwfFk2C3n4cV59NNPcg2Po9R04SM8W9WTR1ThWw@mail.gmail.com>
References: <515AEB4E.9010305@europecamions-interactive.com>
<CALxYTP6sxtHSwfFk2C3n4cV59NNPcg2Po9R04SM8W9WTR1ThWw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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.guyot@europecamions-interactive.com
> <mailto:david.guyot@europecamions-interactive.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.hunley@gmail.com <mailto:doug.hunley@gmail.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
Attachments:
[application/pgp-signature] signature.asc (900B, ../515AF0D8.2010702@europecamions-interactive.com/3-signature.asc)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: david.guyot@europecamions-interactive.com, doug.hunley@gmail.com, pgsql-admin@postgresql.org
Subject: Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?
In-Reply-To: <515AF0D8.2010702@europecamions-interactive.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox