[pgpool-general: 8363] pgpoolAdmin 4.2 doesnt see state of postgres, but pcp_status and "show pool_nodes" works

[Michal Jerabek]

Hello,




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




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.




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?





pcp_status
Node 0:
Hostname               : 172.27.8.249
Port                   : 5432
Status                 : 2
Weight                 : 0.500000
Status Name            : up
Backend Status Name    : up
Role                   : primary
Backend Role           : primary
Replication Delay      : 0
Replication State      : none
Replication Sync State : none
Last Status Change     : 2022-08-31 15:07:04


Node 1:
Hostname               : 172.27.8.250
Port                   : 5432
Status                 : 2
Weight                 : 0.500000
Status Name            : up
Backend Status Name    : up
Role                   : standby
Backend Role           : primary
Replication Delay      : 402654288
Replication State      : none
Replication Sync State : none
Last Status Change     : 2022-08-31 15:07:04





(of course there is no correct active/standby state, both backend are 
primary, prepared for recovery/sync)





$ psql -h VIPADDRESS -p 5433 -U pgpool postgres -c "show pool_nodes"
 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
tus_change
---------+--------------+------+--------+-----------+-----------+---------+-
--------+------------+-------------------+-------------------+--------------
-----+------------------------+---------
------------
 0       | 172.27.8.249 | 5432 | up     | up        | 0.500000  | primary | 
primary | 72         | false             | 0                 |              
     |                        | 2022-08-
31 15:07:04
 1       | 172.27.8.250 | 5432 | up     | up        | 0.500000  | standby | 
primary | 83         | true              | 402654288         |              
     |                        | 2022-08-
31 15:07:04
(2 rows)






Thank you for help




Michal











I have similiar expierence wiht installing same versions of psql, pgpool-II 
and pgpoolAdmin on Centos8 stream, where there is no problem there.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220831/60d54302/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.png
Type: image/png
Size: 39106 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220831/60d54302/attachment-0001.png>