hi, i tried the exact setup that you described here, but unfortunately i had to
restart the new master(former slave) in order to get the new settings and this
will conduct to a downtime and service interruption.
anyway thanks for sharing your experience.
Adrian Videanu
--- On Fri, 4/20/12, jenopob [via PostgreSQL]
<ml-node+s1045698n5653287...@n5.nabble.com> wrote:
From: jenopob [via PostgreSQL] <ml-node+s1045698n5653287...@n5.nabble.com>
Subject: Re:Re:Re: How to auto swtich the roles of primary and standby
To: "videanuadrian" <videanuadr...@yahoo.com>
Date: Friday, April 20, 2012, 6:18 AM
hi thereI prepared two postgresql.conf on the servers ,use shell script
to change which config should use .there are some config fields not the smae
between the two config files .At 2012-04-19
18:47:26,"videanuadrian [via PostgreSQL]" <[hidden email]> wrote:
so, just to make sure that i understand:
after the master failed, the slave become the new master, the you have changed
postgresql.conf from master to slave and viceversa and restarted the old master
as slave ?
--- On Thu, 4/19/12, jenopob [via PostgreSQL] <[hidden email]> wrote:
From: jenopob [via PostgreSQL] <[hidden email]>
Subject: Re:Re: How to auto swtich the roles of primary and standby
To: "videanuadrian" <[hidden email]>
Date: Thursday, April 19, 2012, 5:34 AM
hi we did a new shell script named recovery_config_chage.sh at standby
server.the script I wanted to change the fail down postgres master config ,let
it start as standby serverand build the communication with the former standby
now is master server,then started it by remotestart.sh the above hopes to help
you something At 2012-04-17 13:42:50,"videanuadrian [via PostgreSQL]" <[hidden
email]> wrote:
Hi there,
i have the exact same problem. Did you find a solution for this ?
thanks,
Adrian Videanu
If you reply to this email, your message will be added to the
discussion below:
http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5645680.html
To unsubscribe from How to auto swtich the roles of primary and
standby, click here.
NAML
If you reply to this email, your message will be added to the
discussion below:
http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5650704.html
To unsubscribe from How to auto swtich the roles of primary and
standby, click here.
NAML
If you reply to this email, your message will be added to the
discussion below:
http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5651436.html
To unsubscribe from How to auto swtich the roles of primary and
standby, click here.
NAML
If you reply to this email, your message will be added to the
discussion below:
http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5653287.html
To unsubscribe from How to auto swtich the roles of primary and
standby, click here.
NAML
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5653410.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
