Skip site navigation (1) Skip section navigation (2)

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

From: videanuadrian <videanuadrian(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to auto swtich the roles of primary and standby
Date: 2012-04-19 10:47:26
Message-ID: 1334832426.97159.YahooMailClassic@web160205.mail.bf1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
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] <ml-node+s1045698n5650704h68(at)n5(dot)nabble(dot)com> wrote:

From: jenopob [via PostgreSQL] <ml-node+s1045698n5650704h68(at)n5(dot)nabble(dot)com>
Subject: Re:Re: How to auto swtich the roles of primary and standby
To: "videanuadrian" <videanuadrian(at)yahoo(dot)com>
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
	

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5651436.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

In response to

Responses

pgsql-admin by date

Next:From: Devrim GÜNDÜZDate: 2012-04-19 15:20:11
Subject: Re: Unending DB migration
Previous:From: Kshirsagar, SwanandDate: 2012-04-19 10:23:01
Subject: ERROR: invalid input syntax for type timestamp: ""

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group