On 9/17/18 8:39 AM, Nicola Contu wrote: Please reply to list also. Ccing list.
No wait, IP_ADDR has been modified by me, but there is the IP of the machine 10.151.x.
To be clear in your posts you are replacing the actual IP with IP_ADDR, correct?
Here is the psql command . [root@cmd-dev1 ~]# psql -U ncontu -p 6543 cmd3dev psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
So what does the pgbouncer log show when you do above?
Il giorno lun 17 set 2018 alle ore 17:35 Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> ha scritto:On 9/17/18 7:26 AM, Nicola Contu wrote: > [Mon Sep 17 10:24:59.041589 2018] [php7:notice] [pid 63893:tid > 140586929567488] [client 10.160.41.3:51764 <http://10.160.41.3:51764> <http://10.160.41.3:51764>] > PHP WARNING: pg_connect(): Unable to connect to PostgreSQL server: could > not connect to server: Connection refused\n\tIs the server running on > host "IP_ADDR" and accepting\n\tTCP/IP connections on port > 6543? in /home/cmd3/adodb5/drivers/adodb-postgres64.inc.php on line 727 To me it looks like IP_ADDR is not resolving to a host. In your pgbouncer.ini I see: DB_NAME = host=IP_ADDD port=5432 dbname=DB_NAME auth_user=pgbouncer pool_size=120 but the error is about connecting to port 6543 which is your pgbouncer 'server'. Are you sure your connection string is pointing at the correct thing? > > So basically the same I get when connecting via psql on port 6543 What is the full psql command? > > Il giorno lun 17 set 2018 alle ore 16:23 Adrian Klaver > <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx> <mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>>> ha scritto: > > On 9/17/18 7:19 AM, Nicola Contu wrote: > > I'm not aware of any update installed. There were like 600+ > updates in fact. > > > > These are the logs when connecting via telnet : > > How about those from when Apache tries to connect and pgbouncer crashes? > > > Connection closed by foreign host. > > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx> <mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> >-- Adrian Klaveradrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
