Re: [BUGS] data loss with pg_standby when doing a controlled failover

Hi, On Mon, Apr 6, 2009 at 11:13 PM, Andreas Pflug wrote: > Scott Mead wrote: >> >> >> >> On Mon, Apr 6, 2009 at 7:37 AM, Andreas Pflug >> mailto:pgad...@pse-consulting.de>> wrote: >> >>     Running 8.3.7, I have a warm standby configuration with a >>     archive_timeout of 10min. >> >>     It's

Re: [BUGS] data loss with pg_standby when doing a controlled failover

Guillaume Smet wrote: > On Mon, Apr 6, 2009 at 1:37 PM, Andreas Pflug > 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 al

Re: [BUGS] data loss with pg_standby when doing a controlled failover

Scott Mead wrote: > > > > On Mon, Apr 6, 2009 at 7:37 AM, Andreas Pflug > mailto:pgad...@pse-consulting.de>> wrote: > > Running 8.3.7, I have a warm standby configuration with a > archive_timeout of 10min. > > It's obvious that there's a 10min period where data could be lost > if th

Re: [BUGS] data loss with pg_standby when doing a controlled failover

On Mon, Apr 6, 2009 at 1:37 PM, Andreas Pflug 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 cha

Re: [BUGS] data loss with pg_standby when doing a controlled failover

On Mon, Apr 6, 2009 at 7:37 AM, Andreas Pflug wrote: > Running 8.3.7, I have a warm standby configuration with a > archive_timeout of 10min. > > It's obvious that there's a 10min period where data could be lost if the > master fails and the warm standby server has to take over. What's not > obviou