[pgpool-general: 8676] Re: replication state not visible
Todd Stein
todd.stein at microfocus.com
Mon Mar 27 21:37:06 JST 2023
Thank you.
Attached is a zip file labeled as a txt file containing config files and logs.
sr_check_user is specified as pgpool. The pgpool user is in pg_monitor group.
Regards,
Todd Stein
-----Original Message-----
From: Bo Peng <pengbo at sraoss.co.jp>
Sent: Monday, March 27, 2023 8:28 AM
To: Todd Stein <todd.stein at microfocus.com>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 8671] replication state not visible
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-settin
> gs.html%23GUC-BACKEND-APPLICATION-NAME&data=05%7C01%7Ctodd.stein%40mic
> rofocus.com%7C9276e0e0ddb64c804e0108db2ebeb357%7C856b813c16e549a585ec6
> f081e13b527%7C0%7C0%7C638155168831102214%7CUnknown%7CTWFpbGZsb3d8eyJWI
> joiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7
> C%7C%7C&sdata=DrL8VzVxtQi%2FnGr5m1oK526MYhUq5wYLL2xhbhj6hAE%3D&reserve
> d=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%7C9276e0e0d
> db64c804e0108db2ebeb357%7C856b813c16e549a585ec6f081e13b527%7C0%7C0%7C6
> 38155168831102214%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoi
> V2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=xp5mkf%2F
> VHbxnYwg8ZWX9kf%2BZfwQDgHXdwYrXeOWbDoc%3D&reserved=0
--
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%7C9276e0e0ddb64c804e0108db2ebeb357%7C856b813c16e549a585ec6f081e13b527%7C0%7C0%7C638155168831102214%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=xp5mkf%2FVHbxnYwg8ZWX9kf%2BZfwQDgHXdwYrXeOWbDoc%3D&reserved=0
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pgpool_files.txt
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230327/3398d811/attachment.txt>
More information about the pgpool-general
mailing list