[pgpool-general: 8671] replication state not visible
Todd Stein
todd.stein at microfocus.com
Sat Mar 25 00:38:03 JST 2023
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>
More information about the pgpool-general
mailing list