<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small">Hi,<br><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small">Another information, I'm using streaming replication between master and slaves.<br><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small">Thank you.<br><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small">Best regards.<br><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-04-22 16:36 GMT-03:00 JotaComm <span dir="ltr"><<a href="mailto:jota.comm@gmail.com" target="_blank">jota.comm@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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<span class="HOEnZb"><font color="#888888"><br><br clear="all"></font></span></div><span class="HOEnZb"><font color="#888888">-- <br><div>JotaComm<br><a href="http://jotacomm.wordpress.com" target="_blank">http://jotacomm.wordpress.com</a></div>
</font></span></div>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature">JotaComm<br><a href="http://jotacomm.wordpress.com" target="_blank">http://jotacomm.wordpress.com</a></div>
</div>