Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E79CC9FB409 for ; Wed, 4 Oct 2006 13:05:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 94535-08 for ; Wed, 4 Oct 2006 13:05:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 2237A9FB407 for ; Wed, 4 Oct 2006 13:05:05 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1GV9F1-0006gQ-0l; Wed, 04 Oct 2006 12:05:03 -0400 Subject: Re: postgres in HA constellation From: Brad Nicholson To: Bruno Wolff III Cc: Sebastian Reitenbach , pgsql-admin@postgresql.org In-Reply-To: <20061004154318.GB23343@wolff.to> References: <20061004112345.496B6C01A@ogo.rapideye.de> <20061004154318.GB23343@wolff.to> Content-Type: text/plain Date: Wed, 04 Oct 2006 12:05:02 -0400 Message-Id: <1159977902.15773.37.camel@dba5.int.libertyrms.com> Mime-Version: 1.0 X-Mailer: Evolution 2.6.2 (2.6.2-1.fc5.5) Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.243 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/25 X-Sequence-Number: 23328 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 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.