| From: | Greg Sabino Mullane <htamfids(at)gmail(dot)com> |
|---|---|
| To: | Pablo Calientos <mputzu(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PGPool II does not recognize backend_server0 |
| Date: | 2025-06-25 14:54:14 |
| Message-ID: | CAKAnmmKnQiWk6FciCJzhKtquHwFYt4bvTeZeLQEUwHTD2L5BXQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter J. Holzer | 2025-06-25 15:33:05 | Re: password rules |
| Previous Message | raphi | 2025-06-25 12:42:26 | Re: password rules |