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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026