sudo apt-get install pgbouncer
修改 /etc/pgbouncer/下的pgbouncer.ini和userlist.txt
[databases]
MES2_DB = host=192.168.1.1 port=5432 dbname=xxx pool_size=1000
[pgbouncer]
listen_addr = *
listen_port = 6432
;; any, trust, plain, md5, cert, hba, pam
auth_type = plain
pool_mode = transaction
max_client_conn = 1000
default_pool_size = 50
min_pool_size = 5
log_connections = 0
log_disconnections = 0
server_idle_timeout = 300重启：systemctl restart pgbouncer