From: david@lang.hm
To: Mathias Stjernström <mathias@globalinn.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: The state of PG replication in 2008/Q2?
Date: Thu, 21 Aug 2008 15:10:29 -0700 (PDT)
Message-ID: <alpine.DEB.1.10.0808211508220.24459@asgard.lang.hm> (raw)
In-Reply-To: <F58B66EE-6F38-4876-B0EF-C8C46740FF7D@globalinn.com>
References: <48ADABAF.8030602@drivefaster.net>
<F58B66EE-6F38-4876-B0EF-C8C46740FF7D@globalinn.com>
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
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-performance@postgresql.org
Cc: david@lang.hm, mathias@globalinn.com
Subject: Re: The state of PG replication in 2008/Q2?
In-Reply-To: <alpine.DEB.1.10.0808211508220.24459@asgard.lang.hm>
References: <48ADABAF.8030602@drivefaster.net> <F58B66EE-6F38-4876-B0EF-C8C46740FF7D@globalinn.com> <alpine.DEB.1.10.0808211508220.24459@asgard.lang.hm>
* 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