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

[Todd Stein]

it is configured.  I sent config files and logs on a different thread
________________________________
From: Bo Peng <pengbo at sraoss.co.jp>
Sent: Monday, March 27, 2023 1:57:05 AM
To: Todd Stein <todd.stein at microfocus.com>
Cc: pgpool-general at pgpool.net <pgpool-general at pgpool.net>
Subject: Re: [pgpool-general: 8671] replication state not visible

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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.pgpool.net%2Fdocs%2Flatest%2Fen%2Fhtml%2Fruntime-config-backend-settings.html%23GUC-BACKEND-APPLICATION-NAME&data=05%7C01%7Ctodd.stein%40microfocus.com%7C39f701c95c4346f1415208db2e881c1c%7C856b813c16e549a585ec6f081e13b527%7C0%7C0%7C638154934339785877%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=gKHU3nQf%2Ft%2FNK9rk7373gpwntIkORBwASA%2FaTlglZhc%3D&reserved=0

> [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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sraoss.co.jp%2F&data=05%7C01%7Ctodd.stein%40microfocus.com%7C39f701c95c4346f1415208db2e881c1c%7C856b813c16e549a585ec6f081e13b527%7C0%7C0%7C638154934339785877%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=h79Vn717xGjLx4H%2FZP%2F3Ry%2FeMoCjszJmG%2Bsqo8c%2F8zI%3D&reserved=0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230327/daa5d78f/attachment-0001.htm>