PgBouncer安装和配置

软件下载：

PgBouncer Downloads

https://www.pgbouncer.org/downloads/

软件安装：

$ ./configure --prefix=/usr/local
$ make
$ make install

软件配置：

[pg10@db01 pgbouncer]$ cat pgbouncer.ini 
[databases]
;;; 未设置用户密码，需要使用auth_file密码连接数据。
appdb=host=db01 port=5666 user=appuser password=1qaz@WSX dbname=appdb
[pgbouncer]
logfile = /home/pg10/pgbouncer/pgbouncer.log
pidfile = /home/pg10/pgbouncer/pgbouncer.pid
auth_type = md5
auth_file = /data/pg
listen_addr = *
listen_port = 5766
[pg10@db01 pgbouncer]$ cat /data/pg 
"appuser"	"1qaz@WSX"

软件连接测试：

启动pgbouncer：

/home/pg10/pgbouncer/bin/pgbouncer -d /home/pg10/pgbouncer/pgbouncer.ini

连接端口5766：

[pg10@db01 ~]$ psql -h db01 -p 5766 -d appdb -U appuser
Password for user appuser: 
psql (10.14)
Type "help" for help.

appdb=>