Postgres Pro
Downloads
Home   >   mailing lists

Changing max_connections after WAL slave configured not allowed? - Mailing list pgsql-admin

From Wells Oliver
Subject Changing max_connections after WAL slave configured not allowed?
Date
Msg-id CAOC+FBXLMfyw5Wz4U+jDUt4yFim5HaPnd3+BgKpfBq9UODDghQ@mail.gmail.com
Whole thread Raw
Responses Re: Changing max_connections after WAL slave configured not allowed?  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-admin
Tree view
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?

--
Wells Oliver
wellsoliver@gmail.com

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Definitive logrotate solution?
Next
From: raghu ram
Date:
Subject: Re: Changing max_connections after WAL slave configured not allowed?