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
