Re: Replication status

Michael Meskes wrote:
> On Mon, May 27, 2002 at 05:12:33PM -0400, Bruce Momjian wrote:
> > Last I talked to Darren, the replication code was modified to merge into
> > our 7.2 tree.  There are still pieces missing so it will not be
> > functional when applied.  It is remotely possible there could be
> > master-slave in 7.3, but I doubt it.
> 
> This is about pgreplication I think. Is the the replication project of
> choice for pgsql? IIRC there quite some projects for this topic:
> 
> PostgreSQL replicator
> Rserver
> Usogres
> dbbalancer
> 
> What about these? We seem to have some proof-of-concept code of rserver
> in contrib. Dbbalancer seems to be more focussed on balancing access and
> not replication, but can do this too.

rserver only does single-master, while most people want multi-master. 
Usogres is more of a load balancer/replication, where the query is sent
to both servers.  Not sure about the others.

The only multi-master solution proposed is pgreplication.  I think there
is a PDF on that web site that describes the various replication
options. I should probably write up a little replication FAQ.

Jan is doing a replication talk at O'Reilly in July and hopefully we can
get a PDF of that.

pgreplication is not good for nodes over slow links or nodes that are
intermittently connected, so it is not going to solve all cases either.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026