pgbouncer配置

参考https://my.oschina.net/Kenyon/blog/73935

1. pgbouncer.ini配置如下，其中连接postgresql的用户名为postgres密码为test：

[databases]

pgsql1 = host=127.0.0.1 port=5432 dbname=postgres user=postgres password=test

[pgbouncer]
listen_port = 6543
listen_addr = 0.0.0.0
auth_type = md5
auth_file = /opt/pgbouncer/userlist_gp.txt
logfile = /tmp/pgbouncer.log
pidfile = /tmp/pgbouncer.pid
admin_users = postgres

pool_mode = Transaction

2.  /opt/pgbouncer/userlist_gp.txt文件中为pgbouncer的用户名密码

"postgres" "123456"

3.启动程序为./pgbouncer  -d -u postgres pgbouncer_gp.ini

可以通过psql连接到pgbouncer，命令为

psql -U postgres -d pgsql1 -p 6543 -h localhost