回复: pg_ctl promote - Mailing list pgsql-admin

From 杨涛涛
Subject 回复: pg_ctl promote
Date
Msg-id 726aa536.9e9c.143b44a8120.Coremail.daxiong00@163.com
Whole thread Raw
In response to pg_ctl promote  (sparikh <sparikh@carcharging.com>)
List pgsql-admin
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@carcharging.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@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-admin


pgsql-admin by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: strem replication standby lag check
Next
From: Murthy Nunna
Date:
Subject: Re: Postgresql v9.2.4 Kerberos Client Authentication