回复: pg_ctl promote

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(at)carcharging(dot)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(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-admin