Re: [GENERAL] PITR - warm standby switchover question

2009-04-15 Thread Erik Jones
On Apr 15, 2009, at 12:42 AM, Fujii Masao wrote: Hi, On Wed, Apr 15, 2009 at 9:23 AM, Dan Hayes wrote: Excellent! Thanks. One other quick question... What would happen if I didn't delete the recovery.conf file? Is that step just to prevent accidentally restarting the server with it t

Re: [GENERAL] PITR - warm standby switchover question

2009-04-15 Thread Chander Ganesan
Fujii Masao wrote: Hi, On Wed, Apr 15, 2009 at 9:23 AM, Dan Hayes wrote: Excellent! Thanks. One other quick question... What would happen if I didn't delete the recovery.conf file? Is that step just to prevent accidentally restarting the server with it there? recovery.conf is aut

Re: [GENERAL] PITR - warm standby switchover question

2009-04-15 Thread Fujii Masao
Hi, On Wed, Apr 15, 2009 at 9:23 AM, Dan Hayes wrote: > Excellent!  Thanks.  One other quick question...  What would happen if I > didn't delete the recovery.conf file?  Is that step just to prevent > accidentally restarting the server with it there? recovery.conf is automatically renamed recove

Re: [GENERAL] PITR - warm standby switchover question

2009-04-14 Thread Erik Jones
Well, if you don't delete the recovery.conf and you *do* delete pg_standby's stop file (or it gets deleted, for example if you set it to go under /tmp and the server is restarted for whatever reason) the server will attempt to go back into recovery mode using your configured recovery comman

Re: [GENERAL] PITR - warm standby switchover question

2009-04-14 Thread Dan Hayes
Excellent! Thanks. One other quick question... What would happen if I didn't delete the recovery.conf file? Is that step just to prevent accidentally restarting the server with it there? On Tue, Apr 14, 2009 at 6:26 PM, Erik Jones wrote: > > On Apr 14, 2009, at 3:47 PM, Dan Hayes wrote: > >

Re: [GENERAL] PITR - warm standby switchover question

2009-04-14 Thread Erik Jones
On Apr 14, 2009, at 3:47 PM, Dan Hayes wrote: I've followed the implementation instructions at 24.4.2: http://www.postgresql.org/docs/current/static/warm-standby.html And I've used the archive/restore commands from the example in F23.2: http://www.postgresql.org/docs/current/static/pgstandby.h

[GENERAL] PITR - warm standby switchover question

2009-04-14 Thread Dan Hayes
I've followed the implementation instructions at 24.4.2: http://www.postgresql.org/docs/current/static/warm-standby.html And I've used the archive/restore commands from the example in F23.2: http://www.postgresql.org/docs/current/static/pgstandby.html This all works great. The primary backs up t