Re: [ADMIN] standby shutdown

2009-05-04 Thread Ray Stell
On Sat, May 02, 2009 at 12:13:42AM -0400, Robert Treat wrote: First tip, dont use -i, it isn't needed. I'd try withought any flag and work up if needed. Be patient unless you can't afford to be. thanks, Robert, I assume you mean don't use -m i, I don't see a -i anywhere. So, you are

Re: [ADMIN] standby shutdown

2009-05-04 Thread Ray Stell
On Mon, May 04, 2009 at 09:06:48AM -0400, Ray Stell wrote: So, you are saying just shutdown, but it is my experience that this might not work and I need to script this for the operator to do the maintenance. Could not get the standby to go down without flags, which makes me nervous since

Re: [ADMIN] standby shutdown

2009-05-04 Thread Joshua D. Drake
On Mon, 2009-05-04 at 11:22 -0400, Ray Stell wrote: On Mon, May 04, 2009 at 09:06:48AM -0400, Ray Stell wrote: So, you are saying just shutdown, but it is my experience that this might not work and I need to script this for the operator to do the maintenance. Could not get the

[ADMIN] standby shutdown

2009-05-01 Thread Ray Stell
I need to do OS maintenance on a system running a standby in recovery using pg_standby. I've gotten mixed results with doing the stop/start with pg_ctl. Sometimes the standby is not recoverable. What should the shutdown script look like if the standby is to be usable on the other side? The log

Re: [ADMIN] standby shutdown

2009-05-01 Thread Robert Treat
On Friday 01 May 2009 09:14:40 Ray Stell wrote: I need to do OS maintenance on a system running a standby in recovery using pg_standby. I've gotten mixed results with doing the stop/start with pg_ctl. Sometimes the standby is not recoverable. What should the shutdown script look like if the