参考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