<div dir="ltr"><div><div>I have also tested connecting postgres directly via ip address registered as first backend in pgpool.conf<br><span style="color:rgb(0,0,255)">backend_hostname0 = '172.17.0.2'</span><br><br></div>And it works:<br><span style="color:rgb(0,0,255)"># psql -h 172.17.0.2 -p 5432 -U checker -c '\l' template1<br>Password for user checker:<br> List of databases<br> Name | Owner | Encoding | Collate | Ctype | Access privileges<br>-----------+----------+----------+-------------+-------------+-----------------------<br> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |<br> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +<br> | | | | | postgres=CTc/postgres<br> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +<br> | | | | | postgres=CTc/postgres+<br> | | | | | checker=CTc/postgres<br>(3 rows)</span><br><br></div>while pgpool getsdozens of subprocess waiting for connection, it still believes that all nodes are down:<br><br><span style="color:rgb(0,0,255)"># ps aux|grep pgpool|grep -v grep<br>root 100949 0.0 17.5 149080 137180 ? Ss Jun28 0:00 pgpool<br>root 100950 0.0 0.3 15308 2932 ? S Jun28 0:00 pgpool: PgpoolLogger<br>root 100953 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100955 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100956 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100958 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100959 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100960 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100961 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100962 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100963 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100964 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100966 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100967 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100969 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100970 0.0 0.3 149080 2784 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100971 0.0 0.3 149080 2788 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100972 0.0 0.3 149080 2788 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100973 0.0 0.3 149080 2788 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100974 0.0 0.3 149080 2788 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100975 0.0 0.3 149080 2788 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100977 0.0 0.3 149080 2788 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100978 0.0 0.3 149080 2788 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100981 0.0 0.3 149080 2788 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100982 0.0 0.3 149080 2788 ? S Jun28 0:00 pgpool: wait for connection request<br>root 100983 0.0 0.3 149080 2788 ? S Jun28 0:00 pgpool: wait for connection request<br>root 101010 0.0 0.1 149084 1352 ? S Jun28 0:00 pgpool: PCP: wait for connection request<br>root 101011 0.0 0.1 149080 1352 ? S Jun28 0:00 pgpool: worker process</span><div><div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">---------- Forwarded message ---------<br>From: <b class="gmail_sendername" dir="auto">Zhaoxun Yan</b> <span dir="auto"><<a href="mailto:yan.zhaoxun@gmail.com">yan.zhaoxun@gmail.com</a>></span><br>Date: Wed, Jun 28, 2023 at 4:47 PM<br>Subject: pgpool is not accepting connections<br>To: <<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>><br></div><br><br><div dir="ltr"><div><div><div><div>Hi guys!<br><br></div>I have tested local postgresql, and it is ok for psql works:<br><span style="background-color:rgb(68,68,68)"><span style="color:rgb(238,238,238)">psql -h 127.0.0.1 -U checker -c '\l' template1</span></span></div>But as I add in `-p 9999` the pgpool is down:<br><span style="background-color:rgb(68,68,68)"><span style="color:rgb(238,238,238)">psql -h 127.0.0.1 -p 9999 -U checker -c '\l' template1</span></span></div>And I have found the latest log with these lines repeating:<br><br><span style="color:rgb(0,0,255)">2023-06-28 16:36:22.928: child pid 100980: FATAL: pgpool is not accepting any new connections<br>2023-06-28 16:36:22.928: child pid 100980: DETAIL: all backend nodes are down, pgpool requires at least one valid node<br>2023-06-28 16:36:22.928: child pid 100980: HINT: repair the backend nodes and restart pgpool<br>2023-06-28 16:36:22.928: main pid 100949: LOG: reaper handler<br>2023-06-28 16:36:22.929: main pid 100949: LOG: child process with pid: 100980 exited with success and will not be restarted<br>2023-06-28 16:36:22.929: main pid 100949: LOG: reaper handler: exiting normally<br>2023-06-28 16:36:28.899: child pid 100976: FATAL: pgpool is not accepting any new connections<br><br></span></div><span style="color:rgb(0,0,255)"><font color="#000000">Attached is the current pgpool configuration.</font><br></span></div>
</div></div></div></div></div>