Re: Warm standby recovery failure - Mailing list pgsql-admin

From Jaume Sabater
Subject Re: Warm standby recovery failure
Date
Msg-id 3786f7bb0901300053s20fb930bv76c0bb46479be7fe@mail.gmail.com
Whole thread Raw
In response to Re: Warm standby recovery failure  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Warm standby recovery failure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Fri, Jan 30, 2009 at 2:22 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> We probably should add a caution about this to the manual's discussion
> of how to write archiving scripts.

I presume you mean the copy/transfer process did not do its job
correctly, Tom. Therefore, I would advise using a script that compares
the MD5/SHA1 sums of the origin and destination files and retries the
copy/transfer process before returning an exit status to the server
(archive_command call). Do you think this would suffice?

--
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Warm standby recovery failure
Next
From: Michael Monnerie
Date:
Subject: Re: [GENERAL] Encoding problem using pg_dumpall