Skip site navigation (1) Skip section navigation (2)

Re: BUG #7549: max_connections check should query master when starting standby

From: Petteri Räty <petsku(at)petteriraty(dot)eu>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7549: max_connections check should query master when starting standby
Date: 2012-09-18 00:05:36
Message-ID: 5057BAD0.109@petteriraty.eu (view raw or flat)
Thread:
Lists: pgsql-bugs
On 17.9.2012 16.57, Fujii Masao wrote:
> On Tue, Sep 18, 2012 at 3:51 AM,  <petsku(at)petteriraty(dot)eu> wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference:      7549
>> Logged by:          Petteri Räty
>> Email address:      petsku(at)petteriraty(dot)eu
>> PostgreSQL version: 9.2.0
>> Operating system:   Linux or OS X
>> Description:
>>
>> On a streaming hot standby slave starting postgres:
>>
>>
>> LOG:  database system was interrupted while in recovery at log time
>> 2012-09-17 21:29:31 EEST
>> HINT:  If this has occurred more than once some data might be corrupted and
>> you might need to choose an earlier recovery target.
>> LOG:  entering standby mode
>> FATAL:  hot standby is not possible because max_connections = 20 is a lower
>> setting than on the master server (its value was 100)
>> LOG:  startup process (PID 51494) exited with exit code 1
>> LOG:  aborting startup due to startup process failure
>>
>> It was indeed the case that the limit was lower on the slave but to resolve
>> it I lowered the setting on the master:
>>
>> postgres=# SHOW max_connections;
>>  max_connections
>> -----------------
>>  20
>> (1 row)
>>
>> The slave should allow resolving the issue by not only changes on the slave
>> side but by checking if the master has been updated as well.
> 
> If you change the max_connections on the master, you need to take a
> fresh backup from the master and start the standby from it.
> 
> Regards,
> 

If that's the case then would make sense to document it in connection to
the output. I wouldn't have guessed that to be the case.

Regards,
Petteri


In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2012-09-18 03:55:03
Subject: Re: BUG #7552: where clause gets ignored on one of view fields
Previous:From: Fujii MasaoDate: 2012-09-17 23:57:12
Subject: Re: BUG #7549: max_connections check should query master when starting standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group