安装配置PGBouncer连接池

su - pg10cd resource/tar-zxf pgbouncer-1.14.0.tar.gz
复制

mkdir~/pgbouncer
复制

su - rootyum install-y libevent-devel(或者su - rootrpm-ivh libevent-devel-2.0.21-4.el7.x86_64.rpm)
复制

su - pg10cd resource/pgbouncer-1.14.0/./configure--prefix=/home/pg10/pgbouncer
复制

make - j4
复制

make install - j4
复制

cd~/pgbouncer/
复制

egrep  -v '^\;| ^$' /home/pg10/pgbouncer/share/doc/pgbouncer/pgbouncer.ini > pgbouncer.ini
复制

[databases]appdb = host=主机ip dbname=appdb port=5666[pgbouncer]logfile = /home/pg10/pgbouncer/pgbouncer.logpidfile = /home/pg10/pgbouncer/pgbouncer.pidlisten_addr = *listen_port = 5766auth_type = trustauth_file = /home/pg10/pgbouncer/userlist.txtcd /home/pg10/pgbouncer/cp share/doc/pgbouncer/userlist.txt .vi userlist.txt
复制

'appuser' '1qaz@WSX'
复制

su - pg10cd vi .bashrc将PATH变成export PATH=${PGHOME}/bin:/home/pg10/pgbouncer/bin:${PATH}
复制

. .bashrcpgbouncer --helppgbouncer -d -v /home/pg10/pgbouncer/pgbouncer.ini
复制

host appdb appuser 192.168.2.0/24 trust
复制

pg_ctl reload psql -U appuser -d appdb -p 5766
复制

su - root
ps -ef | grep pgbouncer
kill -9 21429
pgbouncer -d -v /home/pg10/pgbouncer/pgbouncer.ini

复制

psql -U appuser -d appdb -p 5766 
连接成功

复制