Re: pg 9.0, streaming replication, fail over and fail back strategies

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg 9.0, streaming replication, fail over and fail back strategies
Date: 2010-08-18 15:37:49
Message-ID: AANLkTinUvjtDzYXB3NHgEyYaHoOE5mXzgBChWrTS00dB@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 9, 2010 at 6:10 PM, Kyle R. Burton <kyle(dot)burton(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-08-18 15:41:50 Re: Partitioning into thousands of tables?
Previous Message Alvaro Herrera 2010-08-18 15:37:17 Re: Win32 Backend Cash - pre-existing shared memory block is still in use