1.安装依赖包
yum -y install zliblg-dev libreadine6-dev bison flex libperl-devel gcc perl-ExtUtils-Embed readline-devel zlib-devel python python-devel |
2.安装
./configure --prefix=/usr/local/pgxc --with-perl --with-python
make
make install
|
3.环境变量:
export PATH=/usr/local/pgxc/bin:$PATH
export LD_LIBRARY_PATH=/usr/local/pgxc/lib:LD_LIBRARY_PATH
|
4. 配置 postgres-XC集群
主机名 | ip | 角色 | 端口 | nodename | 数据目录 |
gtm | 56.56.56.95 | Gtm | 6666 | one | /data/gtm |
gtm_standby | 56.56.56.96 |
Gtm备库 | 6666 | two | /data/gtm_standby |
cd1 | 56.56.56.97 |
Coordinator | 5432 | co1 | /data/coordinator |
Datanode | 5433 | dn1 | /data/pgdata | ||
Gtm Proxy | 6666 | gtmpoxy01 | /data/gtm_proxy | ||
cd2 | 56.56.56.98 |
Coordinator | 5432 | co2 | /data/coordinator |
Datanode | 5433 | dn2 | /data/pgdata | ||
Gtm Proxy | 6666 | gtmpoxy02 | /data/gtm_proxy | ||
cd3 | 56.56.56.99 |
Coordinator | 5432 | co3 | /data/coordinator |
Datanode | 5433 | dn3 | /data/pgdata | ||
Gtm Proxy | 6666 | gtmpoxy03 | /data/gtm_proxy |
5. 5安装 Postgres-XC,五台机器都要安装
6. 5台机器上都配置hosts
56.56.56.95 gtm
56.56.56.96 gtm_standby
56.56.56.97 cd1
56.56.56.98 cd2
56.56.56.99 cd3
|
7.95 和 96 GTM 机器 创建对应的数据目录
mkdir -p /data/gtm
mkdir -p /data/gtm_standby
|