<div dir="ltr"><div><div><div>Nevermind,<br><br>somehow I found that if "show pool_nodes;" gives status 0 you can <i>manually</i> bring it to status2 by:<br><br></div><div style="margin-left:40px"><span style="font-family:monospace,monospace">pcp_attach_node 1 localhost 9898 login pass <node_id><br></span></div><br></div>It'd be nice if documentation mentioned, that if you have for whatever reason status 0 just use pcp_attach_node.<br></div>It doesn't and it is not as obvious as it seems.<br><div><br></div><div>regards<br></div><div>RB<br></div><div><div><div><span style="font-family:monospace,monospace"></span></div></div></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature">Roman Barczyński</div></div>
<br><div class="gmail_quote">On Fri, Nov 27, 2015 at 1:52 PM, Roman Barczyński <span dir="ltr"><<a href="mailto:rombar@gmail.com" target="_blank">rombar@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div>Hello,<br><br></div>I can't make load balancing to work, all queries are sent to backend0 (primary), even if I set very small weight:<br><br><div style="margin-left:40px"><span style="font-family:monospace,monospace">$ psql -h pgpool -c "show pool_nodes;" -n<br> node_id | hostname | port | status | lb_weight | role <br>---------+------------+------+--------+-----------+---------<br> 0 | 10.0.0.1 | 5432 | 2 | 0.000500 | primary<br> 1 | 10.0.0.2 | 5432 | 0 | 0.499750 | standby<br> 2 | 10.0.0.3 | 5432 | 0 | 0.499750 | standby</span><br></div><br></div>Each node is accesible and if I swap backend_host0 for second IP every query is sent to it. Additionally primary node is not detected when its IP is in backend_host1 or backend_host2:<br><br><div style="margin-left:40px"><span style="font-family:monospace,monospace">$ psql -h pgpool -c "show pool_nodes;" -n</span><br><span style="font-family:monospace,monospace"> node_id | hostname | port | status | lb_weight | role </span><br><span style="font-family:monospace,monospace">---------+------------+------+--------+-----------+---------</span><br></div><div style="margin-left:40px"><span style="font-family:monospace,monospace"> 0 | 10.0.0.2 | 5432 | 2 | 0.000500 | standby</span><br></div><div style="margin-left:40px"><span style="font-family:monospace,monospace"> 1 | 10.0.0.1 | 5432 | 0 | 0.499750 | standby</span><br><span style="font-family:monospace,monospace"> 2 | 10.0.0.3 | 5432 | 0 | 0.499750 | standby</span><br></div><div><br><br>My config:<br><br><div style="margin-left:40px"><span style="font-family:monospace,monospace">listen_addresses = '*'<br>port = 5432<br>pcp_port = 9898<br><br>backend_hostname0 = '10.0.0.1'<br>backend_port0 = 5432<br>backend_weight0 = 1<br><br>backend_hostname1 = '10.0.0.2'<br>backend_port1 = 5432<br>backend_weight1 = 1000<br><br>backend_hostname2 = '10.0.0.3'<br>backend_port2 = 5432<br>backend_weight2 = 1000<br><br>enable_pool_hba = on<br>pool_passwd = 'pool_passwd'<br><br>ssl = off<br>num_init_children = 32<br>max_pool = 4<br>child_life_time = 300<br>child_max_connections = 0<br>connection_life_time = 0<br>client_idle_limit = 0<br><br>connection_cache = off<br>reset_query_list = 'ABORT; DISCARD ALL'<br><br>replicate_select = off<br><br>master_slave_mode = on<br>master_slave_sub_mode = 'stream'<br>sr_check_period = 0<br>sr_check_user = 'replica_test'<br>sr_check_password = 'replica_test'<br>delay_threshold = 0<br><br>wd_lifecheck_query = 'SELECT 1'<br>wd_lifecheck_dbname = 'template1'<br>wd_lifecheck_user = 'replica_test'<br>wd_lifecheck_password = 'replica_test'<br><br>load_balance_mode = on<br>ignore_leading_white_space = on<br>white_function_list = ''<br>black_function_list = 'nextval,setval'<br></span></div><div><div><div><div><div><br></div><div>Any advice?<span class="HOEnZb"><font color="#888888"><br></font></span></div><span class="HOEnZb"><font color="#888888"><div><br clear="all"><div><div>Roman Barczyński</div></div>
</div></font></span></div></div></div></div></div></div>
</blockquote></div><br></div>