[pgpool-general: 8853] pgpool is not accepting connections

Zhaoxun Yan yan.zhaoxun at gmail.com
Wed Jun 28 17:47:03 JST 2023


Hi guys!

I have tested local postgresql, and it is ok for psql works:
psql -h 127.0.0.1  -U checker -c '\l' template1
But as I add in `-p 9999` the pgpool is down:
psql -h 127.0.0.1 -p 9999 -U checker -c '\l' template1
And I have found the latest log with these lines repeating:

2023-06-28 16:36:22.928: child pid 100980: FATAL:  pgpool is not accepting
any new connections
2023-06-28 16:36:22.928: child pid 100980: DETAIL:  all backend nodes are
down, pgpool requires at least one valid node
2023-06-28 16:36:22.928: child pid 100980: HINT:  repair the backend nodes
and restart pgpool
2023-06-28 16:36:22.928: main pid 100949: LOG:  reaper handler
2023-06-28 16:36:22.929: main pid 100949: LOG:  child process with pid:
100980 exited with success and will not be restarted
2023-06-28 16:36:22.929: main pid 100949: LOG:  reaper handler: exiting
normally
2023-06-28 16:36:28.899: child pid 100976: FATAL:  pgpool is not accepting
any new connections

Attached is the current pgpool configuration.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230628/0bad2f7f/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 52934 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230628/0bad2f7f/attachment.obj>


More information about the pgpool-general mailing list