[pgpool-general: 6310] Re: Standby node's status is "down" when running "show pool_nodes" command

[Pierre Timmermans]

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.)

To put it back up you must use the pcp_attach_node command, it will be something like
pcp_attach_node -h localhost -p 9898 -w 1

note: -w is to disable password prompting, it requires to have a .pcppass file in your home directory with the right permissions.

Pierre 

    On Friday, November 23, 2018, 11:14:03 AM GMT+1, Mike Yeap <wkk1020 at gmail.com> wrote:  
 
 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:
[postgres at hoopa-uat-1 log]$ psql -h hoopa-uat-pgpool-1 -p 9999 -U postgres -c "show pool_nodes" postgres
 node_id | hostname    | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay | last_status_change---------+-------------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------- 0       | hoopa-uat-1 | 5432 | up     | 0.500000  | primary | 0          | true              | 0                 | 2018-11-23 17:57:16 1       | hoopa-uat-2 | 5432 | down   | 0.500000  | standby | 0          | false             | 0                 | 2018-11-23 17:57:16
Actually the standby node is up, and I can run queries on it.
Can someone please enlighten me?
pgpool-II version 4.0.1
PostgreSQL version 11.1
Thank you.Regards,Mike Yeap_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181123/3bdcffa2/attachment.html>