<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small"><br></div><div class="gmail_extra"><br><div class="gmail_quote">2016-04-23 2:05 GMT-03:00 Dennis Gearon <span dir="ltr"><<a href="mailto:gearond@gmail.com" target="_blank">gearond@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><p dir="ltr">Sorry about top posting. Gmail got away from me before I realized that I was writing a mail list.</p>
</blockquote></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small">Hello everybody,<br><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small">I would like to reproduce this scenery:<br><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small"><div style="" id="gt-input-tool"><div><span class=""></span></div></div><div id="gt-src-c" class=""><div id="gt-src-p"><span id="result_box" class="" lang="en"><span class="">The</span> <span class="">pgpool</span> <span class="">sends</span> <span>written</span> <span>queries to</span> <span>the</span> <span>master</span> <span>and</span> <span>read queries</span> <span>to</span> <span>the</span> <span>secondary</span><span class="">. Between the master server and the standby server there is a streaming replication.<br><br></span></span></div><div id="gt-src-p"><span id="result_box" class="" lang="en"><span class="">My pgpool.conf<br></span></span></div></div></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small"><br>backend_hostname0 = 'master1'<br>backend_port0 = 5432<br>backend_weight0 = 1<br>backend_data_directory0 = '/data/pgdata'<br><br>backend_hostname1 = 'slave1'<br>backend_port1 = 5432<br>backend_weight1 = 1<br>backend_data_directory1 = '/data/pgdata'<br><br>backend_hostname2 = 'slave2'<br>backend_port2 = 5432<br>backend_weight2 = 1<br>backend_data_directory2 = '/data/pgdata'<br><br>load_balance_mode = on<br><br>When I execute: SHOW pool_nodes; I receive:<br><br> SHOW pool_nodes;<br> node_id | hostname | port | status | lb_weight | role | select_cnt<br>---------+------------+------+--------+-----------+--------+------------<br> 0 | master1 | 5432 | 2 | 0.333333 | master | 1<br> 1 | slave1 | 5432 | 0 | 0.333333 | slave | 0<br> 2 | slave2 | 5432 | 0 | 0.333333 | slave | 0<br>(3 rows)<br><br>Status = 0 - this state is only used during the initialization. PCP will never display it.<br><br>Could you help me?<br><br>Thanks a lot.<br><br>Best regards<br><br><br></div>-- <br><div class="gmail_signature">JotaComm<br><a href="http://jotacomm.wordpress.com" target="_blank">http://jotacomm.wordpress.com</a></div>
</div></div>