Re: Warm standby recovery failure

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Warm standby recovery failure
Дата
Msg-id 8207.1233327145@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Warm standby recovery failure  (Jaume Sabater <jsabater@gmail.com>)
Ответы Re: Warm standby recovery failure  (Lee Azzarello <lee@dropio.com>)
Re: Warm standby recovery failure  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: lst_hoe02@kwsoft.de
Дата:
Сообщение: Re: How to migrate from oracle to postgres !!
Следующее
От: "Marc Mamin"
Дата:
Сообщение: autovacuum question