Postgres-XL 9.5r1.3 Documentation | |||
---|---|---|---|
Prev | Up | Chapter 15. Installation from Source Code | Next |
The following short installation allows to install a simple cluster on a local machine with 1 Coordinator, 2 Datanodes and 1 GTM. When installing a more complex cluster, you might change the number of Coordinators and Datanodes, and might have to start nodes on different servers. Also, you can instead use the pgxc_ctl utility, which simplifies the installation and configuration process.
./configure gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data_coord1 mkdir /usr/local/pgsql/data_datanode_1 mkdir /usr/local/pgsql/data_datanode_2 mkdir /usr/local/pgsql/data_gtm chown postgres /usr/local/pgsql/data_coord1 chown postgres /usr/local/pgsql/data_datanode_1 chown postgres /usr/local/pgsql/data_datanode_2 chown postgres /usr/local/pgsql/data_gtm su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_coord1 \ --nodename coord1 /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_datanode_1 \ --nodename datanode_1 /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_datanode_2 \ --nodename datanode_2 /usr/local/pgsql/bin/initgtm -D /usr/local/pgsql/data_gtm -Z gtm /usr/local/pgsql/bin/gtm -D /usr/local/pgsql/data_gtm >logfile 2>&1 & /usr/local/pgsql/bin/postgres --datanode -p 15432 -c pooler_port=40101 \ -D /usr/local/pgsql/data_datanode_1 >logfile 2>&1 & /usr/local/pgsql/bin/postgres --datanode -p 15433 -c pooler_port=40102 \ -D /usr/local/pgsql/data_datanode_2 >logfile 2>&1 & /usr/local/pgsql/bin/postgres --coordinator -c pooler_port=40100 \ -D /usr/local/pgsql/data_coord1 >logfile 2>&1 & /usr/local/pgsql/bin/psql -c "ALTER NODE coord1 \ WITH (TYPE = 'coordinator', PORT = 5432)" postgres /usr/local/pgsql/bin/psql -c "CREATE NODE datanode_1 \ WITH (TYPE = 'datanode', PORT = 15432)" postgres /usr/local/pgsql/bin/psql -c "CREATE NODE datanode_2 \ WITH (TYPE = 'datanode', PORT = 15433)" postgres /usr/local/pgsql/bin/psql -c "EXECUTE DIRECT ON (datanode_1) \ 'ALTER NODE datanode_1 WITH (TYPE = ''datanode'', PORT = 15432)'" postgres /usr/local/pgsql/bin/psql -c "EXECUTE DIRECT ON (datanode_1) \ 'CREATE NODE datanode_2 WITH (TYPE = ''datanode'', PORT = 15433)'" postgres /usr/local/pgsql/bin/psql -c "EXECUTE DIRECT ON (datanode_1) \ 'CREATE NODE coord1 WITH (TYPE = ''coordinator'', PORT = 5432)'" postgres /usr/local/pgsql/bin/psql -c "EXECUTE DIRECT ON (datanode_2) \ 'ALTER NODE datanode_2 WITH (TYPE = ''datanode'', PORT = 15433)'" postgres /usr/local/pgsql/bin/psql -c "EXECUTE DIRECT ON (datanode_2) \ 'CREATE NODE datanode_1 WITH (TYPE = ''datanode'', PORT = 15432)'" postgres /usr/local/pgsql/bin/psql -c "EXECUTE DIRECT ON (datanode_2) \ 'CREATE NODE coord1 WITH (TYPE = ''coordinator'', PORT = 5432)'" postgres /usr/local/pgsql/bin/psql -c "SELECT pgxc_pool_reload()" postgres /usr/local/pgsql/bin/psql -c "EXECUTE DIRECT ON (datanode_1) \ 'SELECT pgxc_pool_reload()'" postgres /usr/local/pgsql/bin/psql -c "EXECUTE DIRECT ON (datanode_2) \ 'SELECT pgxc_pool_reload()'" postgres /usr/local/pgsql/bin/createdb test /usr/local/pgsql/bin/psql test
The long version is the rest of this chapter.