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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-admin
