Re: Pgbouncer and postgres - Mailing list pgsql-general

From Nicola Contu
Subject Re: Pgbouncer and postgres
Date
Msg-id CAMTZZh2z1AnAdEdJ74jntOi1T4twXRzjgb580mcC+-YnF97apQ@mail.gmail.com
Whole thread Raw
In response to Re: Pgbouncer and postgres  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Pgbouncer and postgres  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Yes I can connect to port 5432 without any problem.

The thing is that I am not seeing anything on the postgres log when connecting to 6543.

Sure, thanks for your help.
I will create an issue there.


Il giorno lun 17 set 2018 alle ore 18:07 Adrian Klaver <adrian.klaver@aklaver.com> ha scritto:
On 9/17/18 8:59 AM, Nicola Contu wrote:
> Yeah, I replaced the IP of the machine with the word IP_ADDR.
>
> On the pgbouncer log I get this while trying to connect via psql:
>
> 2018-09-17 15:56:49.452 67611 WARNING tune_socket(16) failed: Operation
> not supported
> 2018-09-17 15:56:49.452 67611 NOISE safe_close(16) = 0
> 2018-09-17 15:56:49.452 67611 NOISE safe_accept(13) = Resource
> temporarily unavailable
> 2018-09-17 15:56:50.728 67611 NOISE safe_accept(13) = 16 (unix:)
> 2018-09-17 15:56:50.729 67611 NOISE new fd from accept=16
> 2018-09-17 15:56:50.729 67611 WARNING tune_socket(16) failed: Operation
> not supported
> 2018-09-17 15:56:50.729 67611 NOISE safe_close(16) = 0
> 2018-09-17 15:56:50.729 67611 NOISE safe_accept(13) = Resource
> temporarily unavailable
> 2018-09-17 15:56:56.418 67611 NOISE safe_accept(11) = 16
> (10.151.2.145:58696 <http://10.151.2.145:58696>)
> 2018-09-17 15:56:56.418 67611 NOISE new fd from accept=16
> 2018-09-17 15:56:56.418 67611 NOISE safe_accept(11) = Resource
> temporarily unavailable

Can you connect to the actual database running on port 5432?

Deciphering the above log is beyond my capabilities. I think it is time
to file an issue here:

https://github.com/pgbouncer/pgbouncer/issues



--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Steve Litt
Date:
Subject: Re: Code of Conduct plan
Next
From: Raymond O'Donnell
Date:
Subject: Re: postgresql api