From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Nicola Contu <nicola(dot)contu(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Pgbouncer and postgres |
Date: | 2018-09-17 15:46:03 |
Message-ID: | 76637bc1-65c0-8a73-743e-e5a2d40265f1@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> 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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>> 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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Litt | 2018-09-17 15:57:10 | Re: Code of Conduct plan |
Previous Message | Chris Travers | 2018-09-17 15:39:20 | Re: Code of Conduct plan |