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@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.klaver@xxxxxxxxxxx
