[pgpool-general: 8671] replication state not visible

[Todd Stein]

While I do have the application field populated, I am not seeing the replication state in the show pool_nodes table.

[postgres at catvmtspg02a DBToolkit]$ psql -x -h 10.78.121.1 -p 9999 -U pgpool postgres -c "show pool_nodes"
Password for user pgpool:
-[ RECORD 1 ]----------+-----------------------------
node_id                | 0
hostname               | catvmtspg02a.domain.net
port                   | 5432
status                 | up
pg_status              | up
lb_weight              | 0.333333
role                   | primary
pg_role                | primary
select_cnt             | 0
load_balance_node      | true
replication_delay      | 0
replication_state      |
replication_sync_state |
last_status_change     | 2023-03-24 10:52:59
-[ RECORD 2 ]----------+-----------------------------
node_id                | 1
hostname               | catvmtspg02b.domain.net
port                   | 5432
status                 | up
pg_status              | up
lb_weight              | 0.333333
role                   | standby
pg_role                | standby
select_cnt             | 0
load_balance_node      | false
replication_delay      | 0
replication_state      |
replication_sync_state |
last_status_change     | 2023-03-24 10:52:59
-[ RECORD 3 ]----------+-----------------------------
node_id                | 2
hostname               | catvmtspg02c.domain.net
port                   | 5432
status                 | up
pg_status              | up
lb_weight              | 0.333333
role                   | standby
pg_role                | standby
select_cnt             | 0
load_balance_node      | false
replication_delay      | 0
replication_state      |
replication_sync_state |
last_status_change     | 2023-03-24 10:52:59

[postgres at catvmtspg02a DBToolkit]$
[postgres at catvmtspg02a DBToolkit]$ psql -c "SELECT * FROM pg_replication_slots;" -x
-[ RECORD 1 ]-------+-----------------------------
slot_name           | catvmtspg02c_domain_net
plugin              |
slot_type           | physical
datoid              |
database            |
temporary           | f
active              | t
active_pid          | 1703
xmin                |
catalog_xmin        |
restart_lsn         | 2/2A001A88
confirmed_flush_lsn |
wal_status          | reserved
safe_wal_size       |
two_phase           | f
-[ RECORD 2 ]-------+-----------------------------
slot_name           | catvmtspg02b_domain_net
plugin              |
slot_type           | physical
datoid              |
database            |
temporary           | f
active              | t
active_pid          | 1822
xmin                |
catalog_xmin        |
restart_lsn         | 2/2A001A88
confirmed_flush_lsn |
wal_status          | reserved
safe_wal_size       |
two_phase           | f




Regards,

Todd Stein
OpsBridge Technical Success
OpenText
(Cell) +1 (941) 248-8752
tstein2 at opentext.com<mailto:tstein2 at opentext.com>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230324/5d40519f/attachment.htm>