<div dir="ltr"><div>PgPool 4.5.4</div><div><br></div><div>Three node pgpool cluster:</div><div>Node0 = Postgresql primary</div><div>Node1 = Postgresql streaming replica</div><div>Node2 = PgPool leader, where the VIP sits.</div><div><br></div><div><a href="https://www.pgpool.net/docs/45/en/html/runtime-config-backend-settings.html">https://www.pgpool.net/docs/45/en/html/runtime-config-backend-settings.html</a></div><div><br></div><div>The docs consistently refer to setting backend_application_nameX to "serverX", so that's what I did:</div><div><br></div><div>But should it really be set to "walreceiver"?  Should both backend_application_name0 and backend_application_name1 be set to "walreceiver" even though it's only running on Node1?</div><div><br></div><div><font face="monospace">Node 0:<br>postgres=# select pid, application_name, client_hostname<br>from pg_stat_activity<br>where application_name != '';<br>  Â pid Â  | Â  Â application_name Â  Â | client_hostname <br>---------+------------------------+-----------------<br> 3112451 | walreceiver Â  Â  Â  Â  Â  Â | FISPCDSPGS302b<br> 1177629 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br> 1221366 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br> 1325036 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br> 1171884 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br> 3865948 | PostgreSQL JDBC Driver | FISPCDSPGS302c<br> 1334650 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | <br> 1261549 | PostgreSQL JDBC Driver | FISPCDSPGS302c<br> 1261614 | PostgreSQL JDBC Driver | FISPCDSPGS302c<br> 1261622 | PostgreSQL JDBC Driver | FISPCDSPGS302c<br> 1261624 | PostgreSQL JDBC Driver | FISPCDSPGS302c<br> 1139422 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br> 1267007 | PostgreSQL JDBC Driver | FISPCDSPGS302c<br> 1177681 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br> 1208143 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br> 1208198 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br> 1273655 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br> 1296530 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br> 1300468 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br> 1300643 | psql Â  Â  Â  Â  Â  Â  Â  Â  Â  | FISPCDSPGS302c<br>(20 rows)<br><br>Node 1:<br><br>postgres=# select pid, application_name, backend_type<br>from pg_stat_activity<br>where client_hostname is null;<br>  Â pid Â  | application_name | Â  backend_type Â  Â <br>---------+------------------+-------------------<br> 2694716 | psql Â  Â  Â  Â  Â  Â  | client backend<br> 1437627 | Â  Â  Â  Â  Â  Â  Â  Â  Â | startup<br> 1437626 | Â  Â  Â  Â  Â  Â  Â  Â  Â | background writer<br> 1437625 | Â  Â  Â  Â  Â  Â  Â  Â  Â | checkpointer<br> 1437628 | Â  Â  Â  Â  Â  Â  Â  Â  Â | walreceiver<br>(5 rows)<br></font></div><div><br></div><div><span style="font-family:monospace">$ psql -h FISPCDSPGS302 -p9999 cdsmultip</span></div><div><font face="monospace">psql (16.8)<br>Type "help" for help.<br><br>cdsmultip=# <br>cdsmultip=# pgpool show backend_application_name0;<br> backend_application_name0 <br>---------------------------<br> server0<br>(1 row)<br><br>cdsmultip=# pgpool show backend_application_name1;<br> backend_application_name1 <br>---------------------------<br> server1<br>(1 row)<br><br>cdsmultip=# pgpool show backend_application_name2;<br> backend_application_name2 <br>---------------------------<br> <br>(1 row)<br></font></div><div><br></div><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Death to <Redacted>, and butter sauce.<div>Don't boil me, I'm still alive.<br><div><div><Redacted> lobster!</div></div></div></div></div></div>