X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A15C9D9156 for ; Fri, 16 Sep 2005 11:59:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91100-01 for ; Fri, 16 Sep 2005 14:59:21 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 7E8A1D9160 for ; Fri, 16 Sep 2005 11:59:20 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 16 Sep 2005 09:59:18 -0500 Subject: Re: Replication From: Scott Marlowe To: vespadict@gmail.com Cc: pgsql-admin@postgresql.org In-Reply-To: <432A83E5.1000507@gmail.com> References: <432A83E5.1000507@gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1126882758.30120.26.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Fri, 16 Sep 2005 09:59:18 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 required=5 tests=[AWL=0.005] X-Spam-Level: X-Archive-Number: 200509/184 X-Sequence-Number: 18921 On Fri, 2005-09-16 at 03:35, vespadict wrote: > Hello, > > I need to replicate two databases in diferents servers . I'm reading > about some projects but i'm not sure what is the best option. I found > interesting dbmirror and pgcluster but I have doubts . Please , May you > help me ? . Do you need automatic failover of some kind, async or sync replication, one way or two way, etc... My personal favorite two tools of late have been pgpool and slony. dbmirror, if I remember correctly, has to be installed by modifying the internals of postgresql, and I'm not sure how up to date it is. Pgcluster seems to be a decent choice, but I've not played with it.