Thread: PostgreSQL local replication

PostgreSQL local replication

From
Leonard Soetedjo
Date:
Hi,

I'm currently using PostgreSQL 8.0.3 and would like to have a load-
balancing and failover solution over LAN.

From reading the mailing list, it seems that pgpool and slony1
combination has been recommended for LAN replication.  But seems that
pgcluster is still actively maintained?  Which one should I proceed
with?

It seems that pgcluster is simpler to set up, and pgpool/slony1 seems to
have a few caveats (well, pgcluster might have too, but not stated).  So
I think it's best to get some advice from the PostgreSQL folks.


Thanks,

Leonard