系统环境准备
1 创建用户：
sudo groupadd postgres
sudo useradd -g postgres postgres
2 创建目录并赋权
sudo mkdir -p /opt/pgbouncer
sudo mkdir -p /export/pgbouncer_data
sudo chown -R postgres: /export/pgbouncer
3 安装依赖包
sudo apt-get install openssl
sudo apt-get install libssl-dev
4 安装libevent
wget http://www.monkey.org/~provos/libevent-2.0.22.tar.gz
tar -zxvf libevent-2.0.22.tar.gz
cd libevent-2.0.22
sudo ./configure --prefix=/usr
make
make install安装pgbouncer
官网：https://pgbouncer.github.io/
1 先去官网下载pgbouncer源码安装包，下载地址：https://pgbouncer.github.io/downloads/
2 解压安装包：tar -zxvf pgbouncer-1.7.2.tar.gz
3 源码安装：
$ ./configure --prefix=/opt/pgbouncer --with-libevent=libevent-prefix
$ make
$ make install配置文件
所有的配置文件都在/export/pgbouncer_data下
1 配置pgbouncer.ini文件
[databases]
* = host=along port=5432 user=along password=along pool_size=20
[pgbouncer]
listen_port = 6432
listen_addr = 127.0.0.1
;unix_socket_dir = ''
;user = postgres
auth_type = md5
auth_file = /export/pgbouncer_data/users.txt
logfile = /export/pgbouncer_data/pgbouncer.log
pidfile = /export/pgbouncer_data/pgbouncer.pid
admin_users = postgres
stats_users = mon
pool_mode = session
client_idle_timeout=10
server_idle_timeout=1800
idle_transaction_timeout=10
client_login_timeout=10
server_reset_query = DEALLOCATE ALL;
server_check_query = select 1
server_check_delay = 10
reserve_pool_size = 5
reserve_pool_timeout = 5
max_client_conn = 50
default_pool_size = 20
log_connections = 0
log_disconnections = 0
log_pooler_errors = 1
ignore_startup_parameters = extra_float_digits
2 配置users.txt文件
-- ”用户名“ ”密码“
"along" "along"
“postgres” "postgres"
3 配置ip_limit文件
192.0.0.0/8
4 配置环境变量
export PATH=/opt/pg10/bin:/opt/pgbouncer/bin:$PATH
source .bashrc启动pgbouncer
postgres@along:/export/pgbouncer_data$ pgbouncer -d /export/pgbouncer_data/pgbouncer.ini
2017-07-20 21:10:55.952 11381 LOG File descriptor limit: 1024 (H:65536), max_client_conn: 50, max fds possible: 60
2017-07-20 21:10:55.953 11381 FATAL @src/main.c:893 in function main(): unix socket is in use, cannot continue
原因：
在/tmp目录下已经有端口5432的socket
postgres@along:/export/pgbouncer_data$ ll /tmp |grep -i .s.PG
srwxrwxrwx 1 postgres postgres 0 7月 20 21:14 .s.PGSQL.5432=
-rw------- 1 postgres postgres 47 7月 20 21:14 .s.PGSQL.5432.lock
解决方法：
修改pgbouncer.ini 配置文件下的listen_port = 5432 为 6432
postgres@along:/export/pgbouncer_data$ pgbouncer -d /export/pgbouncer_data/pgbouncer.ini
2017-07-20 21:20:56.546 11637 LOG File descriptor limit: 1024 (H:65536), max_client_conn: 50, max fds possible: 60
postgres@along:/export/pgbouncer_data$ ll /tmp |grep -i .s.PG
srwxrwxrwx 1 postgres postgres 0 7月 20 21:14 .s.PGSQL.5432=
-rw------- 1 postgres postgres 47 7月 20 21:14 .s.PGSQL.5432.lock
srwxrwxrwx 1 postgres postgres 0 7月 20 21:20 .s.PGSQL.6432=
pgbouncer启动成功登录pgbouncer控制台
postgres@along:/export/pgbouncer_data$ psql -h 127.0.0.1 -Upostgres -p 6432 pgbouncer
Password for user postgres:
psql (10beta1, server 1.7.2/bouncer)
Type "help" for help.
pgbouncer=#
