<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small">Hello,<br><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small">I'm configuring a pool PostgreSQL with 1 master and 2 slaves. My pgpool.conf:<br><br>backend_hostname0 = 'master1'<br>backend_port0 = 5432<br>backend_weight0 = 0<br>backend_data_directory0 = '/mnt/data/'<br><br>backend_hostname0 = 'slave1'<br>backend_port0 = 5432<br>backend_weight0 = 1<br>backend_data_directory0 = '/mnt/data/'<br><br>backend_hostname0 = 'slave2'<br>backend_port0 = 5432<br>backend_weight0 = 1<br>backend_data_directory0 = '/mnt/data/'<br><br>load_balance_mode = on<br><br>My PostgreSQL logs are:<br><br>/tmp/postgresql-master1-2016-04-22_153443.log<br><br>/tmp/postgresql-slave1-2016-04-22_153443.log<br><br>/tmp/postgresql-slave2-2016-04-22_153443.log<br><br>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.<br><br>Could you help me with this configuration?<br><br>Thanks a lot.<br><br>Best regards<br><br clear="all"></div>-- <br><div class="gmail_signature">JotaComm<br><a href="http://jotacomm.wordpress.com" target="_blank">http://jotacomm.wordpress.com</a></div>
</div>