2014/1/20 sparikh <sparikh@xxxxxxxxxxxxxxx>
Hi,
I have recently tried pg_ctl promote to promote one of our standby server to
promote as primary server.
Eventually I will be doing this in production.
I could successfully execute the pg_ctl promote command. My only question do
I have to change postgresql.conf and pg_hba.conf files manually to have
parameters/settings specificto read/write server.
For example:
hot_standby to off from on in postgresql.conf
host replication all (remove this from pg_hba.conf)
Thanks.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-ctl-promote-tp5787858.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
If you will promote your replica to master (open read/write mode) , you will not need to change the hot_standby parameter in postgresql.conf , because it will not affect the database with primary role.
The rule "host replication all" influces only who could connect to your new primary to create a hot standby database / streaming replication.
Bye
Mat
