POSTGRES-XL Collective Construction

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.