PostgreSql replication and load balancing ( is Slony-I a solution?)

From: "Jan Bilek" <bilekj(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSql replication and load balancing ( is Slony-I a solution?)
Date: 2007-05-01 15:36:00
Message-ID: 000901c78c06$6cdfd7d0$0100a8c0@ook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
We're building database system with replication. Slony-I seems to be a quite
good solution for the replication, but beside the replication
(master-to-multiple slaves), we need load balancing aswell - multiple users
will access the database at the same time=multiple queries.
Is Slony-I capable of load balancing and how to set it up? We searched the
web and some people mentioned that Slony-I could do load balancing, but
haven't found how to make Slony-I to do it.

Simple applications like pgpool could do load balancing, too, but they seem
to be too simple to be used as replication system.

Thanks for any help.

J.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2007-05-01 15:37:50 Re: IF function?
Previous Message Kevin Kempter 2007-05-01 15:12:41 STDERR vs. SYSLOG logging