Re: postgres in HA constellation - Mailing list pgsql-admin

From Brad Nicholson
Subject Re: postgres in HA constellation
Date
Msg-id 1159977902.15773.37.camel@dba5.int.libertyrms.com
Whole thread Raw
In response to Re: postgres in HA constellation  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-admin
On Wed, 2006-10-04 at 10:43 -0500, Bruno Wolff III wrote:
> On Wed, Oct 04, 2006 at 11:23:45 -0000,
>   Sebastian Reitenbach <itlistuser@rapideye.de> wrote:

> If you have multiple data centers to protect against disaster, then you might
> look at SLONY which you can use to replicate to a slave system. However, I
> think it is possible for the master to report a transaction as commited
> before it is shipped off to the slave, so that if the master fails you might
> lose some transactions when switching to the slave. But double check with
> the SLONY documentation on this.

This is indeed accurate, and highly likely to happen if you need to do a
fail over.  It all depends on the level of activity.

Brad.


pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Recursive use
Next
From: n0g0013
Date:
Subject: non-standard 'CREATE INDEX' problem