Bonjour Guillaume,

Voci la configuration utilisée:

Le fichier /etc/ pgbouncer.ini:

[databases]
pppm = host=127.0.0.1 port=5433 dbname=ppm_db
pppm4 = host=127.0.0.1 port=5433 dbname=ppm_db
;; Configuation section
[pgbouncer]
;;
;;; Administrative settings
;;;
logfile = /var/log/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
;;;
;;; Where to wait for clients
;;;
; ip address or * which means all ip-s
listen_addr =  *
listen_port = 6432
unix_socket_dir = /tmp
;;;
;;; Authentication settings
;;;
; any, trust, plain, crypt, md5
auth_type = trust
auth_file = /etc/pgbouncer/userlist.txt
;;;
;;; Users allowed into database 'pgbouncer'
;;;
; comma-separated list of users, who are allowed to change settings
admin_users = pgbouncer_admin
; comma-separated list of users who are just allowed to use SHOW command
stats_users = pgbouncer_admin,stats, root
2. le fichier /etc/pgbouncer/userlist.txt
"pgbouncer_admin" "pgbouncer_admin_99"
"ppm_adm" "ppm_adm_99"
"aoc_adm" "aoc_adm_99"

3. Lancement du  pgbouncer:
$ pgbouncer -d /etc/pgbouncer.ini

4. un test à partir d’un client sur une base de PostgreSQL server :
$ psql -p 6432 -d pppm4 -U ppm_adm
psql.bin (9.2.7)
Type "help" for help.
pppm4=> \conninfo
You are connected to database "pppm4" as user "ppm_adm" on host "victor.m8.fr" at port "6432".
pppm4=>

Merci d'avance

Victor