Im trying to add a node in my pgpool cluster. I have installed pgpool on two nodes, but when i run show pool_nodes it shows node 1 is down. I added second node with command pcp_attach_node and command says what is below. What could be the problem?

pcp_attach_node -- Command Successful

postgres=# show pool_nodes;
 node_id |       hostname        | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay | replication_state | replication
--------- ----------------------- ------ -------- ----------- --------- ------------ ------------------- ------------------- ------------------- ------------
 0       | localhost             | 3721 | up     | 0.500000  | primary | 3          | true              | 0                 |                   |
 1       | host2 | 3721 | down   | 0.500000  | standby | 0          | false             | 0                 |                   |
(2 rows)

CodePudding user response：

I found this page http://lists.pgfoundry.org/pipermail/pgpool-general/2010-May/002711.html

They say that I need to remove file pgpool_status. I did it and pgpool works now with two nodes! Seems the file was created when I had not the second node and after pgpool just trusted this file all time. So removing this file solved the problem.

Just fire pgpool -m fast stop and then rm -rf pgpool_status then start pgpool

CodePudding user response：

You need to remove file pgpool_status. I did it and pgpool works now with two nodes! Seems the file was created when I had not the second node and after pgpool just trusted this file all time. So removing this file solved the problem.

Just fire pgpool -m fast stop and then rm -rf pgpool_status then start pgpool