<div dir="ltr">environment-><div>linux os:rel8<br>postgresql : postgresql 15.9<br>pgpool : pgpool-II-4.5.0<br><br> 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.<br><br> <font size="1"> root 219469 51.0 1.7 209876 137340 ? Ss 16:02 0:01 pgpool<br>root 219470 0.0 0.0 76104 1348 ? S 16:02 0:00 pgpool: PgpoolLogger<br>root 219472 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219473 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219474 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219475 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219476 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219477 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219478 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219479 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219480 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219481 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219482 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219483 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219484 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219485 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219486 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219487 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219488 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219489 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219490 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219491 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219492 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219493 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219494 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219495 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219496 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219497 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219498 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219499 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219500 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219501 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219502 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219503 0.0 0.0 209876 2860 ? S 16:02 0:00 pgpool: wait for connection request<br>root 219504 0.0 0.0 209880 1356 ? S 16:02 0:00 pgpool: PCP: wait for connection request<br>root 219505 0.0 0.0 209876 1356 ? S 16:02 0:00 pgpool: worker process<br>root 219507 0.0 0.0 221948 1144 pts/0 S+ 16:02 0:00 grep --color=auto pgpool</font><div><font size="1"><br></font></div><div>
When I use the following command, </div><div># psql -p 9999 -Upostgres -h <local_ip> test<font size="1"></font></div><div><br></div><div>the following result appears. </div><div>psql: error: connection to server at "<local_ip>", port 9999 failed: 連線被拒絕<br> Is the server running on that host and accepting TCP/IP connections?<br></div><div><br></div><div>
I added the following to my pool_hba.conf.
</div><div>host all all 0/0 md5<br></div><div><br></div><div>and I pgpool.conf connections</div><div>listen_addresses = '*'<br></div><div>port = 9999<br></div><div>unix_socket_directories = '/tmp'</div></div><div><br></div><div> I have also set up the connection parameters for my psql, but I still can't connect. What areas should I check? </div></div>