PostgreSql replication and load balancing ( is Slony-I a solution?) - Mailing list pgsql-general

From Jan Bilek
Subject PostgreSql replication and load balancing ( is Slony-I a solution?)
Date
Msg-id 000901c78c06$6cdfd7d0$0100a8c0@ook
Whole thread Raw
Responses Re: PostgreSql replication and load balancing ( is Slony-I a solution?)
List 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.


pgsql-general by date:

Previous
From: Kevin Kempter
Date:
Subject: STDERR vs. SYSLOG logging
Next
From: Erik Jones
Date:
Subject: Re: IF function?