Postgres-XL集群安装与配置

有一个gtm，两个coordinator，两个datanode，所有节点安装在一台机器。安装配置如下图：

IP 角色 端口 Nodename 安装目录 192.168.8.106 GTM 6666 gtm /pgxl_data/gtm 192.168.8.106 Coordinator 1921 coord1 /pgxl_data/coordinator/cd1 192.168.8.106 Coordinator 1925 coord2 /pgxl_data/coordinator/cd2 192.168.8.106 Datanode 15431 db1 /pgxl_data/datanode/dn1 192.168.8.106 Datanode 15432 db2 /pgxl_data/datanode/dn2 3、安装配置

1）创建用户

#groupadd pgxl #useradd pgxl -g pgxl #passwd pgxl

2）安装 安装依赖库

#yum install –y flex bison readline-devel zlib-devel openjade docbook-style-dsssl 解压：

#tar -xzvf postgres-xl-v9.2-src.tar.gz #cdpostgres-xl

#./configure –prefix=/usr/local/pgsql_xl #make #make install 3)创建存放路径

#mkdir –p /pgxl_data/gtm

#mkdir –p /pgxl_data/coordinator/cd1 #mkdir –p /pgxl_data/coordinator/cd2 #mkdir –p /pgxl_data/datanode/dn1 #mkdir –p /pgxl_data/datanode/dn2 #chown –R pgxl:pgxl /pgxl_data 4)配置环境变量 #su – pgxl $vi .bash_profile

export PGHOME=/usr/local/pgsql_xl export LANG=en_US.utf8 export

LD_LIBRARY_PATH=$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/lib

export PATH=$PGHOME/bin:$PATH:.

export MANPATH=$PGHOME/share/man:$MANPATH 修改后使配置文件生效： $source .bash_profile

5）初始化节点

$initgtm -Z gtm -D /pgxl_data/gtm

$initdb -D /pgxl_data/coordinator/cd1 –nodename coord1 $initdb -D /pgxl_data/coordinator/cd2 –nodename coord2 $initdb -D /pgxl_data/datanode/dn1 –nodename db1 $initdb -D /pgxl_data/datanode/dn2 –nodename db2 6）配置节点 ? 配置gtm节点

$vi /pgxl_data/gtm/gtm.conf #修改gtm.conf文件 nodename = ‘gtm’ listen_addresses = ‘*’ port = 6666 startup = ACT ? 配置coordinator节点

vi /pgxl_data/coordinator/cd1/postgresql.conf #修改cd1节点的postgresql

listen_addresses = ‘*’ port = 1921

max_connections = 100

# DATA NODES AND CONNECTION POOLING

#———————————————-

pooler_port = 6661 max_pool_size = 100 # GTM CONNECTION #—————————– gtm_host = ‘192.168.8.106’ gtm_port = 6666

pgxc_node_name = ‘coord1’

vi /pgxl_data/coordinator/cd1/pg_hba.conf # IPv4 local connections: host all all 127.0.0.1/32 trust host all all 0.0.0.0/0 md5

vi /pgxl_data/coordinator/cd2/postgresql.conf #———————————— listen_addresses = ‘*’ port = 1925

max_connections = 100

# DATA NODES AND CONNECTION POOLING #———————————————- pooler_port = 6662 max_pool_size = 100 # GTM CONNECTION #—————————– gtm_host = ‘192.168.8.106’ gtm_port = 6666

pgxc_node_name = ‘coord2’

vi /pgxl_data/coordinator/cd2/pg_hba.conf # IPv4 local connections: host all all 127.0.0.1/32 trust host all all 0.0.0.0/0 md5 ? 配置datanode节点

vi /pgxl_data/datanode/dn1/postgresql.conf #———————————— listen_addresses = ‘*’ port = 15431

max_connections = 100

# DATA NODES AND CONNECTION POOLING #———————————————- pooler_port = 6667 #min_pool_size = 1 max_pool_size = 100 # GTM CONNECTION #—————————– gtm_host = ‘192.168.8.106’ gtm_port = 6666

pgxc_node_name = ‘db1’