pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_ctl promote
3+ messages / 2 participants
[nested] [flat]
* pg_ctl promote
@ 2014-01-20 05:39 sparikh <sparikh@carcharging.com>
0 siblings, 1 reply; 3+ messages in thread
From: sparikh @ 2014-01-20 05:39 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_ctl promote
@ 2014-01-20 12:31 desmodemone <desmodemone@gmail.com>
parent: sparikh <sparikh@carcharging.com>
0 siblings, 1 reply; 3+ messages in thread
From: desmodemone @ 2014-01-20 12:31 UTC (permalink / raw)
To: sparikh <sparikh@carcharging.com>; +Cc: pgsql-admin
2014/1/20 sparikh <sparikh@carcharging.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@postgresql.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_ctl promote
@ 2014-01-21 17:45 sparikh <sparikh@carcharging.com>
parent: desmodemone <desmodemone@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: sparikh @ 2014-01-21 17:45 UTC (permalink / raw)
To: pgsql-admin
Thanks much on your quick reply.
If I understood it correctly, If I am setting up it as only dedicated
primary server then no changes in conf file required. If I will have to set
up the new stand by to point this new primary then I will have to make the
configuration file changes.
Thanks Again.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-ctl-promote-tp5787858p5788115.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2014-01-21 17:45 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-01-20 05:39 pg_ctl promote sparikh <sparikh@carcharging.com>
2014-01-20 12:31 ` desmodemone <desmodemone@gmail.com>
2014-01-21 17:45 ` sparikh <sparikh@carcharging.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox