pgbouncer连接greenplum单机

1. 首先根据http://blog.osdba.net/69.html，修改pgbouncer的代码，并编译

2. 编写配置文件如下所示：

[databases]
gp.1 = host=gp1 port=40000 dbname=test user=gpadmin  options='-c gp_session_role=utility'
gp.2 = host=gp2 port=40000 dbname=test user=gpadmin  options='-c gp_session_role=utility'
gp.3 = host=gp3 port=40000 dbname=test user=gpadmin  options='-c gp_session_role=utility'





[pgbouncer]
listen_port = 5432
listen_addr = 0.0.0.0
auth_type = md5
auth_file = /root/pgbouncer/userlist_gp.txt
logfile = /tmp/pgbouncer.log
pidfile = /tmp/pgbouncer.pid
admin_users = gpadmin
pool_mode = statement
routing_rules_py_module_file = /root/pgbouncer/routing_rules.py
~                                                                

3. 修改routing_rules.py加入分载策略