Re: data loss with pg_standby when doing a controlled failover - Mailing list pgsql-bugs

From Andreas Pflug
Subject Re: data loss with pg_standby when doing a controlled failover
Date
Msg-id 49DA11B9.5010500@pse-consulting.de
Whole thread Raw
In response to Re: data loss with pg_standby when doing a controlled failover  (Guillaume Smet <guillaume.smet@gmail.com>)
List 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 by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: data loss with pg_standby when doing a controlled failover
Next
From: Tom Lane
Date:
Subject: Re: BUG #4750: UPDATE called from PL/pgSQL failed when there is ON UPDATE DO INSTEAD NOTHING rule