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

2009-04-06 Thread Fujii Masao
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

2009-04-06 Thread Andreas Pflug
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

2009-04-06 Thread Andreas Pflug
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

2009-04-06 Thread Guillaume Smet
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

2009-04-06 Thread Scott Mead
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

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

2009-04-06 Thread Andreas Pflug
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 obvious is that this is true even if the master server is shut down reg