1创建数据库账户

Userdel postgres

Useradd postgres

2修改postgres 密码

echo 'GTdbs_postgres' |passwd postgres

3安装数据库

postgresql93-9.3.5-1PGDG.rhel6.x86_64.rpm

postgresql93-contrib-9.3.5-1PGDG.rhel6.x86_64.rpm

postgresql93-libs-9.3.5-1PGDG.rhel6.x86_64.rpm

postgresql93-server-9.3.5-1PGDG.rhel6.x86_64.rpm

4安装 httpd

yum install -y php php-psql httpd php-mbstring

[root@AY14070116183406951aZ mnt]# mkdir -p /mnt/pgdb/data

[root@AY14070116183406951aZ mnt]# mkdir -p /mnt/pgpool/log

6授权

[root@AY14070116183406951aZ mnt]# chown -R postgres.postgres /mnt/pgdb/

[root@AY14070116183406951aZ mnt]# chown -R postgres.postgres /mnt/pgpool/

6初始化数据库

Su – postgres

vim .bash_profile

PGDATA=/mnt/pgdb/data

Initdb /mnt/pgdb/data

Pgctl start

Psql

\password

GTdbs_postgresql

#Createuser pgpool GTdbs_pool

7安装pgpool

安装php php-psql httpd php-mbstring

yum install -y php php-psql httpd php-mbstring

配置 ssh 对等协议

ssh-keygen

ssh-copy-id

安装pgpoo

./install.sh

[root@pgdb2 installer-pg93-3.3.3]# ./install.sh

check for installation ...OK.

=================================================================

Permission to use, copy, modify, and distribute this software and

its documentation for any purpose and without fee is hereby

granted, provided that the above copyright notice appear in all

copies and that both that copyright notice and this permission

notice appear in supporting documentation, and that the name of the

author not be used in advertising or publicity pertaining to

distribution of the software without specific, written prior

permission. The author makes no representations about the

suitability of this software for any purpose. It is provided "as

is" without express or implied warranty.

=================================================================

[input] Do you accept the end user software license agreement? (yes/no):

yes

=================================================================

Configuration

=================================================================

----------------------------------------------------------------------

Configuring Host, User, SSH ...

----------------------------------------------------------------------

* Node information

Two-node cluster (node 0 and node 1) is assumed.

[input] Specify node 0's hostname or IP address : 192.168.1.223

[input] Specify node 1's hostname or IP address : 192.168.1.232

Which node is this?

If this is node 0, a database cluster is created by initdb after installation.

Otherwise if this is node 1, the configurations on node 0 is reused.

登录网页调整参数

http://ip/pgpoolAdmin/status.php

在第二台主机安装pgpool

可能遇到的问题

e1006 无法更新pgpool。conf 参考网址 http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting_3.1/index.html

chown apache /usr/local/etc/pgpool.conf
chmod 777 /var/log/pgpool/trigger

[root@pgdb1 pgpoolAdmin]# chown apache conf/pgmgt.conf.php
[root@pgdb1 pgpoolAdmin]# chmod 644 conf/pgmgt.conf.php

setenforce 0

ITPub博客

pgpool rpm安装方式