3.4 pgx_pclrsc

Name

pgx_pclrsc -- Register, unregister, or display Symfoware database cluster with PRIMECLUSTER as resource of PRIMECLUSTER.

Synopsis

pgx_pclrsc  -a  -c  name  -u  osuser  -D directory -w directory
            -n nodes [options...]
pgx_pclrsc -d -c name
pgx_pclrsc -p [-c name]

Description

pgx_pclrsc is an utility for registering or unregistering Symfoware database cluster with PRIMECLUSTER, or displaying settings of Symfoware database cluster registered with PRIMECLUSTER. Execute the command on a member node of the cluster. Only the super user(root) can execute this command.

Options

-a --add: Register the specified database cluster with PRIMECLUSTER. If the specified database cluster has already been registered with PRIMECLUSTER, then terminate abnormally.

-c name --db-cluster-name=name: Specify database cluster name. name is case-sensitive, and must be within 16 bytes, and an initial letter must be ascii alphabet, and following letters must be ascii alphabet or ascii digit or underscore(_).

-d --delete: Unregister the specified database cluster from PRIMECLUSTER.

-D directory --pgdata=directory: Specify an absolute path of data directory.

--db-user=name: Specify a database super user. Default is the user specified with '-u'.

-n nodes --member-nodes=nodes: Specify names of all member nodes of the cluster. Specfity a cluster node name with uffix "RMS" to the name. Separate names with comma(,). (e.g. -n node1RMS,node2RMS)

-p --print: Print a list of database clusters registered with PRIMECLUSTER. If -c option is specified, then print settings of the database cluster.

--response-timeout=seconds: Specify timeout of the query for health check. It's used with a count specified with '--timeout-retry-num'. The query is "SELECT 1" to the database "template1". If '0', wait infinitely. (default: '0')

--timeout-retry-count=count: Specify a limit count of retrying query when timeout is occurred. If retry counter is over the limit, then PRIMECLUSTER considers status of the database server as FAULT. If a query doesn't timeout once, retry counter is reset. (default: '6')

--trace-max-file-size=size: Specify max size(KB) of trace file. (default: '10240')

-u osuser --os-user=osuser: Specify an OS user who can start/stop Symfoware database server.

-w directory --work-dir=directory: Specify a directory for temporary data and trace files. It's used for starting, stopping or checking Symfoware database server. If the directory doesn't exist, then create it. Owner of the directory created by the command is set to the user specified with '-u'. Permission of the directory created by the command is set to 0700.

--watch-interval=seconds: Specify an interval. It's used for the amount of time between health checks. (default: '3')

Diagnostics

0 : On success

otherwise : On error

Notes

Before unregistering a resource, stop RMS of PRIMECLUSTER.

Example

The simplest example of registering a resource.

    # pgx_pclrsc -a -c dbcluster1 -u postgres -D /mnt/swdsk1/pgdata -w /var/tmp/work -n node1RMS,node2RMS