Skip site navigation (1) Skip section navigation (2)

Re: Warm standby recovery failure

From: Jaume Sabater <jsabater(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Warm standby recovery failure
Date: 2009-01-30 08:53:19
Message-ID: 3786f7bb0901300053s20fb930bv76c0bb46479be7fe@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, Jan 30, 2009 at 2:22 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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"

In response to

Responses

pgsql-admin by date

Next:From: Michael MonnerieDate: 2009-01-30 11:23:49
Subject: Re: [GENERAL] Encoding problem using pg_dumpall
Previous:From: Tom LaneDate: 2009-01-30 01:22:01
Subject: Re: Warm standby recovery failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group