<html><body><div>Hello,</div><div><br></div><div>i made install of 2 nodes with postgresql-14 (4.6), pgpool-II (4.3.2.) and pgpoolAdmin on RHEL 8.6 (selinux permissive), all postgres related components from repos (https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-8-x86_64/ and https://apt.postgresql.org/pub/repos/yum/common/redhat/rhel-8-x86_64/).</div><div><br></div><div>And I have problem that pgpoolAdmin component show state of postgres always "down" either in pgpool status and Node status , but postgres is running, standard database connection to db backend throught pgpool works and I am able to attach and dettach nodes from command line.</div><div><br></div><div>PCP status command shows right state of components, and also query to "show pool_nodes" works, where should be a problem? where pgpoolAdmin get states from?<br></div><div><br></div><div>pcp_status<br>Node 0:<br>Hostname : 172.27.8.249<br>Port : 5432<br>Status : 2<br>Weight : 0.500000<br>Status Name : up<br>Backend Status Name : up<br>Role : primary<br>Backend Role : primary<br>Replication Delay : 0<br>Replication State : none<br>Replication Sync State : none<br>Last Status Change : 2022-08-31 15:07:04<br><br><br>Node 1:<br>Hostname : 172.27.8.250<br>Port : 5432<br>Status : 2<br>Weight : 0.500000<br>Status Name : up<br>Backend Status Name : up<br>Role : standby<br>Backend Role : primary<br>Replication Delay : 402654288<br>Replication State : none<br>Replication Sync State : none<br>Last Status Change : 2022-08-31 15:07:04<br></div><div><br></div><div>(of course there is no correct active/standby state, both backend are primary, prepared for recovery/sync)<br></div><div><br></div><div>$ psql -h VIPADDRESS -p 5433 -U pgpool postgres -c "show pool_nodes"<br> node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_sta<br>tus_change<br>---------+--------------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------<br>------------<br> 0 | 172.27.8.249 | 5432 | up | up | 0.500000 | primary | primary | 72 | false | 0 | | | 2022-08-<br>31 15:07:04<br> 1 | 172.27.8.250 | 5432 | up | up | 0.500000 | standby | primary | 83 | true | 402654288 | | | 2022-08-<br>31 15:07:04<br>(2 rows)<br><br></div><div><br></div><div>Thank you for help</div><div><br></div><div>Michal<br></div><div><br></div><div><br></div><div><br></div><div>I have similiar expierence wiht installing same versions of psql, pgpool-II and pgpoolAdmin on Centos8 stream, where there is no problem there.<br></div><img src="cid:i0014123422653055662"></body></html>