dbTalk Databases Forums  

[ADMIN] Changing max_connections after WAL slave configured not allowed?

mailing.database.pgsql-admin mailing.database.pgsql-admin


Discuss [ADMIN] Changing max_connections after WAL slave configured not allowed? in the mailing.database.pgsql-admin forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Wells Oliver
 
Posts: n/a

Default [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?

--
Wells Oliver
wellsoliver (AT) gmail (DOT) com

Reply With Quote
  #2  
Old   
raghu ram
 
Posts: n/a

Default 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:

Quote:
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?


Whenever you modify the configuration parameters in Primary server,those
changes needs to apply manually in standby server.

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,

Raghu Ram

EnterpriseDB: http://www.enterprisedb.com

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.