Search Postgresql Archives

Re: Pgbouncer and postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.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>



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux