[ADMIN] Changing max_connections after WAL slave configured not allowed? - 04-12-2012 , 06:38 PM
I stopped my slave, lowered max_connections to 100 on the primary,
restarted it, then started the slave back up and it wouldn't go:
2012-04-12 16:34:32 PDT FATAL: hot standby is not possible because
max_connections = 100 is a lower setting than on the master server (its
value was 200)
Which, OK, it _was_ 200 but now it's definitely 100. Is there a reason this
change cannot be made now?
wellsoliver (AT) gmail (DOT) com
Re: [ADMIN] Changing max_connections after WAL slave configured not allowed? - 04-12-2012 , 11:47 PM
On Fri, Apr 13, 2012 at 5:08 AM, Wells Oliver <wellsoliver (AT) gmail (DOT) com> wrote:
If you do not perform changes in standby server,Standby server will
shutdown automatically with above error message.
Please change "max_connection" parameter in postgresql.conf file of standby
server according primary server and then start the Standby server.
Thanks & Regards,