<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
<div>
<div>
<div dir="ltr">it is configured. I sent config files and logs on a different thread </div>
</div>
<div id="ms-outlook-mobile-signature">
<div></div>
</div>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Bo Peng <pengbo@sraoss.co.jp><br>
<b>Sent:</b> Monday, March 27, 2023 1:57:05 AM<br>
<b>To:</b> Todd Stein <todd.stein@microfocus.com><br>
<b>Cc:</b> pgpool-general@pgpool.net <pgpool-general@pgpool.net><br>
<b>Subject:</b> Re: [pgpool-general: 8671] replication state not visible</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Hello,<br>
<br>
On Fri, 24 Mar 2023 15:38:03 +0000<br>
Todd Stein <todd.stein@microfocus.com> wrote:<br>
<br>
> While I do have the application field populated, I am not seeing the replication state in the show pool_nodes table.<br>
<br>
You need to configure "backend_application_name" parameter.<br>
<br>
Please see the following doc:<br>
<a href="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">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</a><br>
<br>
> [postgres@catvmtspg02a DBToolkit]$ psql -x -h 10.78.121.1 -p 9999 -U pgpool postgres -c "show pool_nodes"<br>
> Password for user pgpool:<br>
> -[ RECORD 1 ]----------+-----------------------------<br>
> node_id | 0<br>
> hostname | catvmtspg02a.domain.net<br>
> port | 5432<br>
> status | up<br>
> pg_status | up<br>
> lb_weight | 0.333333<br>
> role | primary<br>
> pg_role | primary<br>
> select_cnt | 0<br>
> load_balance_node | true<br>
> replication_delay | 0<br>
> replication_state |<br>
> replication_sync_state |<br>
> last_status_change | 2023-03-24 10:52:59<br>
> -[ RECORD 2 ]----------+-----------------------------<br>
> node_id | 1<br>
> hostname | catvmtspg02b.domain.net<br>
> port | 5432<br>
> status | up<br>
> pg_status | up<br>
> lb_weight | 0.333333<br>
> role | standby<br>
> pg_role | standby<br>
> select_cnt | 0<br>
> load_balance_node | false<br>
> replication_delay | 0<br>
> replication_state |<br>
> replication_sync_state |<br>
> last_status_change | 2023-03-24 10:52:59<br>
> -[ RECORD 3 ]----------+-----------------------------<br>
> node_id | 2<br>
> hostname | catvmtspg02c.domain.net<br>
> port | 5432<br>
> status | up<br>
> pg_status | up<br>
> lb_weight | 0.333333<br>
> role | standby<br>
> pg_role | standby<br>
> select_cnt | 0<br>
> load_balance_node | false<br>
> replication_delay | 0<br>
> replication_state |<br>
> replication_sync_state |<br>
> last_status_change | 2023-03-24 10:52:59<br>
> <br>
> [postgres@catvmtspg02a DBToolkit]$<br>
> [postgres@catvmtspg02a DBToolkit]$ psql -c "SELECT * FROM pg_replication_slots;" -x<br>
> -[ RECORD 1 ]-------+-----------------------------<br>
> slot_name | catvmtspg02c_domain_net<br>
> plugin |<br>
> slot_type | physical<br>
> datoid |<br>
> database |<br>
> temporary | f<br>
> active | t<br>
> active_pid | 1703<br>
> xmin |<br>
> catalog_xmin |<br>
> restart_lsn | 2/2A001A88<br>
> confirmed_flush_lsn |<br>
> wal_status | reserved<br>
> safe_wal_size |<br>
> two_phase | f<br>
> -[ RECORD 2 ]-------+-----------------------------<br>
> slot_name | catvmtspg02b_domain_net<br>
> plugin |<br>
> slot_type | physical<br>
> datoid |<br>
> database |<br>
> temporary | f<br>
> active | t<br>
> active_pid | 1822<br>
> xmin |<br>
> catalog_xmin |<br>
> restart_lsn | 2/2A001A88<br>
> confirmed_flush_lsn |<br>
> wal_status | reserved<br>
> safe_wal_size |<br>
> two_phase | f<br>
> <br>
> <br>
> <br>
> <br>
> Regards,<br>
> <br>
> Todd Stein<br>
> OpsBridge Technical Success<br>
> OpenText<br>
> (Cell) +1 (941) 248-8752<br>
> tstein2@opentext.com<mailto:tstein2@opentext.com><br>
> <br>
<br>
<br>
-- <br>
Bo Peng <pengbo@sraoss.co.jp><br>
SRA OSS LLC<br>
<a href="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">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</a><br>
</div>
</span></font></div>
</body>
</html>