Message-ID: <515AF0D8.2010702@europecamions-interactive.com>
Date: Tue, 02 Apr 2013 16:53:12 +0200
From: David Guyot <david.guyot@europecamions-interactive.com>
Organization: ECI
User-Agent: Mozilla/5.0 (X11; Linux i686 on x86_64;
	rv:17.0) Gecko/20130307 Thunderbird/17.0.4
MIME-Version: 1.0
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?
References: <515AEB4E.9010305@europecamions-interactive.com>
	<CALxYTP6sxtHSwfFk2C3n4cV59NNPcg2Po9R04SM8W9WTR1ThWw@mail.gmail.com>
In-Reply-To: 
 <CALxYTP6sxtHSwfFk2C3n4cV59NNPcg2Po9R04SM8W9WTR1ThWw@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="----enig2OHKUBHQPWSWOKPQVJNJT"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
------enig2OHKUBHQPWSWOKPQVJNJT
Content-Type: multipart/alternative;
 boundary="------------090105070709090202020800"

This is a multi-part message in MIME format.
--------------090105070709090202020800
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 =C3=A9crit :
>
> 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 =3D '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...
>
>
> --=20
> 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

--=20
David Guyot
Administrateur syst=C3=A8me, r=C3=A9seau et t=C3=A9l=C3=A9communications
Europe Camions Interactive
Moulin Collot
F-88500 Ambacourt

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


--------------090105070709090202020800
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta content=3D"text/html; charset=3DUTF-8" http-equiv=3D"Content-Ty=
pe">
  </head>
  <body bgcolor=3D"#FFFFFF" text=3D"#000000">
    Mister,<br>
    <br>
    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?<br>
    <br>
    Thank you in advance.<br>
    <br>
    Regards.<br>
    <br>
    <div class=3D"moz-cite-prefix">Le 02/04/2013 16:47, Douglas J Hunley =
a
      =C3=A9crit=C2=A0:<br>
    </div>
    <blockquote
cite=3D"mid:CALxYTP6sxtHSwfFk2C3n4cV59NNPcg2Po9R04SM8W9WTR1ThWw@mail.gmai=
l.com"
      type=3D"cite">
      <div dir=3D"ltr">
        <div class=3D"gmail_extra"><br>
          <div class=3D"gmail_quote">On Tue, Apr 2, 2013 at 10:29 AM,
            David Guyot (English) <span dir=3D"ltr">&lt;<a
                moz-do-not-send=3D"true"
                href=3D"mailto:david.guyot@europecamions-interactive.com"=

                target=3D"_blank">david.guyot@europecamions-interactive.c=
om</a>&gt;</span>
            wrote:<br>
            <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0
              .8ex;border-left:1px #ccc solid;padding-left:1ex">
              <div id=3D":1ig">restore_command =3D 'rsync -av
                192.168.0.80:/var/lib/postgresql/WAL/%f %p'</div>
            </blockquote>
          </div>
          <br>
          You're telling the recovery process to get the files off the
          (now dead) master here...<br>
          <br clear=3D"all">
          <div><br>
          </div>
          -- <br>
          Douglas J Hunley (<a moz-do-not-send=3D"true"
            href=3D"mailto:doug.hunley@gmail.com" target=3D"_blank">doug.=
hunley@gmail.com</a>)<br>
          Twitter: @hunleyd =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0
          =C2=A0 Web: <a moz-do-not-send=3D"true"
            href=3D"http://douglasjhunley.com" target=3D"_blank">douglasj=
hunley.com</a><br>
          G+: <a moz-do-not-send=3D"true" href=3D"http://goo.gl/sajR3"
            target=3D"_blank">http://goo.gl/sajR3</a>
        </div>
      </div>
    </blockquote>
    <br>
    <pre class=3D"moz-signature" cols=3D"72">--=20
David Guyot
Administrateur syst=C3=A8me, r=C3=A9seau et t=C3=A9l=C3=A9communications
Europe Camions Interactive
Moulin Collot
F-88500 Ambacourt

Tel: +33 (0)3 29 30 47 85
Fax : +33 (0)3 29 31 31 31</pre>
  </body>
</html>

--------------090105070709090202020800--

------enig2OHKUBHQPWSWOKPQVJNJT
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBAgAGBQJRWvDYAAoJEOdwVf06csTSoPEQAJtgiouLemc+D4R4Y6+vokTu
UCyQjJ6xwpFwVujfIfeBQjydTyBpg3c6I5ffM3iS+r6Es0LSRmnNPSskq7GoLzTy
/1s+cQR6pZcAs1TH5Svcihp6dj8TiVqlVsqYlzyszf5WOlGgkz4NaZJidVirVJM5
uuPJUqrfZp2+nFjl6T/IC+TI/7wSQBxYJL8WWVdvc615842fvC1HSxHrNSDqQHDm
nyTURFy+s77tecSnuPmO1F7KED2A53mZ+BPo4LRR4875aUf6P+/rWQeL/pJ2rG2z
f3DHU8AH9CVHUAcyDhHLZXK8ETKYi36i/3aji3CO1WoGSGjSBACyX0GDuca360as
eX+9eW1B+OHrCpHKNVlNgIpv56irfIo+fP+sATeg/Eccq3yWC1wBau5c5tGOBDOx
u1XNJAUTxCoJ3nyDVQjWdFpky8Qx6Dz50AJ/43uxZ4s3ZhVq6ep88andQcFAo87A
/8wTi8F4E1zG3SZoFaMA0I2VJk8Ta0XzwYyGSPBxEtPFbk/Bp/9s2d0+vCjgdxqj
q72lXXlgtQcSu709PxoToSyLuOXN2bS/Ai7YHulJY1Dt+pgdc5nLezvUJMJop/ud
Wq7M+wruscRSx088/cjpe7i9Cimdlgq5yjURBLCIG6Yumb9kepm3mCd/WET9yTmD
sNpmk+CG/QepCJTBSUfD
=VUUI
-----END PGP SIGNATURE-----

------enig2OHKUBHQPWSWOKPQVJNJT--