Show pageOld revisionsBacklinksODT exportBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ======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: <sxh bash> 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 </sxh> ======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: <sxh bash> [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! </sxh> ====Prerequisites==== We have to add the "postgres" user: <sxh bash> [postgres@psqlxla postgres-xl]$ useradd postgres [postgres@psqlxla postgres-xl]$ </sxh> ===Compiler=== Don't forget to install the C compiler as well: <sxh bash> [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 </sxh> Otherwise you will have the following error, when you try to compile the packages from GIT. <sxh bash> [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 </sxh> Don't forget to install install the following packages: <sxh bash> zlib zlib-devel readlink readline-devel libtermcap-devel </sxh> ====Cloning the Repository==== Now we can start to clone the repository, with the postgres user: <sxh bash> [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 ~]$ </sxh> ====Compilation==== Once all the packages are clone we can compile them: <sxh bash> [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 </sxh> ====Finish==== Compile and install the packages as follows: ===Compile=== <sxh bash> [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. </sxh> ===Install=== By default PostgreSQL will install on: /usr/local/pgsql/ <sxh bash> [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. </sxh> ===Check=== <sxh bash> [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]# </sxh> 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: <sxh bash> [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 </sxh> After this, install the package with root as follows: <sxh bash> [root@psqlxla pgxc_ctl]# make install /bin/mkdir -p '/usr/local/pgsql/bin' /bin/install -c pgxc_ctl '/usr/local/pgsql/bin' </sxh> ====Disable/Edit firewall==== To disable/edit the firewall just turn off and disable the "firewalld" demon as follows: <sxh bash> [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 </sxh> 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: <sxh bash> [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 </sxh> ====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. <sxh bash> 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 </sxh> ====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) <sxh bash> #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 </sxh> After all this :) We can start the initialization as follows: <sxh bash> [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. </sxh> Congrats, you have a brand new PostgreSQL-XL cluster postgresqlxl_installation.txt Last modified: 2021/05/30 08:52by andonovj