<html><head></head><body><div class="ydpf6e2a5deyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div>You have to look in the pgpool log file why pgpool decided to detach the node, it typically happens when the healtch check fails (db was stopped, no network connectivity, etc.)<br></div><div><br></div><div>To put it back up you must use the pcp_attach_node command, it will be something like</div><div><br></div><div>pcp_attach_node -h localhost -p 9898 -w 1<br></div><div><br></div><div>note: -w is to disable password prompting, it requires to have a .pcppass file in your home directory with the right permissions.<br></div><div><br></div><div class="ydpf6e2a5designature">Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="ydp78145bd5yahoo_quoted_3751811828" class="ydp78145bd5yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Friday, November 23, 2018, 11:14:03 AM GMT+1, Mike Yeap <wkk1020@gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp78145bd5yiv4800783543"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hi, I'm new to Pgpool-II and trying a setup based on a two nodes streaming replication configuration. But the "show pool_nodes" command shows a "down" status for the standby node:</div><div dir="ltr"><br></div><div dir="ltr"><div dir="ltr"><font face="monospace, monospace">[postgres@hoopa-uat-1 log]$ psql -h hoopa-uat-pgpool-1 -p 9999 -U postgres -c "show pool_nodes" postgres</font></div><div dir="ltr"><br></div><div dir="ltr"><font face="monospace, monospace"> node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | last_status_change</font></div><div dir="ltr"><font face="monospace, monospace">---------+-------------+------+--------+-----------+---------+------------+-------------------+-------------------+--------------------</font></div><div dir="ltr"><font face="monospace, monospace"> 0 | hoopa-uat-1 | 5432 | up | 0.500000 | primary | 0 | true | 0 | 2018-11-23 17:57:16</font></div><div dir="ltr"><font face="monospace, monospace"> 1 | hoopa-uat-2 | 5432 | down | 0.500000 | standby | 0 | false | 0 | 2018-11-23 17:57:16</font></div><div><br></div><div>Actually the standby node is up, and I can run queries on it.</div><div><br></div><div>Can someone please enlighten me?</div><div><br></div><div>pgpool-II version 4.0.1<br></div><div>PostgreSQL version 11.1</div><div><br></div><div>Thank you.</div><div>Regards,</div><div>Mike Yeap</div></div></div></div></div>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="nofollow" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div>
</div>
</div></body></html>