Pgbouncer [postgres]

Installer pgbouncer , configurer le .ini :

cat /etc/pgbouncer/pgbouncer.ini

[databases]
<aliasBDD> = dbname=test user=pg_test port=5433 pool_size=48

[pgbouncer]
logfile = /var/log/pgbouncer/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
auth_file = /etc/pgbouncer/userlist.txt
listen_addr = <hostname>-pgb
listen_port = 5432
auth_type = trust
admin_users = pgbouncer
stats_users = monitor

pool_mode = transaction

#server_reset_query =
server_reset_query =
max_client_conn = 1800
default_pool_size = 20
unix_socket_dir = /tmp

ignore_startup_parameters = extra_float_digits, application_name
server_check_query = select 1
server_check_delay = 10
log_connections = 1
log_disconnections = 1
log_pooler_errors = 1

Se connecter au pgbouncer :

su – pgbouncer

psql

show databases : affiche les databases liés