MIME-Version: 1.0
References: <CA+BBeFCAHRj3PTTi3shWdpLyMK7KPP+eAs63TYgmfLK_6Backg@mail.gmail.com>
In-Reply-To: <CA+BBeFCAHRj3PTTi3shWdpLyMK7KPP+eAs63TYgmfLK_6Backg@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 25 Jun 2025 10:54:14 -0400
Message-ID: <CAKAnmmKnQiWk6FciCJzhKtquHwFYt4bvTeZeLQEUwHTD2L5BXQ@mail.gmail.com>
Subject: Re: PGPool II does not recognize backend_server0
To: Pablo Calientos <mputzu@gmail.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000091fda6063866a041"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmKnQiWk6FciCJzhKtquHwFYt4bvTeZeLQEUwHTD2L5BXQ%40mail.gmail.com>
Precedence: bulk

--00000000000091fda6063866a041
Content-Type: text/plain; charset="UTF-8"

Basic debugging:

Try looking at each node more closely with pcp_node_info

https://www.pgpool.net/docs/latest/en/html/pcp-node-info.html

Also make sure you are always using health_check

https://www.pgpool.net/docs/latest/en/html/runtime-config-health-check.html

Specific debugging:

2025-06-19 16:44:31.934: main pid 6248: LOG: reading status file: 1 th
> backend is set to up status


This would seem to indicate it's reading cached info about the state of the
node, so you may need to remove the pgpool_status file. You can also tell
pgpool to ignore it on startup via the  -D or --discard-status flag.

Hope that helps,
Greg


--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--00000000000091fda6063866a041
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>Basic debugging:</div><div><br></div=
>Try looking at each node more closely with pcp_node_info<div><br></div><di=
v><a href=3D"https://www.pgpool.net/docs/latest/en/html/pcp-node-info.html"=
>https://www.pgpool.net/docs/latest/en/html/pcp-node-info.html</a></div><di=
v><br></div><div>Also make sure you are always using health_check</div><div=
><br></div><div><a href=3D"https://www.pgpool.net/docs/latest/en/html/runti=
me-config-health-check.html">https://www.pgpool.net/docs/latest/en/html/run=
time-config-health-check.html</a></div><div><br></div><div>Specific debuggi=
ng:</div><div><br></div><div><blockquote style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex" class=3D"gmail_quo=
te">2025-06-19 16:44:31.934: main pid 6248: LOG:  reading status file: 1 th=
 backend is set to up status</blockquote></div><div><br></div><div>This wou=
ld seem to indicate it&#39;s reading cached info about the state of the nod=
e, so you may need to remove the pgpool_status file. You=C2=A0can also tell=
 pgpool to ignore it on startup via the=C2=A0 -D or --discard-status flag.<=
/div><div><br></div><div>Hope that helps,</div><div>Greg</div><div><br></di=
v><div><br></div></div><div dir=3D"ltr" class=3D"gmail_signature"><div dir=
=3D"ltr"><div>--</div><div>Crunchy Data - <a href=3D"https://www.crunchydat=
a.com" target=3D"_blank">https://www.crunchydata.com</a></div><div>Enterpri=
se Postgres Software Products &amp; Tech Support</div><div><br></div></div>=
</div></div>

--00000000000091fda6063866a041--