[pgpool-general: 4212] Working wiht pgpool and one master and one slave

JotaComm jota.comm at gmail.com
Tue Nov 17 06:40:44 JST 2015


Could you help me?

I have one master and one slave in my environment. I configured my
pgpool.conf such as below:

listen_addresses = '*'

port = 9999

backend_hostname0 = master'
backend_port0 = 5432
backend_weight0 = 0
backend_data_directory0 = '/tmp/data/'

backend_hostname1 = 'slave'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/tmp/data'

load_balance_mode = on

My target is: SELECT queries should be sent to the slave server and another
operations to the master server.

How I can simulated connections to the slave server?

Thank you.

Best regards

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20151116/ed08c559/attachment.html>

More information about the pgpool-general mailing list