PostgreSQL local replication
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.
Can anyone point me to a guide that explains how to combine pgpool and
slony1 together, and what to watch out for?
Thank you.
Leonard
Can anyone point me to a guide that explains how to combine pgpool and
slony1 together, and what to watch out for?
Unfortunately, I haven't seen any complete documents.
Look at PgPool's site at: <http://pgpool.projects.postgresql.org/>
Look in particular at the "master/slave mode".
If you have some more specific questions, I'm sure people can help.
Regards,
Jeff Davis