On Wed, Feb 14, 2018 at 2:27 PM, Pierre Timmermans <ptim...@yahoo.com>

> pgpool does just that: it enables you to use the standby database as a
> read only while other queries are sent to the primary database only (
> http://www.pgpool.net/). Good product and good support (on the list°
> This looks a very interesting possibility, although it is more related to
> automated failover than to load balancing of read only queries :
> http://paquier.xyz/postgresql-2/postgres-10-libpq-read-write/, depending
> on your client it might be supported. It is not supported - yet ? - by the
> node-postgres driver.
> Regards,
> Pierre
> On Wednesday, February 14, 2018, 3:29:03 PM GMT+1, Venkateswaran <
> venkateswaran.s...@gmail.com> wrote:
> Hi,
> I am also trying to split read and write queries, where reads should go to
> the slave server (streaming replication) and writes to the master server.
> Any tool available to perform this activity instead of two connection pool?
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-general-
> f1843780.html

*Actually, if you are looking for load balancing PgBouncer is better than
PgPool. There is a nice article about

*I used PgBouncer in a few of ny previous positions and found it to be very
fast and efficient.*

*Melvin Davidson*
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

Reply via email to