<p dir="ltr">Not sure, but I don't think you can name 'backend_hostname0' three times and get three different servers. Perhaps some unmodified cutting and pasting late in the day?</p>
<p dir="ltr">Perhaps u meant:</p>
<p dir="ltr">backend_hostname0<br>
.<br>
.<br>
.</p>
<p dir="ltr">backend_hostname1<br>
.<br>
.<br>
.</p>
<p dir="ltr">backend_hostname2<br>
.<br>
.<br>
.</p>
<div class="gmail_quote">On Apr 22, 2016 1:16 PM, "JotaComm" <<a href="mailto:jota.comm@gmail.com">jota.comm@gmail.com</a>> wrote:<br type="attribution"><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">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><font color="#888888"><br><br clear="all"></font></span></div><span><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>JotaComm<br><a href="http://jotacomm.wordpress.com" target="_blank">http://jotacomm.wordpress.com</a></div>
</div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div>