最新版postgresql+pgboucer安裝

標籤：

安裝postgresql:

wget https://pgbouncer.github.io/downloads/files/1.7.2/pgbouncer-1.7.2.tar.gzwget http://get.enterprisedb.com/postgresql/postgresql-9.5.1-1-linux-x64.runwget https://github.com/libevent/libevent/releases/download/release-2.0.22-stable/libevent-2.0.22-stable.tar.gztar zxvf libevent-2.0.22-stable.tar.gzcd libevent-2.0.22-stable./configure --prefix=/alidata/local/libeventmakemake installcd ..tar zxvf pgbouncer-1.7.2.tar.gzcd pgbouncer-1.7.2./configure --prefix=/alidata/local/pgbouncer/ --with-libevent=/alidata/local/libevent/make make installcd ..chmod 777 postgresql-9.5.1-1-linux-x64.run./postgresql-9.5.1-1-linux-x64.runsudo chown -R postgres.postgres /alidata/pgsqlsudo chown -R postgres.postgres /alidata/local/pgbouncersu - postgrescp .bash_profile /alidata/pgsqlcp .bashrc  /alidata/pgsqlsu - postgresexport PGHOME=/alidata/pgsqlexport PATH=$PGHOME/bin:$PATHexport PGDATA=$PGHOME/dataexport LD_LIBRARY_PATH=$PGHOME/libexport LD_LIBRARY_PATH=/usr/local/libevent/lib:$LD_LIBRARY_PATH[ -z "`cat /alidata/pgsql/data/pg_hba.conf | grep ‘fs.file-max‘`" ] && cat >> /alidata/pgsql/data/pg_hba.conf << EOFhost  all   all   192.170.206.0/24   md5EOFsu postgres./pg_ctl -D /alidata/pgsql/data/ reload#chkconfig --list postgresql-9.0  #chkconfig --list postgresql-9.0  #netstat -ano | grep 5432 #echo "SU_WHEEL_ONLY yes" >> /etc/login.defs#more /opt/PostgreSQL/9.0/data/pg_log/startup.log #rm -rf /alidata/pgsql#rm -rf postgres-reg.ini #檢查服務狀態：service --status-allservice --status-all | grep ntpdservice --status-all | lessservice httpd status#列出所有服務啟動層級：chkconfig --list#列出服務和他們對應的連接埠：netstat -tulpnchkconfig –list #查看服務命令#chkconfig --add postgresql#vim /alidata/pgsql/9.5/data/postgresql.conf       （監聽更改為*）#listen_addresses = ‘*‘#/usr/local/pgbouncer/bin/pgbouncer -d /usr/local/pgbouncer/conf/pgbouncer.ini#/alidata/local/pgbouncer/bin/pgbouncer -d /alidata/local/pgbouncer/conf/pgbouncer.ini

 

安裝pgbouncer

:http://pgfoundry.org/frs/download.php/2987/pgbouncer-1.4.1.tgz

安裝

tar -zxvf pgbouncer-1.7.2.tgz

cd pgbouncer-1.7.2

./configure --prefix=/usr/local/pg_bouncer

make

make install

最新版postgresql+pgboucer安裝