Top
Symfoware Server V12.0.0 Cluster Operation Guide
FUJITSU Software

2.3.7 Creating, Configuring, and Registering a Symfoware Database Cluster

  1. Ensure that the operating system user who is to start Symfoware has been granted write privileges for the path specified in the PGDATA environment variable.

  2. Either login again as the operating system user who is to start Symfoware, or use the su command to login as the operating system user who is to start Symfoware.

    # su - postgres
  3. Create the database cluster manually.

    Note

    If the configuration requires password authentication, create a .pgpass file in the home directory of the operating system user who is to start Symfoware, and then specify a password. This will be used when PRIMECLUSTER checks the operation of the Symfoware database server. If authentication fails, a fault will be assumed to have occurred in the database server.

  4. Check starting, connecting, and stopping. In particular, check that authentication is performed correctly.

  5. Use the pgx_pclrsc command to register the database cluster in PRIMECLUSTER - the following is the simplest execution example:

    # pgx_pclrsc -a -c databaseClusterName -u osUser -D pgData -w workDir -n memberNodes

    Item

    Explanation

    databaseClusterName

    Specify the Symfoware database cluster name.

    The database cluster name is case-sensitive.

    The database cluster name must be as follows:

    • Up to 16 bytes, and

    • The first byte must be an ASCII letter, and

    • The other bytes must be ASCII alphanumeric characters, or underscores (_).

    osUser

    Specify the operating system user who can start the Symfoware database server.

    pgData

    Specify the path of the data 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.

    memberNodes

    Specify the names of all nodes that make up the cluster system.

    Use a comma (,) to separate each node name.

    Specification example:

    -n node1RMS,node2RMS

See

  • Refer to the " Installation and Setup Guide for Server" for information on how to create a database cluster manually.

  • Refer to the "Reference" for information on the pgx_pclrsc command.