Home > mailing lists

pgbouncer - Mailing list pgsql-general

From	Nicola Contu
Subject	pgbouncer
Date	January 17, 2019 18:18:25
Msg-id	CAMTZZh3y74kZXxnvofLJxqc3bw0Pz6ddRS5i4LM24Y1MYMRV2A@mail.gmail.com Whole thread Raw
Responses	Re: pgbouncer
List	pgsql-general

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

From: Achilleas Mantzios
Date: 17 January 2019, 18:15:04
Subject: Re: Barman versus pgBackRest

From: "David G. Johnston"
Date: 17 January 2019, 18:32:41
Subject: Re: pgbouncer