test

Sun Cluster Data Service for PostgreSQL Guide for Solaris OS

Creating and Enabling Resources for PostgreSQL

ProcedureHow to Create and Enable Resources for PostgreSQL

Before You Begin

Ensure that you have edited the pgs_config file to specify configuration parameters for the Sun Cluster HA for PostgreSQL data service. For more information, see Specifying Configuration Parameters for the PostgreSQL Resource.

  1. Become superuser on one of the nodes in the cluster that will host PostgreSQL.

  2. Go to the directory that contains the script for creating the Sun Cluster HA for PostgreSQL resource.


    # cd /opt/SUNWscPostgreSQL/util

  3. Run the script that creates the PostgreSQL resource. 


    # ksh ./pgs_register -f /myplace/pgs_config

    If you omit the —f option, the file /opt/SUNWscPostgreSQL/util/pgs_config will be used.

  4. Bring the PostgreSQL resource online. 


    # clresource enable postgres-rs

ProcedureHow to Modify Parameters in the Sun Cluster HA for PostgreSQL Manifest

Perform this task to change parameters in the Sun Cluster HA for PostgreSQL manifest and to validate the parameters in the failover zone. Parameters for the Sun Cluster HA for PostgreSQL manifest are stored as properties of the SMF service. To modify parameters in the manifest, change the related properties in the SMF service then validate the parameter changes.

  1. Become superuser or assume a role that provides solaris.cluster.modify and solaris.cluster.admin RBAC authorizations on the zones console.

  2. Change the Solaris Service Management Facilities (SMF) properties for the Sun Cluster HA for PostgreSQL manifest.


    # svccfg svc:/application/sczone-agents:resource

    For more information, see the svccfg(1M) man page.

  3. Validate the parameter changes.


    # /opt/SUNWscPostgreSQL/bin/control_pgs validate resource

    Messages for this command are stored in the /var/adm/messages/ directory of the failover zone.

  4. Disconnect from the failover zone's console.

ProcedureHow to Remove a Sun Cluster HA for PostgreSQL Resource From a Failover Zone

  1. Become superuser or assume a role that provides solaris.cluster.modify and solaris.cluster.admin RBAC authorizations.

  2. Disable and remove the resource that is used by the Sun Cluster HA for PostgreSQL data service.


    # clresource disable resource
# clresource delete resource

  3. Log in as superuser to the failover zone's console.

  4. Unregister Sun Cluster HA for PostgreSQL from the Solaris Service Management Facilities (SMF) service.


    # /opt/SUNWscPostgreSQL/util/pgs_smf_remove -f filename
    -f

    Specifies the configuration file name.

    filename

    The name of the configuration file that you used to register Sun Cluster HA for PostgreSQL with the SMF service.

    Note –

    If you no longer have the configuration file that you used to register Sun Cluster HA for PostgreSQL with the SMF service, create a replacement configuration file:

    1. Make a copy of the default file, /opt/SUNWscPostgreSQL/util/pgs_config.

    2. Set the ZONE and RS parameters with the values that are used by the data service.

    3. Run the pgs_smf_remove command and use the -f option to specify this configuration file.

  5. Disconnect from the failover zone's console.