[pgpool-general: 9339] pgpool connection

[陳奕翔]

environment->
linux os:rel8
postgresql : postgresql 15.9
pgpool : pgpool-II-4.5.0

  After installing pgpool, I encountered a problem when trying to start
pgpool. When I use the command #pgpool, there is no error. However, when I
check with # ps aux | grep pgpool, the following information appears.

  root      219469 51.0  1.7 209876 137340 ?       Ss   16:02   0:01 pgpool
root      219470  0.0  0.0  76104  1348 ?        S    16:02   0:00 pgpool:
PgpoolLogger
root      219472  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219473  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219474  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219475  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219476  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219477  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219478  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219479  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219480  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219481  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219482  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219483  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219484  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219485  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219486  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219487  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219488  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219489  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219490  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219491  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219492  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219493  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219494  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219495  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219496  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219497  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219498  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219499  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219500  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219501  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219502  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219503  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
wait for connection request
root      219504  0.0  0.0 209880  1356 ?        S    16:02   0:00 pgpool:
PCP: wait for connection request
root      219505  0.0  0.0 209876  1356 ?        S    16:02   0:00 pgpool:
worker process
root      219507  0.0  0.0 221948  1144 pts/0    S+   16:02   0:00 grep
--color=auto pgpool

When I use the following command,
# psql -p 9999 -Upostgres -h <local_ip> test

the following result appears.
psql: error: connection to server at "<local_ip>", port 9999 failed: 連線被拒絕
        Is the server running on that host and accepting TCP/IP connections?

I added the following to my pool_hba.conf.
host    all         all             0/0               md5

and I pgpool.conf connections
listen_addresses = '*'
port = 9999
unix_socket_directories = '/tmp'

  I have also set up the connection parameters for my psql, but I still
can't connect. What areas should I check?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20250208/7640310d/attachment.htm>