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

[Bo Peng]

Hello,

You also need to make sure the user specified in sr_check_user is 
PostgreSQL super user or or in pg_monitor group.

Grant pg_monitor to user:

  GRANT pg_monitor TO <username>;
    

On Mon, 27 Mar 2023 11:29:50 +0000
Todd Stein <todd.stein at microfocus.com> wrote:

> 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


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