Re: Pgbouncer and postgres

The log is from pgbouncer.

I installed updates after this problem, but they did not resolve anything.

I compiled 1.9.0 from source on the same path of the previous one. Then
back to 1.8.1 on the same path.

I also tried changing the listening port on pgbouncer, but that does not
change too much.
I can connect via telnet on that port, but we I try with anything else
(like Apache) it makes pgbouncer crashing.

Il giorno lun 17 set 2018 alle ore 15:44 Adrian Klaver <
adrian(dot)klaver(at)aklaver(dot)com> ha scritto:

> On 9/17/18 5:33 AM, Nicola Contu wrote:
> > Hello,
> >
> > I'm trying to get pgbouncer working but I'm getting this error :
> >
> >
>
> What is generating the log below?
>
> To me it looks like everything is on track until this:
>
> > 2018-09-17 12:21:48.917 88424 WARNING tune_socket(13) failed: Operation
> > not supported
> > 2018-09-17 12:21:48.917 88424 NOISE safe_close(13) = 0
> > 2018-09-17 12:21:48.918 88424 NOISE safe_accept(12) = Resource
> > temporarily unavailable
> > 2018-09-17 12:22:14.422 88424 LOG Stats: 0 xacts/s, 0 queries/s, in 0
> > B/s, out 0 B/s, xact 0 us, query 0 us wait time 0 us
> > 2018-09-17 12:23:14.423 88424 LOG Stats: 0 xacts/s, 0 queries/s, in 0
> > B/s, out 0 B/s, xact 0 us, query 0 us wait time 0 us
> > 2018-09-17 12:23:26.561 88424 LOG Got SIGINT, shutting down
> > 2018-09-17 12:23:26.872 88424 LOG server connections dropped, exiting
> > 2018-09-17 12:23:26.872 88424 NOISE safe_close(11) = 0
> > 2018-09-17 12:23:26.872 88424 NOISE safe_close(12) = 0
> >
> >
> > Postgres version : 10.5
> >
> > Libevent : 2.0.5
> >
> > Pgbouncer : 1.8.1
> >
> > OS : Centos 7
>
> Have there been updates to CentOS during this?
>
> >
> >
> > It used to work. Now after trying to install latest version of pgbouncer
> > (1.9.0) does not work anymore. Then I re-compiled the v 1.8.1
>
> Did you compile 1.9.0 from source or install from package?
>
> >
> >
> >
> > Content of the pgbouncer.ini
> >
> > [databases]
> > DB_NAME = host=IP_ADDD port=5432 dbname=DB_NAME auth_user=pgbouncer
> > pool_size=120
> >
> > [pgbouncer]
> > listen_port = 6543
> > listen_addr = *
> > auth_type = md5
> > auth_file = /etc/pgbouncer/users.txt
> > auth_query = select uname,phash from user_lookup($1)
> > logfile = /var/log/pgbouncer.log
> > pidfile = /home/postgres/pgbouncer.pid
> > admin_users = admin
> > user=postgres
> > max_db_connections = 220
> > log_connections=0
> > log_disconnections=0
> > verbose=3
> >
> >
> > Content of the users .txt
> >
> > [root(at)cmd-dev1 pgbouncer]# cat users.txt
> > "pgbouncer" "***************"
> >
> >
> > I tried to change the listen address to 127.0.0.1 or to the IP of the
> > VM. Nothing changed.
> >
> >
> > Can anyone help?
> >
> >
> > Thanks
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>