pgbouncer

Поиск
Список
Период
Сортировка
От Nicola Contu
Тема pgbouncer
Дата
Msg-id CAMTZZh3y74kZXxnvofLJxqc3bw0Pz6ddRS5i4LM24Y1MYMRV2A@mail.gmail.com
обсуждение исходный текст
Ответы Re: pgbouncer  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Barman versus pgBackRest
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: pgbouncer