<div dir="ltr">Empty values for replication_state and replication_sync_state columns with pcp_node_info<br><br>Hello.<br><br>I have testing pgpool 4.1.1 with Postgresql 12.2 on Linux Centos 7.<br><br>I get empty values for replication_state and replication_sync_state columns with pcp_node_info or show pool_nodes.<br><br>I have two servers. I have configured Postgresql streaming replication and it&#39;s running with success. I get info for replication using sql sentence pg_stat_replication.<br>For pgpool, I have configure backend_application_name0, backend_application_name1, sr_check_period (10) and sr_check_user (nobody).<br>Using sr_check_user = postgres I get same results (empty values for replication_state and replication_sync_state columns).<br><br>What am I doing wrong?<div><br></div><div>Then I show some information:<br><br><br>[root@server1 pgpool-II]# pcp_node_info --host 172.16.0.1 --port 9898 --username admin -w --node-id 0<br>172.16.0.1 5432 2 0.500000 up primary 0   2020-04-20 09:38:04<br><br>[root@server1 pgpool-II]# pcp_node_info --host 172.16.0.1 --port 9898 --username admin -w --node-id 1<br>172.16.0.2 5432 2 0.500000 up standby 0   2020-04-20 09:38:04<br><br>[root@server1 pgpool-II]# pcp_node_info --host 172.16.0.1 --port 9898 --username admin -w --node-id 0 --verbose<br>Hostname               : 172.16.0.1<br>Port                   : 5432<br>Status                 : 2<br>Weight                 : 0.500000<br>Status Name            : up<br>Role                   : primary<br>Replication Delay      : 0<br>Replication State      :<br>Replication Sync State :<br>Last Status Change     : 2020-04-20 09:38:04<br>[root@server1 pgpool-II]# pcp_node_info --host 172.16.0.1 --port 9898 --username admin -w --node-id 1 --verbose<br>Hostname               : 172.16.0.2<br>Port                   : 5432<br>Status                 : 2<br>Weight                 : 0.500000<br>Status Name            : up<br>Role                   : standby<br>Replication Delay      : 0<br>Replication State      :<br>Replication Sync State :<br>Last Status Change     : 2020-04-20 09:38:04<br>[root@server1 pgpool-II]#<br><br><br><br>[root@server1 ~]# psql -h 172.16.0.1 -p 9999 -U nobody -c &quot;select * from pg_stat_replication&quot; postgres<br> pid  | usesysid |  usename  | application_name | client_addr | client_hostname | client_port |         backend_start         | backen<br>d_xmin |   state   |  sent_lsn  | write_lsn  | flush_lsn  | replay_lsn | write_lag | flush_lag | replay_lag | sync_priority | sync_sta<br>te |          reply_time<br>------+----------+-----------+------------------+-------------+-----------------+-------------+-------------------------------+-------<br>-------+-----------+------------+------------+------------+------------+-----------+-----------+------------+---------------+---------<br>---+-------------------------------<br> 3664 |    16384 | userrepli | walreceiver      | 172.16.0.2  |                 |       47482 | 2020-04-20 09:10:20.191692+02 |<br>   522 | streaming | 0/19001298 | 0/19001298 | 0/19001298 | 0/19001298 |           |           |            |             0 | async<br>   | 2020-04-20 09:33:32.341974+02<br>(1 row)<br><br>[root@server1 ~]#<br><br><br>[root@server1 ~]# pgpool -v<br>pgpool-II version 4.1.1 (karasukiboshi)<br>[root@server1 ~]#<br><br>[root@server1 ~]# psql -V<br>psql (PostgreSQL) 12.2<br>[root@server1 ~]#<br><br><br>[root@server1 ~]# psql -h 172.16.0.1 -p 9999 -U nobody -c &quot;pgpool show sr_check_period&quot; postgres<br> sr_check_period<br>-----------------<br> 10<br>(1 row)<br><br>[root@server1 ~]# psql -h 172.16.0.1 -p 9999 -U nobody -c &quot;pgpool show sr_check_user&quot; postgres<br> sr_check_user<br>---------------<br> nobody<br>(1 row)<br><br>[root@server1 ~]#<br><br>[root@server1 ~]# psql -h 172.16.0.1 -p 9999 -U nobody -c &quot;pgpool show backend_application_name0&quot; postgres<br> backend_application_name0<br>---------------------------<br> server1<br>(1 row)<br><br>[root@server1 ~]# psql -h 172.16.0.1 -p 9999 -U nobody -c &quot;pgpool show backend_application_name1&quot; postgres<br> backend_application_name1<br>---------------------------<br> server2<br>(1 row)<br><br>[root@server1 ~]#<br><br><br>[root@server1 ~]# psql -h 172.16.0.1 -p 9999 -U nobody -c &quot;show pool_nodes&quot; postgres<br> node_id |  hostname  | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay | replication_state |<br> replication_sync_state | last_status_change<br>---------+------------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+<br>------------------------+---------------------<br> 0       | 172.16.0.1 | 5432 | up     | 0.500000  | primary | 0          | true              | 0                 |                   |<br>                        | 2020-04-20 09:23:40<br> 1       | 172.16.0.2 | 5432 | up     | 0.500000  | standby | 0          | false             | 0                 |                   |<br>                        | 2020-04-20 09:23:40<br>(2 rows)<br><br>[root@server1 ~]#<br></div><div><br></div><div>Thanks in advance. Regards <br></div><div><br></div><div> <br></div></div>