Re: PGPool II does not recognize backend_server0

[Greg Sabino Mullane <htamfids@xxxxxxxxx>]

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