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

From Robert Haas
Subject Re: master in standby mode croaks
Date
Msg-id 1071169547301396447@iso-8859-1msgid
Whole thread Raw
In response to Re: master in standby mode croaks  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
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 still think we need to fix this.
>
> Agreed, as a separate issue.

OK, fair enough. I admit I didn't investigate what was causing this.

...Robert


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Compile fail, alpha5 & gcc 4.3.3 in elog.c
Next
From: Tom Lane
Date:
Subject: Re: pgstattuple does not contain CHECK_FOR_INTERRUPTS()