Thread: 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