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 ¨Cy flex bison readline-devel zlib-devel openjade docbook-style-dsssl ½âѹ£º

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

#./configure ¨Cprefix=/usr/local/pgsql_xl #make #make install 3)´´½¨´æ·Å·¾¶

#mkdir ¨Cp /pgxl_data/gtm

#mkdir ¨Cp /pgxl_data/coordinator/cd1 #mkdir ¨Cp /pgxl_data/coordinator/cd2 #mkdir ¨Cp /pgxl_data/datanode/dn1 #mkdir ¨Cp /pgxl_data/datanode/dn2 #chown ¨CR pgxl:pgxl /pgxl_data 4)ÅäÖû·¾³±äÁ¿ #su ¨C 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 ¨Cnodename coord1 $initdb -D /pgxl_data/coordinator/cd2 ¨Cnodename coord2 $initdb -D /pgxl_data/datanode/dn1 ¨Cnodename db1 $initdb -D /pgxl_data/datanode/dn2 ¨Cnodename 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 #¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¨C 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 #¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¨C 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 #¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¨C gtm_host = ¡®192.168.8.106¡¯ gtm_port = 6666

pgxc_node_name = ¡®db1¡¯