pg_ctl promote - Mailing list pgsql-admin

From sparikh
Subject pg_ctl promote
Date
Msg-id 1390196360741-5787858.post@n5.nabble.com
Whole thread Raw
Responses Re: pg_ctl promote
回复: pg_ctl promote
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: yhe
Date:
Subject: strem replication standby lag check
Next
From: desmodemone
Date:
Subject: Re: pg_ctl promote