<div dir="ltr"><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Kirill Galinurov</b> <span dir="ltr"><<a href="mailto:k.galinurov@gmail.com">k.galinurov@gmail.com</a>></span><br>Date: 2016-12-13 8:11 GMT+03:00<br>Subject: Re: [pgpool-general: 5162] pgpool config error<br>To: Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>><br><br><br><div dir="ltr">I can connect with psql. From one pgpool node to other. And to the postgresql server's/<div><div>[root@SBC-MSK var]# psql -U postgres -h 172.20.200.3 -p 5433</div><div>Password for user postgres: </div><div>psql (9.6.1)</div><div>Type "help" for help.</div><div><br></div><div>postgres=# exit</div><div>postgres-# \q</div><div>[root@SBC-MSK var]# psql -U postgres -h 172.20.200.3 -p 5432</div><div>Password for user postgres: </div><div>psql (9.6.1)</div><div>Type "help" for help.</div><div><br></div><div>root@sbc-spb pgpool-II]# psql -h 172.20.200.2 -p 5433 -U postgres</div><div>Password for user postgres: </div><div>DEBUG: CommitTransaction</div><div>DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: </div><div>psql (9.6.1)</div><div>Type "help" for help.</div><div><br></div><div>postgres=# </div><div><br></div><div>[root@sbc-spb pgpool-II]# psql -h 172.20.200.2 -p 5432 -U postgres</div><div>Password for user postgres: </div><div>psql (9.6.1)</div><div>Type "help" for help.</div><div><br></div><div>postgres=# </div></div><div><br></div><div>1-node</div><div><span style="font-family:monospace"><span style="color:rgb(0,0,0)">tcp 0 0 <a href="http://0.0.0.0:5432" target="_blank">0.0.0.0:5432</a> 0.0.0.0:* LISTEN 11551/pgpool </span><br>tcp 0 0 <a href="http://127.0.0.1:25" target="_blank">127.0.0.1:25</a> 0.0.0.0:* LISTEN 2392/master <br>tcp 0 0 <a href="http://0.0.0.0:5433" target="_blank">0.0.0.0:5433</a> 0.0.0.0:* LISTEN 1218/postmaster <br></span><span style="font-family:monospace"><span style="color:rgb(0,0,0)">tcp 0 0 <a href="http://0.0.0.0:9000" target="_blank">0.0.0.0:9000</a> 0.0.0.0:* LISTEN 11552/pgpool: watch </span><br>
</span><span style="font-family:monospace"><span style="color:rgb(0,0,0)">udp 0 0 <a href="http://0.0.0.0:9694" target="_blank">0.0.0.0:9694</a> 0.0.0.0:* <wbr>11554/pgpool: heart </span><br>
</span><span style="font-family:monospace"><span style="color:rgb(0,0,0)">udp 0 0 <a href="http://0.0.0.0:54273" target="_blank">0.0.0.0:54273</a> 0.0.0.0:* <wbr>11555/pgpool: heart </span><br></span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:monospace">2-node</span></div><div><span style="font-family:monospace"><span style="color:rgb(0,0,0)">tcp 0 0 <a href="http://0.0.0.0:5432" target="_blank">0.0.0.0:5432</a> 0.0.0.0:* LISTEN 20190/pgpool </span><br>tcp 0 0 <a href="http://0.0.0.0:5433" target="_blank">0.0.0.0:5433</a> 0.0.0.0:* LISTEN 14123/postmaster <br>
</span><span style="font-family:monospace"><span style="color:rgb(0,0,0)">tcp 0 0 <a href="http://0.0.0.0:9000" target="_blank">0.0.0.0:9000</a> 0.0.0.0:* LISTEN 20191/pgpool: watch </span><br>
</span><span style="font-family:monospace"><span style="color:rgb(0,0,0)">udp 0 0 <a href="http://0.0.0.0:9694" target="_blank">0.0.0.0:9694</a> 0.0.0.0:* <wbr>20195/pgpool: heart </span><br>
</span><span style="font-family:monospace"><span style="color:rgb(0,0,0)">udp 0 0 <a href="http://0.0.0.0:54251" target="_blank">0.0.0.0:54251</a> 0.0.0.0:* <wbr>20196/pgpool: heart </span><br>
<br></span></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="m_5081091270969959442HOEnZb"><div class="m_5081091270969959442h5"><br></div></div></blockquote></div></div></div></div></div></div>