Re: data loss with pg_standby when doing a controlled failover

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: data loss with pg_standby when doing a controlled failover
Дата
Msg-id 49DA11B9.5010500@pse-consulting.de
обсуждение исходный текст
Ответ на Re: data loss with pg_standby when doing a controlled failover  (Guillaume Smet <guillaume.smet@gmail.com>)
Список pgsql-bugs
Guillaume Smet wrote:
> On Mon, Apr 6, 2009 at 1:37 PM, Andreas Pflug <pgadmin@pse-consulting.de> wrote:
>
>> IMHO this should be mentioned in the docs explicitly (I find it quite
>> surprising that data can be lost even if the system is shutdown
>> correctly), or better when shutting down the postmaster should spit all
>> log segments containing all changes when archiving is on so the warm
>> standby server can catch up.
>>
>
> See also this thread which might be interesting for you:
> http://archives.postgresql.org/message-id/3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com
>
It is, though not related to this problem. I'd expect pg_standby's
default behaviour to be like the pseudocode's in the warm-standby
documentation. To me, it's kind of unexpected that it won't continue
restoring if the trigger file is present (as Kevin said, what's the use
case for the current behaviour?).

Regards,
Andreas

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

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: data loss with pg_standby when doing a controlled failover
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4750: UPDATE called from PL/pgSQL failed when there is ON UPDATE DO INSTEAD NOTHING rule