Sea the boat of big data operation system, is a commercial operating system, and prepared a lot of software, making it easy for users to quickly establish a large database, with the operating system server and efficient, cheap, based on improved debian9, large database based on improved postgresql - xl,

192.168.1.125 GTM research 20001
All the nodes in a device,
Coordinator1 30001 coordinator2 30002
Pooler_port 30011 pooler_port 30012
Datanode1 40001 datanode2 40002 datanode3 50001
Pooler_port 40011 pooler_port 40012 pooler_port 50011

Zs @ bigdataA: ~ $pgxc_ctl
/bin/bash
Installing pgxc_ctl_bash script as/home/zs/pgxc_ctl pgxc_ctl_bash.
Installing pgxc_ctl_bash script as/home/zs/pgxc_ctl pgxc_ctl_bash.
Reading the configuration using the/home/zs/pgxc_ctl/pgxc_ctl_bash - home/home/zs/pgxc_ctl - configuration/home/zs/pgxc_ctl pgxc_ctl. Conf
Finished reading the configuration.
PGXC_CTL START * * * * * * * * * * * * * * * * * * * * * * *

The Current directory:/home/zs/pgxc_ctl
PGXC prepare config the empty
PGXC exit
Zs @ bigdataA: ~ $CD h - soft
Zs @ bigdataA: ~/h - soft $ls
Apt - get apt - key bashrc_bk deb Java JSP logo. JPG logos pgxc_ctl. Conf - all - in - one pgxc_ctl. Conf - py init PHP sources - the list. The list
Replication configuration example
Zs @ bigdataA: ~/h - soft $cp pgxc_ctl. Conf - all - in - one/home/zs/pgxc_ctl pgxc_ctl. Conf
Set up SSH password free
Zs @ bigdataA: ~/h - soft $SSH - the keygen -t rsa
Generating public/private rsa key pair.
Enter the file in which to save the key (/home/zs/. SSH/id_rsa) :
Created the directory '/home/zs/. SSH.'
The Enter passphrase (empty for no passphrase) :
Enter same passphrase again:
Your identification has had been saved in/home/zs/. SSH/id_rsa.
Your public key has had been saved in/home/zs/. SSH/id_rsa. Pub.
The key fingerprint is:
SHA256: aGBHHqYu3C6aM7ygKemfz4uz4OhrnB4wWvJgN/+ GjSc zs @ bigdataA
The key 's randomart image is:
Plus or minus [RSA 2048] - +
| | +
. |=|
| | + o
|. + o. |
| |=. + oo o S
| + *. Oo. |
|=+ +... + |
E. | XOoo + + |
| % X + + +==. |
Plus or minus - [SHA256] +
-- -- -- -- --Zs @ bigdataA: - soft $cat ~ ~/h/. SSH/id_rsa pub & gt;> ~/. SSH/authorized_keys
Zs @ bigdataA: ~/h - soft $chmod 600 ~/. SSH/authorized_keys
Zs @ bigdataA: ~/h - soft $SCP ~/. SSH/authorized_keys zs @ datanode1: ~/. SSH/
The authenticity of host 'datanode1 (192.168.1.125)' can 't be established.
ECDSA key fingerprint is SHA256: x9G1q0gI34qnEyWmhF/f922w0vzNz7TfTITJohFNdMs.
Are you sure you want to continue connecting (yes/no)? Yes
Warning: Permanently added 'datanode1, 192.168.1.125' (ECDSA) to the list of known hosts.
Authorized_keys 100% 393 207.3 KB/s 00:00
To initialize the database
Zs @ bigdataA: ~/h - soft $pgxc_ctl - c/home/zs/pgxc_ctl pgxc_ctl. Conf init all
/bin/bash
Installing pgxc_ctl_bash script as/home/zs/pgxc_ctl pgxc_ctl_bash.
Installing pgxc_ctl_bash script as/home/zs/pgxc_ctl pgxc_ctl_bash.
Reading the configuration using the/home/zs/pgxc_ctl/pgxc_ctl_bash - home/home/zs/pgxc_ctl - configuration/home/zs/pgxc_ctl pgxc_ctl. Conf
Finished reading the configuration.
PGXC_CTL START * * * * * * * * * * * * * * * * * * * * * * *

The Current directory:/home/zs/pgxc_ctl
The Initialize GTM research master
The authenticity of host 'GTM research (192.168.1.125)' can 't be established.
ECDSA key fingerprint is SHA256: x9G1q0gI34qnEyWmhF/f922w0vzNz7TfTITJohFNdMs.
Are you sure you want to continue connecting (yes/no)? Yes
The files belonging to this GTM research system will be owned by user "zs".
This user must also own the server process.

Fixing permissions on existing directory/home/zs/data/GTM research... Ok
Creating the configuration files... Ok
Creating the control file... Ok

Success.
Done.
Start GTM research master
Server starting
Initialize all the coordinator masters.
Initialize the coordinator master coord1.
Initialize the coordinator master coord2.
The authenticity of host 'datanode2 (192.168.1.125)' can 't be established.
ECDSA key fingerprint is SHA256: x9G1q0gI34qnEyWmhF/f922w0vzNz7TfTITJohFNdMs.
Are you sure you want to continue connecting (yes/no)? Yes
The files belonging to this database system will be owned by user "zs".
This user must also own the server process.

The database cluster will be initialized with The locale en_US. Utf-8.
The default database encoding has accordingly had 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/zs/data/coord_master. 1... Ok
Creating subdirectories... Ok
Selecting the default max_connections... 100
Selecting the default shared_buffers... 128 MB
Selecting the dynamic Shared memory implementation... Posix
Creating the configuration files... Ok
Running the bootstrap script... Ok
Performing a post - the bootstrap initialization... Creating cluster information... Ok
Syncing data to disk... Ok
Freezing the database template0... Ok
Freezing the database template1... Ok
Freezing the database postgres... Ok

WARNING: enabling "trust" authentication for local connections
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull