Re: pg 9.0, streaming replication, fail over and fail back strategies - Mailing list pgsql-general

From Vick Khera
Subject Re: pg 9.0, streaming replication, fail over and fail back strategies
Date
Msg-id AANLkTinUvjtDzYXB3NHgEyYaHoOE5mXzgBChWrTS00dB@mail.gmail.com
Whole thread Raw
In response to pg 9.0, streaming replication, fail over and fail back strategies  ("Kyle R. Burton" <kyle.burton@gmail.com>)
List pgsql-general
On Mon, Aug 9, 2010 at 6:10 PM, Kyle R. Burton <kyle.burton@gmail.com> wrote:
> Is there any way to get PostgreSQL to bind to a new ip address and
> interface without actually shutting it down?  If it could, would I
> need to break all the current (read only) client connections to get
> them to reconnect and have the ability to write?  (am I confused about
> this?)

What if you make the virtual IP instead be a shared IP using the CARP
protocol, and have only one host be the master at any given time.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Win32 Backend Cash - pre-existing shared memory block is still in use
Next
From: Vick Khera
Date:
Subject: Re: Partitioning into thousands of tables?