Re: pg_ctl promote

2014/1/20 sparikh <sparikh(at)carcharging(dot)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(at)postgresql(dot)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