Pgpool源码安装：


wget http://ftp.postgresql.org/pub/source/v9.2.0/postgresql-9.2.0.tar.gz


tar xzvf pgpool-II-3.2.0.tar.gz
cd pgpool-II-3.2.0/

tar czvf doc.tgz doc/


./configure

make && make install

pushd /usr/local/etc/

cp pgpool.conf.sample pgpool.conf

cp pcp.conf.sample pcp.conf

pg_md5 longlong

grep pcp_port pgpool.conf

mkdir -p /var/run/pgpoolLinux VI 命令 pgpool.conf

##
## added by maguirun.
listen_addresses = '*'

## added by maguirun.
backend_hostname0 = 'localhost'
backend_port0 = 5432

backend_hostname1 = '10.3.2.85'
backend_port1 = 5432

## added by maguirun.
replication_mode = true

## added by maguirun.
load_balance_mode = true


Linux VI 命令 pcp.conf

###
admin:0bc651ef7626a7868da4cbfdbe70f96f


Linux VI 命令 start_pgpool.sh

####
## Created by maguirun.
#!/bin/sh
echo "============> shutting down the pgpool:"
pgpool stop
echo "============> starting the pgpool:"
pgpool -n -d > pgpool.log 2>&1 &
sleep 3
ps -ef |grep pgpool