[pgpool-general: 8672] Re: replication state not visible
Bo Peng
pengbo at sraoss.co.jp
Mon Mar 27 14:57:05 JST 2023
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/
More information about the pgpool-general
mailing list