X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 28B649FB273 for ; Tue, 19 Sep 2006 16:57:49 -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 82216-10 for ; Tue, 19 Sep 2006 16:57:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 838A89FB24A for ; Tue, 19 Sep 2006 16:57:41 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1GPlzE-0005OB-SI for pgsql-admin@postgresql.org; Tue, 19 Sep 2006 16:14:32 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 51E394172; Tue, 19 Sep 2006 15:57:34 -0400 (EDT) Date: Tue, 19 Sep 2006 15:57:34 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Multi-Master Async Replication Message-ID: <20060919195734.GC16219@phlogiston.dyndns.org> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.562 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, SARE_SPEC_REPLICA X-Spam-Level: X-Archive-Number: 200609/203 X-Sequence-Number: 23117 On Tue, Sep 19, 2006 at 02:30:34PM -0300, Fernando Machado wrote: > Hi Guys, > > I'm looking for a replication solution for multimaster environment, with > asynchronous transfer thru sites. I saw pg-replicator, but the project's > last news are from 2001, and the solution runs only on 7.0 and 7.1 versions. > > I'm using pg 8.1.3 both sides, over linux. > > Do somebody has any tips?!?! AFAIK, there isn't anything that does this today. There have been various suggestions floated on how to emulate this with some contortions using Slony, but nothing out of the box. A -- Andrew Sullivan | ajs@crankycanuck.ca The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun