PostgreSQL local replication

From: Leonard Soetedjo <stelar(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL local replication
Date: 2005-09-06 02:39:44
Message-ID: b9180baa05090519397a01595b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F. O'Connell 2005-09-06 03:35:49 Re: Insert Ignore or something similar...
Previous Message Tom Lane 2005-09-06 01:14:48 Re: Setting up a database for 10000 concurrent users