Обсуждение: PostgreSQL local replication

Поиск
Список
Период
Сортировка

PostgreSQL local replication

От
Leonard Soetedjo
Дата:
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