Thread: pg_ctl promote
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.
2014/1/20 sparikh <sparikh@carcharging.com>
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@postgresql.org)
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
You mean just a single dedicated database server? If "yes", nothing changes to the configuration file.
At 2014-01-20 13:39:20,sparikh <sparikh@carcharging.com> wrote: >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@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-admin
Thanks much on your quick reply. If I understood it correctly, If I am setting up it as only dedicated primary server then no changes in conf file required. If I will have to set up the new stand by to point this new primary then I will have to make the configuration file changes. Thanks Again. -- View this message in context: http://postgresql.1045698.n5.nabble.com/pg-ctl-promote-tp5787858p5788115.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.