======Overview======
PostgreSQL-XL and later installment of the PostgreSQL code.Unlike the PostgreSQL-XC PostgreSQL-XL is more suitable for OLAP/Warehouse systems since it is tightly linked with SQL and Parallel execution.
{{:postgresql-xl-overview.jpg?500|}}
We will discuss the following stages of installing the PostgreSQL-XL cluster. For clarity reasons, let's assume we have the following instances:
GTM:
hostname=psqlxla
nodename=gtm
IP=192.168.100.10
port=6666
Coordinator：
hostname=psqlxlb
nodename=coord1
IP=192.168.100.20
pooler_port=6668，port=5432
Datanode1：
hostname=psqlxlc
nodename=datanode1
IP=192.168.100.30
pooler_port=6669, port=15432
Datanode2：
hostname=psqlxld
nodename=datanode2
IP=192.168.100.40
pooler_port=6670, port=15433
======Software Installation======
There are many ways how you can download / install PostgreSQL-XL cluster, but the safest way is to use GIT, so let's do it like this :)
=====Using Git=====
Git client should be firstly installed so we can download the needed packages:
[root@psqlxla ~]# yum install git
Loaded plugins: fastestmirror
base | 3.6 kB 00:00:00
extras | 3.4 kB 00:00:00
updates | 3.4 kB 00:00:00
(1/4): base/7/x86_64/group_gz | 166 kB 00:00:00
(2/4): extras/7/x86_64/primary_db | 146 kB 00:00:01
(3/4): base/7/x86_64/primary_db | 5.9 MB 00:00:02
(4/4): updates/7/x86_64/primary_db | 2.0 MB 00:00:08
Determining fastest mirrors
* base: ftp.hosteurope.de
* extras: ftp.hosteurope.de
* updates: ftp.hosteurope.de
Resolving Dependencies
--> Running transaction check
Installed:
git.x86_64 0:1.8.3.1-13.el7
Dependency Installed:
libgnome-keyring.x86_64 0:3.12.0-1.el7 perl.x86_64 4:5.16.3-292.el7 perl-Carp.noarch 0:1.26-244.el7 perl-Encode.x86_64 0:2.51-7.el7 perl-Error.noarch 1:0.17020-2.el7
perl-Exporter.noarch 0:5.68-3.el7 perl-File-Path.noarch 0:2.09-2.el7 perl-File-Temp.noarch 0:0.23.01-3.el7 perl-Filter.x86_64 0:1.49-3.el7 perl-Getopt-Long.noarch 0:2.40-3.el7
perl-Git.noarch 0:1.8.3.1-13.el7 perl-HTTP-Tiny.noarch 0:0.033-3.el7 perl-PathTools.x86_64 0:3.40-5.el7 perl-Pod-Escapes.noarch 1:1.04-292.el7 perl-Pod-Perldoc.noarch 0:3.20-4.el7
perl-Pod-Simple.noarch 1:3.28-4.el7 perl-Pod-Usage.noarch 0:1.63-3.el7 perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 perl-Socket.x86_64 0:2.010-4.el7 perl-Storable.x86_64 0:2.45-3.el7
perl-TermReadKey.x86_64 0:2.30-20.el7 perl-Text-ParseWords.noarch 0:3.29-4.el7 perl-Time-HiRes.x86_64 4:1.9725-3.el7 perl-Time-Local.noarch 0:1.2300-2.el7 perl-constant.noarch 0:1.27-2.el7
perl-libs.x86_64 4:5.16.3-292.el7 perl-macros.x86_64 4:5.16.3-292.el7 perl-parent.noarch 1:0.225-244.el7 perl-podlators.noarch 0:2.5.1-3.el7 perl-threads.x86_64 0:1.87-4.el7
perl-threads-shared.x86_64 0:1.43-6.el7 rsync.x86_64 0:3.1.2-4.el7
Complete!
====Prerequisites====
We have to add the "postgres" user:
[postgres@psqlxla postgres-xl]$ useradd postgres
[postgres@psqlxla postgres-xl]$
===Compiler===
Don't forget to install the C compiler as well:
[postgres@psqlxla postgres-xl]$ yum groupinstall "Development tools"
Loaded plugins: fastestmirror
You need to be root to perform this command.
[postgres@psqlxla postgres-xl]$ logout
[root@psqlxla ~]# yum groupinstall "Development tools"
Loaded plugins: fastestmirror
There is no installed groups file.
Maybe run: yum groups mark convert (see man yum)
Loading mirror speeds from cached hostfile
* base: ftp.hosteurope.de
Installed:
autoconf.noarch 0:2.69-11.el7 automake.noarch 0:1.13.4-3.el7 bison.x86_64 0:3.0.4-1.el7 byacc.x86_64 0:1.9.20130304-3.el7 cscope.x86_64 0:15.8-10.el7
ctags.x86_64 0:5.8-13.el7 diffstat.x86_64 0:1.57-4.el7 doxygen.x86_64 1:1.8.5-3.el7 elfutils.x86_64 0:0.170-4.el7 flex.x86_64 0:2.5.37-3.el7
gcc.x86_64 0:4.8.5-28.el7_5.1 gcc-c++.x86_64 0:4.8.5-28.el7_5.1 gcc-gfortran.x86_64 0:4.8.5-28.el7_5.1 indent.x86_64 0:2.2.11-13.el7 intltool.noarch 0:0.50.2-7.el7
libtool.x86_64 0:2.4.2-22.el7_3 patch.x86_64 0:2.7.1-10.el7_5 patchutils.x86_64 0:0.3.3-4.el7 rcs.x86_64 0:5.9.0-5.el7 redhat-rpm-config.noarch 0:9.1.0-80.el7.centos
rpm-build.x86_64 0:4.11.3-32.el7 rpm-sign.x86_64 0:4.11.3-32.el7 subversion.x86_64 0:1.7.14-14.el7 swig.x86_64 0:2.0.10-5.el7 systemtap.x86_64 0:3.2-4.el7
Otherwise you will have the following error, when you try to compile the packages from GIT.
[postgres@psqlxla ~]$ cd postgres-xl/
[postgres@psqlxla postgres-xl]$ ./configure
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking which template to use... linux
checking whether NLS is wanted... no
checking for default port number... 5432
checking for block size... 8kB
checking for segment size... 1GB
checking for WAL block size... 8kB
checking for WAL segment size... 16MB
checking for gcc... no
checking for cc... no
configure: error: in `/home/postgres/postgres-xl':
configure: error: no acceptable C compiler found in $PATH
See `config.log' for more details
Don't forget to install install the following packages:
zlib
zlib-devel
readlink
readline-devel
libtermcap-devel
====Cloning the Repository====
Now we can start to clone the repository, with the postgres user:
[postgres@psqlxla ~]$ git clone git://git.postgresql.org/git/postgres-xl.git
Cloning into 'postgres-xl'...
remote: Counting objects: 555874, done.
remote: Compressing objects: 100% (95291/95291), done.
remote: Total 555874 (delta 470773), reused 542811 (delta 458445)
Receiving objects: 100% (555874/555874), 167.82 MiB | 1.68 MiB/s, done.
Resolving deltas: 100% (470773/470773), done.
[postgres@psqlxla ~]$
====Compilation====
Once all the packages are clone we can compile them:
[postgres@psqlxla postgres-xl]$ ./configure
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking which template to use... linux
checking whether NLS is wanted... no
checking for default port number... 5432
checking for block size... 8kB
checking for segment size... 1GB
checking for WAL block size... 8kB
checking for WAL segment size... 16MB
checking for gcc... gcc
checking whether the C compiler works... yes
configure: using CPPFLAGS= -D_GNU_SOURCE
configure: using LDFLAGS= -Wl,--as-needed
configure: creating ./config.status
config.status: creating GNUmakefile
config.status: creating src/Makefile.global
config.status: creating src/include/pg_config.h
config.status: creating src/include/pg_config_ext.h
config.status: creating src/interfaces/ecpg/include/ecpg_config.h
config.status: linking src/backend/port/tas/dummy.s to src/backend/port/tas.s
config.status: linking src/backend/port/dynloader/linux.c to src/backend/port/dynloader.c
config.status: linking src/backend/port/posix_sema.c to src/backend/port/pg_sema.c
config.status: linking src/backend/port/sysv_shmem.c to src/backend/port/pg_shmem.c
config.status: linking src/backend/port/dynloader/linux.h to src/include/dynloader.h
config.status: linking src/include/port/linux.h to src/include/pg_config_os.h
config.status: linking src/makefiles/Makefile.linux to src/Makefile.port
====Finish====
Compile and install the packages as follows:
===Compile===
[root@psqlxla postgres-xl]# make
PIC -DREFINT_VERBOSE -I. -I. -I../../src/include -D_GNU_SOURCE -c -o refint.o refint.c
gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC -L../../src/port -L../../src/common -Wl,--as-needed -Wl,-rpath,'/usr/local/pgsql/lib',--enable-new-dtags -L../../src/port -lpgport -shared -o refint.so refint.o
gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC -DREFINT_VERBOSE -I. -I. -I../../src/include -D_GNU_SOURCE -c -o timetravel.o timetravel.c
gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC -L../../src/port -L../../src/common -Wl,--as-needed -Wl,-rpath,'/usr/local/pgsql/lib',--enable-new-dtags -L../../src/port -lpgport -shared -o timetravel.so timetravel.o
make[3]: Leaving directory `/home/postgres/postgres-xl/contrib/spi'
gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC -I../../../src/include -D_GNU_SOURCE -I../../../src/port '-DHOST_TUPLE="x86_64-pc-linux-gnu"' '-DSHELLPROG="/bin/sh"' '-DDLSUFFIX=".so"' -c -o pg_regress.o pg_regress.c
gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC -I../../../src/include -D_GNU_SOURCE -c -o pg_regress_main.o pg_regress_main.c
gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC pg_regress.o pg_regress_main.o -L../../../src/port -L../../../src/common -Wl,--as-needed -Wl,-rpath,'/usr/local/pgsql/lib',--enable-new-dtags -lpgcommon -lpgport -lpthread -lz -lreadline -lrt -lcrypt -ldl -lm -o pg_regress
cp ../../../contrib/spi/refint.so refint.so
cp ../../../contrib/spi/autoinc.so autoinc.so
make[2]: Leaving directory `/home/postgres/postgres-xl/src/test/regress'
make -C test/perl all
make[2]: Entering directory `/home/postgres/postgres-xl/src/test/perl'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/home/postgres/postgres-xl/src/test/perl'
make[1]: Leaving directory `/home/postgres/postgres-xl/src'
make -C config all
make[1]: Entering directory `/home/postgres/postgres-xl/config'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/home/postgres/postgres-xl/config'
All of Postgres-XL successfully made. Ready to install.
===Install===
By default PostgreSQL will install on: /usr/local/pgsql/
[root@psqlxla postgres-xl]# make install
make -C src install
make[1]: Entering directory `/home/postgres/postgres-xl/src'
make -C common install
make[2]: Entering directory `/home/postgres/postgres-xl/src/common'
make -C ../backend submake-errcodes
make[3]: Entering directory `/home/postgres/postgres-xl/src/backend'
make[3]: Nothing to be done for `submake-errcodes'.
make[3]: Leaving directory `/home/postgres/postgres-xl/src/backend'
/bin/mkdir -p '/usr/local/pgsql/lib'
/bin/install -c -m 644 libpgcommon.a '/usr/local/pgsql/lib/libpgcommon.a'
make[2]: Leaving directory `/home/postgres/postgres-xl/src/common'
make -C port install
make[2]: Entering directory `/home/postgres/postgres-xl/src/port'
make -C ../backend submake-errcodes
make[3]: Entering directory `/home/postgres/postgres-xl/src/backend'
make[3]: Nothing to be done for `submake-errcodes'.
make[3]: Leaving directory `/home/postgres/postgres-xl/src/backend'
/bin/mkdir -p '/usr/local/pgsql/lib'
/bin/install -c -m 644 libpgport.a '/usr/local/pgsql/lib/libpgport.a'
make[2]: Leaving directory `/home/postgres/postgres-xl/sr
........................................................
make -C config install
make[1]: Entering directory `/home/postgres/postgres-xl/config'
/bin/mkdir -p '/usr/local/pgsql/lib/pgxs/config'
/bin/install -c -m 755 ./install-sh '/usr/local/pgsql/lib/pgxs/config/install-sh'
/bin/install -c -m 755 ./missing '/usr/local/pgsql/lib/pgxs/config/missing'
make[1]: Leaving directory `/home/postgres/postgres-xl/config'
Postgres-XL installation complete.
===Check===
[root@psqlxla postgres-xl]# cd /usr/local/pgsql/
[root@psqlxla pgsql]# ls -lart
total 16
drwxr-xr-x. 13 root root 144 May 26 15:47 ..
drwxr-xr-x. 6 root root 56 May 26 15:47 .
drwxr-xr-x. 6 root root 4096 May 26 15:47 include
drwxr-xr-x. 2 root root 4096 May 26 15:47 bin
drwxr-xr-x. 6 root root 4096 May 26 15:47 share
drwxr-xr-x. 4 root root 4096 May 26 15:47 lib
[root@psqlxla pgsql]#
Repeat this on the rest of the nodes :)
======Database Installation======
In order to start our cluster configuration we should do couple things:
* Compile PGXC_CTL utility
* Disable/edit firewalld
* Edit the SeLinux
* Configure passwordless connection between host1 and the rest
* Initialize the cluster
====Compile pgxc_ctl utility====
This package is located at: "/home/postgres/postgres-xl/contrib/pgxc_ctl"
Firstly, enter there as posgres and compile this as follows:
[postgres@psqlxla pgxc_ctl]$ make
cd ../../contrib/pgxc_ctl && ./make_signature
gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -DFRONTEND -DDLSUFFIX=\".so\" -I. -I../../src/interfaces/libpq -I. -I. -I../../src/include -D_GNU_SOURCE -c -o pgxc_ctl_bash.o pgxc_ctl_bash.c
gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -DFRONTEND -DDLSUFFIX=\".so\" -I. -I../../src/interfaces/libpq -I. -I. -I../../src/include -D_GNU_SOURCE -c -o bash_handler.o bash_handler.c
gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -DFRONTEND -DDLSUFFIX=\".so\" -I. -I../../src/interfaces/libpq -I. -I. -I../../src/include -D_GNU_SOURCE -c -o config.o config.c
gcc -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -DFRONTEND -DDLSUFFIX=\".so\" -I. -I../../src/interfaces/libpq -I. -I. -I../../src/include -D_GNU_SOURCE -c -o pgxc_ctl.o pgxc_ctl.c
pgxc_ctl.c: In function ‘main’:
pgxc_ctl.c:429:8: warning: variable ‘verb
After this, install the package with root as follows:
[root@psqlxla pgxc_ctl]# make install
/bin/mkdir -p '/usr/local/pgsql/bin'
/bin/install -c pgxc_ctl '/usr/local/pgsql/bin'
====Disable/Edit firewall====
To disable/edit the firewall just turn off and disable the "firewalld" demon as follows:
[root@psqlxla pgxc_ctl]# service firewalld stop
[root@psqlxla ~]# chkconfig firewalld off
Note: Forwarding request to 'systemctl disable firewalld.service'.
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@psqlxla ~]# getenforce
Enforcing
[root@psqlxla ~]# setenforce 0
[root@psqlxla ~]# getenforce
Permissive
This will also disable the SeLinux policy to permissive.
**Repeat that for the rest of the nodes**
====Edit SeLinux====
Edit the /etc/selinux/config file as follows:
[root@psqlxlb ~]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=permissive <- This line to Permissive :)
# SELINUXTYPE= can take one of three two values:
# targeted - Targeted processes are protected,
# minimum - Modification of targeted policy. Only selected processes are protected.
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
====Configure passwordless connection====
In order to do that, we have to create RSA public key and ship it to the other nodes. Furthermore, the directory and file permissions should be specific. Otherwise, it won't work if you give them too many permissions as well.
On host1, generate the authentication key file,
ssh-keygen -t rsa (Just press ENTER for all input values)
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
Create directory ".ssh" in the home of every postgres user.
On host1, upload file authorized_keys to host2, host3 and host3, as following,
scp ~/.ssh/authorized_keys postgres@192.168.100.20:~/.ssh/
scp ~/.ssh/authorized_keys postgres@192.168.100.30:~/.ssh/
scp ~/.ssh/authorized_keys postgres@192.168.100.40:~/.ssh/
On every host, run following commands,
chmod 700 ~/.ssh
chmod 600 ~/.ssh/authorized_keys
On host1, try to connect host2, host3 and host4, make sure no password is needed,
ssh postgres@192.168.100.20
ssh postgres@192.168.100.30
ssh postgres@192.168.100.30
====Initialize the cluster====
In order to initialize our cluster we have to execute the pgxc_ctl ONCE on host1 so it will create the: /home/postgres/pgxc_ctl directory. PostgreSQL-XL uses this as default directory for it's configuration files. Create a new file called: "pgxc_ctl.conf" with the following values (according your configuration)
#user and path
pgxcOwner=postgres
pgxcUser=$pgxcOwner
pgxcInstallDir=/usr/local/pgsql
tmpDir=/tmp # temporary dir used in XC servers
localTmpDir=$tmpDir # temporary dir used here locally
#gtm and gtmproxy
gtmMasterDir=$HOME/pgxc/nodes/gtm
gtmMasterPort=6666
gtmMasterServer=192.168.100.10
gtmSlave=n
#gtm proxy
gtmProxy=n
#coordinator
coordMasterDir=$HOME/pgxc/nodes/coord
coordNames=(coord1)
coordPorts=(5432)
poolerPorts=(6668)
coordPgHbaEntries=(192.168.100.0/24)
coordMasterServers=(192.168.100.20)
coordMasterDirs=($coordMasterDir/coord1)
coordMaxWALsernder=0
coordMaxWALSenders=($coordMaxWALsernder)
coordSlave=n
coordSpecificExtraConfig=(none none none)
coordSpecificExtraPgHba=(none none none)
#datanode
datanodeNames=(datanode1 datanode2)
datanodePorts=(15432 15433)
datanodePoolerPorts=(6669 6670)
datanodePgHbaEntries=(192.168.100.0/24)
datanodeMasterServers=(192.168.100.30 192.168.100.40)
datanodeMasterDir=$HOME/pgxc/nodes/dn_master
datanodeMasterDirs=($datanodeMasterDir/datanode1 $datanodeMasterDir/datanode2)
datanodeMaxWalSender=0
datanodeMaxWALSenders=($datanodeMaxWalSender $datanodeMaxWalSender)
datanodeSlave=n
primaryDatanode=datanode1
After all this :) We can start the initialization as follows:
[postgres@psqlxla pgxc_ctl]$ pgxc_ctl init all
/bin/bash
Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash.
Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash.
Reading configuration using /home/postgres/pgxc_ctl/pgxc_ctl_bash --home /home/postgres/pgxc_ctl --configuration /home/postgres/pgxc_ctl/pgxc_ctl.conf
Finished reading configuration.
******** PGXC_CTL START ***************
Current directory: /home/postgres/pgxc_ctl
Initialize GTM master
The files belonging to this GTM system will be owned by user "postgres".
This user must also own the server process.
fixing permissions on existing directory /home/postgres/pgxc/nodes/gtm ... ok
creating configuration files ... ok
creating control file ... ok
Success.
waiting for server to shut down.... done
server stopped
Done.
Start GTM master
server starting
Initialize all the coordinator masters.
Initialize coordinator master coord1.
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /home/postgres/pgxc/nodes/coord/coord1 ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... creating cluster information ... ok
syncing data to disk ... ok
freezing database template0 ... ok
freezing database template1 ... ok
freezing database postgres ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success.
Done.
Starting coordinator master.
Starting coordinator master coord1
2018-05-27 17:44:53.115 EDT [9364] LOG: listening on IPv4 address "0.0.0.0", port 5432
2018-05-27 17:44:53.115 EDT [9364] LOG: listening on IPv6 address "::", port 5432
2018-05-27 17:44:53.120 EDT [9364] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
2018-05-27 17:44:53.134 EDT [9365] LOG: database system was shut down at 2018-05-27 17:44:49 EDT
2018-05-27 17:44:53.137 EDT [9364] LOG: database system is ready to accept connections
2018-05-27 17:44:53.138 EDT [9372] LOG: cluster monitor started
Done.
Initialize all the datanode masters.
Initialize the datanode master datanode1.
Initialize the datanode master datanode2.
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /home/postgres/pgxc/nodes/dn_master/datanode1 ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... creating cluster information ... ok
syncing data to disk ... ok
freezing database template0 ... ok
freezing database template1 ... ok
freezing database postgres ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success.
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /home/postgres/pgxc/nodes/dn_master/datanode2 ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... creating cluster information ... ok
syncing data to disk ... ok
freezing database template0 ... ok
freezing database template1 ... ok
freezing database postgres ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success.
Done.
Starting all the datanode masters.
Starting datanode master datanode1.
Starting datanode master datanode2.
2018-05-27 17:45:08.891 EDT [1851] LOG: listening on IPv4 address "0.0.0.0", port 15432
2018-05-27 17:45:08.891 EDT [1851] LOG: listening on IPv6 address "::", port 15432
2018-05-27 17:45:08.899 EDT [1851] LOG: listening on Unix socket "/tmp/.s.PGSQL.15432"
2018-05-27 17:45:08.909 EDT [1851] LOG: redirecting log output to logging collector process
2018-05-27 17:45:08.909 EDT [1851] HINT: Future log output will appear in directory "pg_log".
2018-05-27 17:45:08.896 EDT [1830] LOG: listening on IPv4 address "0.0.0.0", port 15433
2018-05-27 17:45:08.896 EDT [1830] LOG: listening on IPv6 address "::", port 15433
2018-05-27 17:45:08.902 EDT [1830] LOG: listening on Unix socket "/tmp/.s.PGSQL.15433"
2018-05-27 17:45:08.913 EDT [1830] LOG: redirecting log output to logging collector process
2018-05-27 17:45:08.913 EDT [1830] HINT: Future log output will appear in directory "pg_log".
Done.
ALTER NODE coord1 WITH (HOST='192.168.100.20', PORT=5432);
ALTER NODE
CREATE NODE datanode1 WITH (TYPE='datanode', HOST='192.168.100.30', PORT=15432, PRIMARY);
CREATE NODE
CREATE NODE datanode2 WITH (TYPE='datanode', HOST='192.168.100.40', PORT=15433);
CREATE NODE
SELECT pgxc_pool_reload();
pgxc_pool_reload
------------------
t
(1 row)
Done.
EXECUTE DIRECT ON (datanode1) 'CREATE NODE coord1 WITH (TYPE=''coordinator'', HOST=''192.168.100.20'', PORT=5432)';
EXECUTE DIRECT
EXECUTE DIRECT ON (datanode1) 'ALTER NODE datanode1 WITH (TYPE=''datanode'', HOST=''192.168.100.30'', PORT=15432, PRIMARY)';
EXECUTE DIRECT
EXECUTE DIRECT ON (datanode1) 'CREATE NODE datanode2 WITH (TYPE=''datanode'', HOST=''192.168.100.40'', PORT=15433)';
EXECUTE DIRECT
EXECUTE DIRECT ON (datanode1) 'SELECT pgxc_pool_reload()';
pgxc_pool_reload
------------------
t
(1 row)
EXECUTE DIRECT ON (datanode2) 'CREATE NODE coord1 WITH (TYPE=''coordinator'', HOST=''192.168.100.20'', PORT=5432)';
EXECUTE DIRECT
EXECUTE DIRECT ON (datanode2) 'CREATE NODE datanode1 WITH (TYPE=''datanode'', HOST=''192.168.100.30'', PORT=15432, PRIMARY)';
EXECUTE DIRECT
EXECUTE DIRECT ON (datanode2) 'ALTER NODE datanode2 WITH (TYPE=''datanode'', HOST=''192.168.100.40'', PORT=15433)';
EXECUTE DIRECT
EXECUTE DIRECT ON (datanode2) 'SELECT pgxc_pool_reload()';
pgxc_pool_reload
------------------
t
(1 row)
Done.
Congrats, you have a brand new PostgreSQL-XL cluster