当前位置:首页 > 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’
共分享92篇相关文档