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

From: petsku(at)petteriraty(dot)eu
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7549: max_connections check should query master when starting standby
Date: 2012-09-17 18:51:50
Message-ID: E1TDgQA-0003l9-Hq@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Regards,
Petteri

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message tom 2012-09-17 19:32:30 BUG #7550: NULL result when coercing a subquery result into an array
Previous Message Freddie Burgess 2012-09-17 17:23:08 Re: Postgres JDBC-hibernate Problem