Hello,
I am a bit confused about the settings in pgbouncer
What's exactly the pool_size?
If I set 3, and I tried to connect from 4 shells, I am still able to connect.
Same thing for max_db_connections. I set this to 1 and I am able to connect from 2 shells.
This is kind of confusing and I'm not really cleared reading the documentation.
This is my config.
[databases]
cmdwela = host=127.0.0.1 port=5432 dbname=cmdwela auth_user=pgbouncer pool_size=120
cicciopasticcio = host=127.0.0.1 port=5432 dbname=cicciopasticcio auth_user=pgbouncer pool_size=2
[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=1
log_connections=0
log_disconnections=0
max_client_conn=5
I just want to limit connections from the app etc.
Thanks
