48 lines
2.0 KiB
Plaintext
48 lines
2.0 KiB
Plaintext
Postgres-XC - pgxc_ddl
|
|
=====================================
|
|
|
|
This directory contains pgxc_ddl, an application used to make a cold synchronization of DDL
|
|
in a Postgres-XC cluster by launching DDL and then copy Coordinator catalog file
|
|
data from a remote Coordinator (where DDL has been launched) to other Coordinators.
|
|
|
|
pgxc_ddl can also be used to synchronize catalog files.
|
|
|
|
pgxc_ddl was put in the default install repository before DDL synchronizing was implemented
|
|
(prior to version Postgres-XC 0.9.3).
|
|
|
|
pgxc_ddl can be used with a configuration file called pgxc.conf.
|
|
This file is kept with the name pgxc.conf.sample to stick with PostgreSQL format.
|
|
Up to v0.9.3, pgxc.conf was by default installed by initdb in a data folder,
|
|
but this is not really necessary since DDL Synchronization is implemented in Postgres-XC.
|
|
|
|
So it is kept in a separate repository src/pgxc/bin/pgxc_ddl/.
|
|
|
|
=====================================
|
|
pgxc_ddl
|
|
=====================================
|
|
This script uses the following options:
|
|
- D to locate the data folder, necessary to find pgxc.conf,
|
|
containing the characteristics of all the coordinators
|
|
- l to locate the folder where applications are
|
|
- f for a DDL file used as input
|
|
- d for a Database name on which to launch DDL
|
|
- n coordinator number where to launch DDL,
|
|
number based on the one written in pgxc.conf
|
|
- t base name of folder where to save configuration files,
|
|
by default /tmp/pgxc_config, completed by $$ (process number for folder name uniqueness)
|
|
|
|
=====================================
|
|
pgxc.conf.sample
|
|
=====================================
|
|
Same format as for GUC files is used.
|
|
|
|
This configuration file contains the list of following parameters:
|
|
- coordinator_hosts, list of Coordinator hosts
|
|
This is an array and format is 'host_name_1,host_name_2'.
|
|
- coordinator_ports, list of Coordinator ports
|
|
This is an array and format is 'port_1,port_2'
|
|
- coordinator_folders
|
|
This is an array and format is 'data_folder_1,data_folder_2'
|
|
|
|
All the arrays need to have the same size equal to the number of Coordinators.
|