Postgres-XC 1.0.4安装.doc

安装环境 准备一台Centos 6.5 GNOME 2.28.2安装配置如下图： IP 角色 ?端口 Nodename 安装目录 51 GTM 6666 gtm /pgxc_data/gtm 51 Coordinator 1921 coord1 /pgxc_data/coordinator/cd1 51 Coordinator 1925 coord2 /pgxc_data/coordinator/cd2 51 Datanode 15431 db1 /pgxc_data/datanode/dn1 51 Datanode 15432 db2 /pgxc_data/datanode/dn2 有条件的可以把这个角色分别安装在不同主机上。 安装配置 1）创建用户#groupadd pgxc#useradd pgxc -g pgxc#passwd pgxc2)安装#tar -xzvf pgxc-v1.0.4.tar.gz#cd postgres-xc-1.0.4#./configure –prefix=/usr/local/pgsql_xc#make#make install3）创建存放路径#mkdir -p /pgxc_data/gtm#mkdir -p /pgxc_data/coordinator/cd1#mkdir -p /pgxc_data/coordinator/cd2#mkdir -p /pgxc_data/datanode/dn1#mkdir -p /pgxc_data/datanode/dn2#chown -R pgxc:pgxc /pgxc_data4）配置环境变量#su – pgxc#vi .bash_profileexport PGHOME=/usr/local/pgsql_xcexport LANG=en_US.utf8export LD_LIBRARY_PATH=$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/libexport PATH=$PGHOME/bin:$PATH:.export MANPATH=$PGHOME/share/man:$MANPATH#source .bash_profile5）初始化节点#initgtm -Z gtm -D /pgxc_data/gtm#initdb -D /pgxc_data/coordinator/cd1 –nodename coord1#initdb -D /pgxc_data/coordinator/cd2 –nodename coord2#initdb -D /pgxc_data/datanode/dn1 –nodename db1#initdb -D /pgxc_data/datanode/dn2 –nodename db26)配置节点配置gtm节点vi /pgxc_data/gtm/gtm.confnodename = ‘gtm’listen_addresses = ‘*’port = 6666startup = ACT 配置 coordinator 节点vi /pgxc_data/coordinator/cd1/postgresql.conf#————————————listen_addresses = ‘*’port = 1921max_connections = 100# DATA NODES AND CONNECTION POOLING#———————————————-pooler_port = 6667#min_pool_size = 1max_pool_size = 100 # GTM CONNECTION#—————————–gtm_host = ‘51’gtm_port = 6666pgxc_node_name = ‘coord1’ vi /pgxc_data/coordinator/cd1/pg_hba.conf# IPv4 local connections:host all all /32 trusthost all all 51/32 trusthost all all /0 md5 vi /pgxc_data/coordinator/cd2/postgresql.conf#————————————listen_addresses = ‘*’port = 1925max_connections = 100# DATA NODES AND CONNECTION POOLING#—————————————