From: Linas Virbalas <linas.virbalas@continuent.com>
To: Florian Pflug <fgp@phlo.org>, Robert Haas <robertmhaas@gmail.com>
CC: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, Aidan Van Dyk
	<aidan@highrise.ca>, Euler Taveira de Oliveira <euler@timbira.com>,
	"pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: Thu, 29 Sep 2011 08:44:59 -0700
Subject: Re: Hot Backup with rsync fails at pg_clog if under load
Thread-Topic: [HACKERS] Hot Backup with rsync fails at pg_clog if under load
Thread-Index: Acx9aEDnelDTL50hQdyD9ymMvECJiABVn19q
Message-ID: <CAAA6D2B.2769E%linas.virbalas@continuent.com>
In-Reply-To: <E75A2E54-8E6E-4ADE-B6D8-E1FEEDFEF3A6@phlo.org>
Accept-Language: en-US
Content-Language: en
acceptlanguage: en-US
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

> Linas, could you capture the output of pg_controldata *and* increase the
> log level to DEBUG1 on the standby? We should then see nextXid value of
> the checkpoint the recovery is starting from.

I'll try to do that whenever I'm in that territory again... Incidentally,
recently there was a lot of unrelated-to-this-post work to polish things up
for a talk being given at PGWest 2011 Today :)

> I also checked what rsync does when a file vanishes after rsync computed =
the
> file list, but before it is sent. rsync 3.0.7 on OSX, at least, complains
> loudly, and doesn't sync the file. It BTW also exits non-zero, with a spe=
cial
> exit code for precisely that failure case.

To be precise, my script has logic to accept the exit code 24, just as
stated in PG manual:

Docs> For example, some versions of rsync return a separate exit code for
Docs> "vanished source files", and you can write a driver script to accept
Docs> this exit code as a non-error case.

--
Sincerely,
Linas Virbalas
http://flyingclusters.blogspot.com/