PGXL Cluster Construction
A preparation
1 Download Install decompression source/opt/
Curl-o http://files.postgres-xl.org/postgres-xl95r1beta1.tar.gz
TAR-ZXVF postgres-xl95r1beta1.tar.gz
MV Postgres-xl95r1beta1.tar.gz POSTGRES-XL
2 compiling
$ yum-y gcc
$ CD POSTGRES-XL
$ pwd
/opt/postgres-xl
$./configure
Error: Configure:error:readline Library not found
FIX: $ RPM-QA | grep ReadLine
Readline-6.2-9.el7.x86_64
$ yum Search ReadLine
$ yum install-y readline-devel
$./configure
Error: Configure:error:zlib Library not found
Solution: Ibid.
$ yum install-y
$./configure
Ok!
$ make
Error: Error: ' Perl ' is missing on your system.
FIX: $ yum install-y perl
$./configure
You need to install Flex bison in turn
$ make Install
Default installation directory/usr/local/pgsql can./configure--prefix= path specified directory
3 Installing the Cluster management tool PGXC_CTL
cd/opt/postgres-xl/contrib/pgxc_ctl/
$ make
$ make Install
Two environment variables
$ vi/etc/profile.d/pgxl.sh
Export Pghome=/usr/local/pgsql
Export Pguser=postgres
Export Ld_library_path= $PGHOME/lib
Export path= $PGHOME/bin: $PATH
Export datadirroot= $HOME/data/pgxl/nodes
$ chmod 777/etc/profile.d/pgxl.sh
$ source/etc/profile.d/pgxl.sh
Three Create a new user
$ useradd Postgres
$ passwd Postgres
Four Modify directory Permissions
Chown-r Postgres:postgres/usr/local/pgsql
Five Password-free login
$ su-postgres
$ ssh-keygen-t DSA
$ cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
$ chmod 710 A~/.ssh/authorized_keys
Verifying ssh localhost
Note that the current user is Postgres
Six using the PGXC_CTL command tool
$ pgxc_ctl access to management tools
Reference
Hello World Example
Http://files.postgres-xl.org/documentation/tutorial-createcluster.html
Specific operation
Http://files.postgres-xl.org/documentation/pgxc-ctl.html
Note Slave Coordinator/datanode failed to start
Postgres:postgres-xl:must start as either a coordinator (--coordinator) or Data Node (--datanode)
Pg_ctl:could not determine the data directory using command ""/usr/local/pgsql/bin/postgres "-C data_directory-d"/home/ Postgres/data/pgxl/nodes/dir.1 ""
Refer
http://blog.csdn.net/liuzongxi/article/details/46380985
http://blog.csdn.net/jj_tyro/article/details/45219007
POSTGRES-XL Collective Construction