pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (17+ messages)  latest in thread

Message-ID: <alpine.DEB.1.10.0808211508220.24459@asgard.lang.hm>
Permalink:  ../alpine.DEB.1.10.0808211508220.24459@asgard.lang.hm/
Also on:    postgresql.org/message-id/alpine.DEB.1.10.0808211508220.24459@asgard.lang.hm

 · 

reply

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