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.
?You can now start the database server of the Postgres-XC coordinator using:
?
? ? postgres --coordinator -D /home/postgres/pgxc/nodes/dn_master/datanode2
or
? ? pg_ctl start -D /home/postgres/pgxc/nodes/dn_master/datanode2 -Z coordinator -l logfile
?
?You can now start the database server of the Postgres-XC datanode using:
?
? ? postgres --datanode -D /home/postgres/pgxc/nodes/dn_master/datanode2
or
? ? pg_ctl start -D /home/postgres/pgxc/nodes/dn_master/datanode2 -Z datanode -l logfile
?
Done.
Starting all the datanode masters.
Starting datanode master datanode1.
Starting datanode master datanode2.
Done.
ALTER NODE coord1 WITH (HOST='192.168.238.130', PORT=5432);
ALTER NODE
CREATE NODE datanode1 WITH (TYPE='datanode', HOST='192.168.238.131', PORT=15432, PRIMARY);
CREATE NODE
CREATE NODE datanode2 WITH (TYPE='datanode', HOST='192.168.238.132', PORT=15432);
CREATE NODE
Done.
4、运行演示
[postgres@localhost ~]$ psql -h 192.168.238.130 -p 5432 -d postgres -U postgres
psql (PGXC 1.3devel, based on PG 9.4beta1)
Type "help" for help.
?
postgres=# create table test(id int, name text) distribute by replication;
CREATE TABLE
postgres=# insert into test values (1,'wang'),(2,'shuo');
INSERT 0 2
postgres=# select * from test;
?id | name
----+------
? 1 | wang
? 2 | shuo
(2 rows)
?
postgres=# \q
[postgres@localhost ~]$ psql -h 192.168.238.131 -p 15432 -d postgres -U postgres
psql (PGXC 1.3devel, based on PG 9.4beta1)
Type "help" for help.
?
postgres=# select * from test;
?id | name
----+------
? 1 | wang
? 2 | shuo
(2 rows)
?
postgres=# \q
[postgres@localhost ~]$ psql -h 192.168.238.132 -p 15432 -d postgres -U postgres
psql (PGXC 1.3devel, based on PG 9.4beta1)
Type "help" for help.
?
postgres=# select * from test;
?id | name
----+------
? 1 | wang
? 2 | shuo
(2 rows)
?
postgres=#
总结：
相较于手动部署，利用pgxc_ctl部署效率以及正确率是非常高的，欢迎大家尝试。
------------------------------------华丽丽的分割线------------------------------------
------------------------------------华丽丽的分割线------------------------------------