Re: Pgbouncer and postgres

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>]
> PHP WARNING: pg_connect(): Unable to connect to PostgreSQL server: could
> not connect to server: Connection refused\n\tIs the server running on
> host &quot;IP_ADDR&quot; 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>> 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>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com