pgbouncer工具安装使用

pgbouncer安装

安装libevent

libevent下载地址：
https://github.com/downloads/libevent/libevent/libevent-2.0.21-stable.tar.gz

安装：

# wget https://github.com/downloads/libevent/libevent/libevent-2.0.21-stable.tar.gz  
# tar -zxvf libevent-2.0.21-stable.tar.gz
# cd libevent-2.0.21-stable
# ./configure --prefix=/usr/libevent/libevent
# make
# make install

安装pgbouncer

pgbouncer下载地址：
https://pgbouncer.github.io/downloads/

# tar -zxvf pgbouncer-1.7.2.tar.gz
# cd pgbouncer-1.7.2
# ./configure --prefix=/usr/pgbouncer/ --with-libevent=/usr/libevent/libevent
# make
# make install

环境变量配置

环境变量增加如下内容：

# vi /etc/profile
 export LD_LIBRARY_PATH=/usr/libevent/libevent/lib:$LD_LIBRARY_PATH
 export PATH=$PATH:/usr/libevent/libevent/bin
# source profile

pgbouncer配置文件

# cd /usr/pgbouncer/share/doc/pgbouncer
# vi pgbouncer.ini

[databases]  
postgres=host=127.0.0.1 port=5432 user=postgres dbname=postgres pool_size=100  

[pgbouncer] 
logfile = /usr/pgbouncer/log/pgbouncer.log  
pidfile = /usr/pgbouncer/pgbouncer.pid  
admin_users = postgres  

listen_addr = 127.0.0.1
listen_port = 6432  

auth_type =