Re: postgres in HA constellation

[Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>]

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(at)rapideye(dot)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.