postgres replication was: Re: [mir-coders] mir high availability

[Chris]

Hi

OK some more options fron the postgres admins list:

  > erserver, slony, dbmirror are off the top of my head
  > for OSS ones ... then Command Prompt has their
  > replication solution, so that's four 

  And pgcluster, which does multi-master.

  http://article.gmane.org/gmane.comp.db.postgresql.admin/10077 

- eRServer
  I can't find downloads for this here...
  http://www.erserver.com/

- dbmirror seems to be included in the distro.

- pgcluster 
  Seems to only synchronous replication
  http://www.csra.co.jp/~mitani/jpug/pgcluster/en/

Slony-I looks like the best bet to me but this is just
from having a look around...

Chris

On Sun 28-Nov-2004 at 12:35:45AM +0000, Chris wrote:
> 
> On Thu 25-Nov-2004 at 06:08:39PM -0200, Pietro wrote:
> > 
> > i'm taking a look at pgreplicator[0] haa anyone used it?
> > 
> > [0] http://pgreplicator.sourceforge.net/
> 
> - Consider using PG Version >= 7.3.1 where replication is
>   included in the base distribution
>   (postgresql-7.3.x/contrib/dbmirror)
> 
>   http://www.infocopter.com/know-how/postgresql/replication.html
> 
> - Slony-I --- A replication system for PostgreSQL
>   Slony-I is a "master to multiple slaves"
>   replication system with cascading and failover. 
> 
>   http://gborg.postgresql.org/project/slony1/projdisplay.php
> 
> Slony-I looks promising, there are some docs here:
> 
>   http://gborg.postgresql.org/project/slony1/genpage.php?howto_idx