Re: How to auto swtich the roles of primary and standby

Поиск
Список
Период
Сортировка
От videanuadrian
Тема Re: How to auto swtich the roles of primary and standby
Дата
Msg-id 1334901683.17673.YahooMailClassic@web160204.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на How to auto swtich the roles of primary and standby  (jenopob <jenopob@126.com>)
Список pgsql-admin
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] <[hidden email]> wrote:

From: jenopob [via PostgreSQL] <[hidden email]>
Subject: Re:Re:Re: How to auto swtich the roles of primary and standby
To: "videanuadrian" <[hidden email]>
Date: Friday, April 20, 2012, 6:18 AM

hi there
I 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 server
and 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: Re:Re:Re: How to auto swtich the roles of primary and standby
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

В списке pgsql-admin по дате отправления:

Предыдущее
От: amador alvarez
Дата:
Сообщение: Re: Urgent help required
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: ERROR: invalid input syntax for type timestamp: ""