Re: master in standby mode croaks - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: master in standby mode croaks
Date
Msg-id 1270201010.5640.5789.camel@ebony
Whole thread Raw
In response to Re: master in standby mode croaks  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: master in standby mode croaks
List pgsql-hackers
On Fri, 2010-04-02 at 04:51 -0400, Robert Haas wrote:
> On Apr 1, 2010, at 7:06 PM, Simon Riggs <simon@2ndQuadrant.com> wrote:
> > On Tue, 2010-03-30 at 22:40 -0400, Robert Haas wrote:
> >> I discovered tonight that if you shut down a server, create
> >> recovery.conf with standby_mode = 'on', and start it back up again,
> >> you get this:
> >>
> >> LOG:  database system was shut down at 2010-03-30 22:34:09 EDT
> >> LOG:  entering standby mode
> >> FATAL:  recovery connections cannot start because the
> >> recovery_connections parameter is disabled on the WAL source server
> >> LOG:  startup process (PID 22980) exited with exit code 1
> >> LOG:  aborting startup due to startup process failure
> >>
> >> Now, you might certainly argue that this is a stupid thing to do (my
> >> motivation was to test some stuff) but certainly it's fair to say
> >> that
> >> error message is darn misleading, since in fact recovery_connections
> >> was NOT disabled.  I believe this is the same "start up from a shut
> >> down checkpoint" problem that's been discussed previously so I won't
> >> belabor the point other than to say that
> >
> > I don't think it is the same thing at all. This is a separate error
> > and
> > should be rejected as such.

I can't duplicate this error based upon what you have said.

With just standby_mode = 'on' the standby just waits forever, with a ps
message set to 
postgres: startup process   waiting for 000000010000000000000000

That's not very good, but it isn't the error you describe.

-- Simon Riggs           www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Compile fail, alpha5 & gcc 4.3.3 in elog.c
Next
From: Robert Haas
Date:
Subject: Re: Compile fail, alpha5 & gcc 4.3.3 in elog.c