- [postgres@ip-10-21-13-109 pgxc_ctl]$ pgxc_ctl -c pgxc_ctl.conf 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
- ERROR: target directory (/home/postgres/pgxc/nodes/gtm) exists and not empty. Skip GTM initilialization
- 1:3768231680:2017-11-09 19:35:02.983 CST -FATAL: lock file "gtm.pid" already exists
- 2:3768231680:2017-11-09 19:35:02.983 CST -HINT: Is another GTM (PID 14635) running in data directory "/home/postgres/pgxc/nodes/gtm"?
- LOCATION: CreateLockFile, main.c:2099
- waiting for server to shut down... done
- server stopped
- Done.
- Start GTM master
- server starting
- Initialize all the gtm proxies.
- Initializing gtm proxy gtm_pxy1.
- Initializing gtm proxy gtm_pxy2.
- waiting for server to shut down... done
- server stopped
- 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_pxy ... ok
- creating configuration files ... ok
- Success.
- waiting for server to shut down... done
- server stopped
- 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_pxy ... ok
- creating configuration files ... ok
- Success.
- Done.
- Starting all the gtm proxies.
- Starting gtm proxy gtm_pxy1.
- Starting gtm proxy gtm_pxy2.
- server starting
- server starting
- Done.
- Initialize all the coordinator masters.
- Initialize coordinator master coord1.
- ERROR: target coordinator master coord1 is running now. Skip initilialization.
- Done.
- Starting coordinator master.
- Starting coordinator master coord1
- ERROR: target coordinator master coord1 is already running now. Skip initialization.
- 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 ... ok
- creating subdirectories ... ok
- selecting default max_connections ... 100
- selecting default shared_buffers ... 128MB
- selecting dynamic shared memory implementation ... posix
- creating configuration files ... ok
- creating template1 database in /home/postgres/pgxc/nodes/dn_master/base/1 ... ok
- initializing pg_authid ... ok
- initializing dependencies ... ok
- creating system views ... ok
- creating cluster information ... ok
- loading system objects' descriptions ... ok
- creating collations ... ok
- creating conversions ... ok
- creating dictionaries ... ok
- setting privileges on built-in objects ... ok
- creating information schema ... ok
- loading PL/pgSQL server-side language ... ok
- vacuuming database template1 ... ok
- copying template1 to template0 ... ok
- copying template1 to postgres ... 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 ... ok
- creating subdirectories ... ok
- selecting default max_connections ... 100
- selecting default shared_buffers ... 128MB
- selecting dynamic shared memory implementation ... posix
- creating configuration files ... ok
- creating template1 database in /home/postgres/pgxc/nodes/dn_master/base/1 ... ok
- initializing pg_authid ... ok
- initializing dependencies ... ok
- creating system views ... ok
- creating cluster information ... ok
- loading system objects' descriptions ... ok
- creating collations ... ok
- creating conversions ... ok
- creating dictionaries ... ok
- setting privileges on built-in objects ... ok
- creating information schema ... ok
- loading PL/pgSQL server-side language ... ok
- vacuuming database template1 ... ok
- copying template1 to template0 ... ok
- copying template1 to postgres ... 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.
- LOG: redirecting log output to logging collector process
- HINT: Future log output will appear in directory "pg_log".
- LOG: redirecting log output to logging collector process
- HINT: Future log output will appear in directory "pg_log".
- Done.
- ALTER NODE coord1 WITH (HOST='10.21.13.67', PORT=20004);
- ALTER NODE
- CREATE NODE datanode1 WITH (TYPE='datanode', HOST='10.21.13.67', PORT=20008, PRIMARY, PREFERRED);
- ERROR: PGXC Node datanode1: object already defined
- CREATE NODE datanode2 WITH (TYPE='datanode', HOST='10.21.13.60', PORT=20008);
- ERROR: PGXC Node datanode2: object already defined
- SELECT pgxc_pool_reload();
- pgxc_pool_reload
- ------------------
- t
- (1 row)
- Done.
- EXECUTE DIRECT ON (datanode1) 'CREATE NODE coord1 WITH (TYPE=''coordinator'', HOST=''10.21.13.67'', PORT=20004)';
- EXECUTE DIRECT
- EXECUTE DIRECT ON (datanode1) 'ALTER NODE datanode1 WITH (TYPE=''datanode'', HOST=''10.21.13.67'', PORT=20008, PRIMARY, PREFERRED)';
- EXECUTE DIRECT
- EXECUTE DIRECT ON (datanode1) 'CREATE NODE datanode2 WITH (TYPE=''datanode'', HOST=''10.21.13.60'', PORT=20008)';
- 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=''10.21.13.67'', PORT=20004)';
- EXECUTE DIRECT
- EXECUTE DIRECT ON (datanode2) 'CREATE NODE datanode1 WITH (TYPE=''datanode'', HOST=''10.21.13.67'', PORT=20008, PRIMARY, PREFERRED)';
- EXECUTE DIRECT
- EXECUTE DIRECT ON (datanode2) 'ALTER NODE datanode2 WITH (TYPE=''datanode'', HOST=''10.21.13.60'', PORT=20008)';
- EXECUTE DIRECT
- EXECUTE DIRECT ON (datanode2) 'SELECT pgxc_pool_reload()';
- pgxc_pool_reload
- ------------------
- t
- (1 row)
- Done.
来源: http://www.linuxidc.com/Linux/2018-03/151184.htm