[pgpool-general: 8672] Re: replication state not visible

[Bo Peng]

Hello,

On Fri, 24 Mar 2023 15:38:03 +0000
Todd Stein <todd.stein at microfocus.com> wrote:

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

You need to configure "backend_application_name" parameter.

Please see the following doc:
https://www.pgpool.net/docs/latest/en/html/runtime-config-backend-settings.html#GUC-BACKEND-APPLICATION-NAME

> [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>
> 


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/