[pgpool-general: 5030] Force connection to always go to master

Avi Weinberg AviW at gilat.com
Mon Sep 26 23:53:48 JST 2016

Hi all,

I have a master slave setup with automatic failover.  The classic configuration is to have read queries go to the slave and write+read to the master.  However,  this classic routing to slave and master is not so good to me.  I have modules that must read the most recent data and have other modules that for them it is also ok to read data that is 1-2 transactions behind.  Is it possible to (without using functions for each of the statements) to direct the critical read queries to the master and the less critical read queries to the slave.  I use hibernate so I cannot modify the query just play with the connections.

How can I force a connection to always go to the master
How can I force a connection to go to the slave if the slave is alive and go to the master if the slave is dead.

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160926/71372d11/attachment.html>

More information about the pgpool-general mailing list