Use the pgx_pclrsc command to register the database cluster in PRIMECLUSTER - the following is the simplest execution example:
The database cluster does not need to be started when executing the command.
# pgx_pclrsc -a -c databaseClusterName -u OsUser -D pgData -w workDir -n memberNodes
Item | Explanation |
|---|---|
databaseClusterName | Specify the Symfoware Server database cluster name. The database cluster name is case-sensitive. The database cluster name must be as follows:
|
OsUser | Specify the operating system user (an OS user that will become the instance administrator) who can start the Symfoware Server database server. |
pgData | Specify the absolute path of the data storage destination directory specified during database cluster creation. |
workDir | Specify the directory for storing the temporary files required for Symfoware resource monitoring and state transition, and for storing the trace logs required in case of problems. If a directory that does not exist is specified, create the directory. The newly created directory path assumes the OsUser specified with the -u option as the owner, and 0700 as the privilege Required directory size is twice the size that is specified in the --trace-max-file-size option. If the default value is specified in the --trace-max-file-size option, 10240 KB x 2 is required for the directory size. |
memberNodes | Specify the names of all nodes that make up the cluster system. Use a comma (,) to separate each node name. Suffix each cluster node name with the literal "RMS". Specification example: -n node1RMS,node2RMS |
Other than the above, the following options can be specified:
Option | Explanation |
|---|---|
--db-user=name | Specify the Symfoware database superuser. The user specified in the -u option is the default. |
--response-timeout=seconds | In cluster operations, queries are regularly issued to the server to perform error detection and state monitoring. Specify a timeout time for queries issued for the heartbeat monitoring of the Symfoware database server. For queries, "SELECT 1" for the database "template1" is used. If 0 is specified, queries will not time out. The default is 0. |
--timeout-retry-count=count | Specify the upper limit for the number of retries when queries for monitoring time out. The default is 6 times. |
--trace-max-file-size | Specify the maximum size of the trace file. The default is 10240 KB. |
--watch-interval=seconds | Specify the monitoring interval (the interval with which the queries are issued to the server) for a monitoring program to monitor the Symfoware database server. The default is 3 seconds. |
See
Refer to the "Reference" for information on the pgx_pclrsc command.
