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 
( 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 :, depending on 
your client it might be supported. It is not supported - yet ? - by the 
node-postgres driver.

    On Wednesday, February 14, 2018, 3:29:03 PM GMT+1, Venkateswaran 
<> wrote:  

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:


Reply via email to