Re: Switchover of Master and Slave roles - Mailing list pgsql-admin

From Ray Stell
Subject Re: Switchover of Master and Slave roles
Date
Msg-id 20110607181244.GA3861@cns.vt.edu
Whole thread Raw
In response to Switchover of Master and Slave roles  (A J <s5aly@yahoo.com>)
Responses Re: Switchover of Master and Slave roles  (A J <s5aly@yahoo.com>)
List pgsql-admin
On Tue, Jun 07, 2011 at 09:32:31AM -0700, A J wrote:
> Hello,
> I am trying to switch the master and slave roles in a test I am doing with
> streaming replication in 9.1 beta.
>

http://www.postgresql.org/docs/9.1/static/warm-standby-failover.html

Once failover to the standby occurs, there is only a single server in
operation. This is known as a degenerate state. The former standby is
now the primary, but the former primary is down and might stay down. To
return to normal operation, a standby server must be recreated, either
on the former primary system when it comes up, or on a third, possibly
new, system. Once complete, the primary and standby can be considered
to have switched roles.

pgsql-admin by date:

Previous
From: "Mark Johnson"
Date:
Subject: Re: How I do Configuration for Postgresql-oracle db link?
Next
From: A J
Date:
Subject: Re: Switchover of Master and Slave roles