[pgpool-general: 4651] PostgreSQL + Pgpool with 1 master and 2 slaves

[JotaComm]

Hello,

I'm configuring a pool PostgreSQL with 1 master and 2 slaves. My
pgpool.conf:

backend_hostname0 = 'master1'
backend_port0 = 5432
backend_weight0 = 0
backend_data_directory0 = '/mnt/data/'

backend_hostname0 = 'slave1'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/mnt/data/'

backend_hostname0 = 'slave2'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/mnt/data/'

load_balance_mode = on

My PostgreSQL logs are:

/tmp/postgresql-master1-2016-04-22_153443.log

/tmp/postgresql-slave1-2016-04-22_153443.log

/tmp/postgresql-slave2-2016-04-22_153443.log

I would like to see the write queries in
/tmp/postgresql-master1-2016-04-22_153443.log and the SELECT queries in my
logs: /tmp/postgresql-slave1-2016-04-22_153443.log and
/tmp/postgresql-slave2-2016-04-22_153443.log. I'm using the psql client to
test.

Could you help me with this configuration?

Thanks a lot.

Best regards

-- 
JotaComm
http://jotacomm.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160422/5b75c201/attachment.html>