Re: pg_ctl promote

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 






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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux