Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 633AB64FD04 for ; Thu, 21 Aug 2008 19:10:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 78683-06 for ; Thu, 21 Aug 2008 19:09:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from bifrost.lang.hm (mail.lang.hm [64.81.33.126]) by postgresql.org (Postfix) with ESMTP id D2BDD64FCFF for ; Thu, 21 Aug 2008 19:10:01 -0300 (ADT) Received: from asgard.lang.hm (asgard.lang.hm [10.0.0.100]) by bifrost.lang.hm (8.13.4/8.13.4/Debian-3) with ESMTP id m7LM9tGE022580; Thu, 21 Aug 2008 15:09:55 -0700 Date: Thu, 21 Aug 2008 15:10:29 -0700 (PDT) From: david@lang.hm X-X-Sender: dlang@asgard.lang.hm To: =?ISO-8859-15?Q?Mathias_Stjernstr=F6m?= cc: pgsql-performance@postgresql.org Subject: Re: The state of PG replication in 2008/Q2? In-Reply-To: Message-ID: References: <48ADABAF.8030602@drivefaster.net> User-Agent: Alpine 1.10 (DEB 962 2008-03-14) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.899 tagged_above=0 required=5 tests=FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 200808/268 X-Sequence-Number: 31149 On Thu, 21 Aug 2008, Mathias Stjernstr?m wrote: > Hi Dan! > > Its true, many of the replication options that exists for PostgreSQL have not > seen any updates in a while. > > If you only looking for redundancy and not a performance gain you should look > at PostgreSQL PITR > (http://www.postgresql.org/docs/8.1/static/backup-online.html) > > For Master-Slave replication i think that Slony http://www.slony.info/ is > most up to date. But it does not support DDL changes. > > You may wich to look at pgpool http://pgpool.projects.postgresql.org/ it > supports Synchronous replication (wich is good for data integrity, but can be > bad for performance). > > These are some of the open source options. I do not have any experience with > the commercial onces. a couple of months ago there was a lot of news about a WAL based replication engine. one that was closed source, but possibly getting opened shortly, and also the decision by the core devs to add one into the base distro. what's been happening on this front? from my understanding the first versions of this would not support queries of the replica, but would provide for the consistancy needed for reliable failover. David Lang