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

From Lee Azzarello
Subject Re: Warm standby recovery failure
Date
Msg-id 16b031c0902031340j2467e238u9028485a8ef61043@mail.gmail.com
Whole thread Raw
In response to Re: Warm standby recovery failure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
thank you all for your help. It was indeed my copy script that
destroyed the database. I now understand that postgresql shouldn't be
concerned with validating a WAL segment, that's the responsibility of
the script that hands the segment to postgres.

-lee

On Fri, Jan 30, 2009 at 9:52 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Jaume Sabater <jsabater@gmail.com> writes:
>> 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?
>
> That seems like using a sledgehammer to swat a fly.  The problem as
> I saw it was that the script was probably simply not checking for
> an error result from 'cp'.
>
>                        regards, tom lane
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: Re: Permissions to a schema
Next
From: raf
Date:
Subject: How to prevent users from creating tables