On Wed, Feb 14, 2018 at 2:27 PM, Pierre Timmermans <ptim...@yahoo.com> wrote:
> 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 that.https://www.last.fm/user/Russ/journal/2008/02/21/zd_postgres_connection_pools:_pgpool_vs._pgbouncer <https://www.last.fm/user/Russ/journal/2008/02/21/zd_postgres_connection_pools:_pgpool_vs._pgbouncer>* *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.
