From: Brad Nicholson <bnichols@ca.afilias.info>
To: Bruno Wolff III <bruno@wolff.to>
Cc: Sebastian Reitenbach <itlistuser@rapideye.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: postgres in HA constellation
Date: Wed, 04 Oct 2006 12:05:02 -0400
Message-ID: <1159977902.15773.37.camel@dba5.int.libertyrms.com> (raw)
In-Reply-To: <20061004154318.GB23343@wolff.to>
References: <20061004112345.496B6C01A@ogo.rapideye.de>
<20061004154318.GB23343@wolff.to>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bnichols@ca.afilias.info, bruno@wolff.to, itlistuser@rapideye.de
Subject: Re: postgres in HA constellation
In-Reply-To: <1159977902.15773.37.camel@dba5.int.libertyrms.com>
References: <20061004112345.496B6C01A@ogo.rapideye.de> <20061004154318.GB23343@wolff.to> <1159977902.15773.37.camel@dba5.int.libertyrms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox