Re: data loss with pg_standby when doing a controlled failover

From: Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: data loss with pg_standby when doing a controlled failover
Date: 2009-04-06 13:51:33
Message-ID: 1d4e0c10904060651m18049be5qae1d09a42904d18b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Apr 6, 2009 at 1:37 PM, Andreas Pflug <pgadmin(at)pse-consulting(dot)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

--
Guillaume

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ondrej Novy 2009-04-06 14:05:11 BUG #4750: UPDATE called from PL/pgSQL failed when there is ON UPDATE DO INSTEAD NOTHING rule
Previous Message Scott Mead 2009-04-06 13:42:15 Re: data loss with pg_standby when doing a controlled failover