Home | History | Annotate | Download | only in PostgreSQL
      1 #
      2 # CDDL HEADER START
      3 #
      4 # The contents of this file are subject to the terms of the
      5 # Common Development and Distribution License (the License).
      6 # You may not use this file except in compliance with the License.
      7 #
      8 # You can obtain a copy of the license at usr/src/CDDL.txt
      9 # or http://www.opensolaris.org/os/licensing.
     10 # See the License for the specific language governing permissions
     11 # and limitations under the License.
     12 #
     13 # When distributing Covered Code, include this CDDL HEADER in each
     14 # file and include the License file at usr/src/CDDL.txt.
     15 # If applicable, add the following below this CDDL HEADER, with the
     16 # fields enclosed by brackets [] replaced with your own identifying
     17 # information: Portions Copyright [yyyy] [name of copyright owner]
     18 #
     19 # CDDL HEADER END
     20 #
     21 
     22 #
     23 # Copyright 2008 Sun Microsystems, Inc.  All rights reserved.
     24 # Use is subject to license terms.
     25 #
     26 
     27 # ident   "@(#)pgs_config.ksh 1.6     08/05/06 SMI"
     28 # 
     29 # This file will be sourced in by pgs_register and the parameters
     30 # listed below will be used.
     31 #
     32 # These parameters can be customized in (key=value) form
     33 #
     34 #                RS - name of the resource for the application.
     35 #                RG - name of the resource group containing RS.
     36 #              PORT - name of the port number.
     37 #                LH - name of the LogicalHostname SC resource.
     38 #                     Do not set the LH variable if you plan to have a network 
     39 #		      unaware installation.
     40 #            HAS_RS - Name of the HAStoragePlus SC resource.
     41 #             PFILE - Parameter file which contains the PostgreSQL specific 
     42 #                     parameters, this file will be created by the register script.
     43 #
     44 # The following variables need to be set only if the agent runs in a 
     45 # failover zone
     46 #
     47 #              ZONE - Zonename where the zsmf component should be registered
     48 #           ZONE_BT - Resource name of the zone boot component
     49 #           PROJECT - A project in the zone, that will be used for the PostgreSQL
     50 #                     smf service.
     51 #           PROJECT - A project in the zone, that will be used for the PostgreSQL
     52 #                     smf service. 
     53 #                     If the variable is not set it will be translated as :default for  
     54 #	              the smf credentialss.
     55 #                     Optional
     56 #
     57 
     58 RS=
     59 RG=
     60 PORT=
     61 LH=
     62 HAS_RS=
     63 PFILE=
     64 
     65 # failover zone specific options
     66 
     67 ZONE=
     68 ZONE_BT=
     69 PROJECT=
     70 
     71 # 
     72 # Content for the parameter file
     73 #
     74 #            USER - The Solaris user who owns the PostgreSQL database.
     75 #          PGROOT - Contains the path to the PostgreSQL directory. Below this
     76 #                   directory the postgres binaries are located in the ./bin
     77 #                   directory.
     78 #          PGDATA - Contains the path to the databases of this specific PostgreSQL
     79 #                   instance.
     80 #          PGPORT - Port where the postmaster process will be listening to.
     81 #          PGHOST - Hostname where the postmaster process is listening to, or a directory where the
     82 #                   Unix socket file is stored.
     83 #                   If set to a valid hostname, the PGHOST variable forces the probe to
     84 #                   traverse the TCP/IP stack. If the PGHOST variable is empty or starts with a "/",
     85 #                   the probe will use a socket. If the PGHOST variable starts with a "/", the entry must
     86 #                   be the directory which contains the socket file.
     87 #       PGLOGFILE - Logfile where the log messages of the postmaster will be stored.
     88 # LD_LIBRARY_PATH - This path contains all the necessary libraries for this PostgreSQL
     89 #                   installation.
     90 #                   Optional
     91 #       ENVSCRIPT - Script to contain PostgreSQL specific runtime variables.
     92 #                   Optional
     93 #            SCDB - This database will be monitored.
     94 #          SCUSER - PostgresSQL user to connect to the $SCDB database.
     95 #         SCTABLE - Table name in the $SCDB database. This table name will be manipulated 
     96 #                   to check if PostgreSQL is alive. This table will be generated at database
     97 #                   preparation time.
     98 #          SCPASS - Password of the SCUSER
     99 #                   Optional
    100 #        NOCONRET - Return code for connection errors. This return code has to follow the rules
    101 #                   for the generic data service. The value has to be between 1 and 100.
    102 #                   100/NOCONRET defines the number of consecutive probes to ignore for failed 
    103 #                   connections. A restart or failover will occur, if the number is exeeded within
    104 #                   the retry interval.
    105 
    106 USER=
    107 PGROOT=
    108 PGDATA=
    109 PGPORT=
    110 PGHOST=
    111 PGLOGFILE=
    112 LD_LIBRARY_PATH=
    113 ENVSCRIPT=
    114 SCDB=
    115 SCUSER=
    116 SCTABLE=
    117 SCPASS=
    118 NOCONRET=10
    119 
    120 # The following parameters need to be configured only if logfile shipping is configured to ship
    121 # the PosgreSQL WAL logs between a designated primary and a designated standby resource.
    122 # They need to be configured only on the primary.
    123 
    124 #        STDBY_RS  The resource name of the PostgreSQL standby resource.
    125 #        STDBY_RG  The resource group name of the PostgreSQL standby resource group.
    126 #      STDBY_USER  User which is the owner of the standby postgres database.
    127 #      STDBY_HOST  Resolvable name of the standby host or the standby zone,
    128 #                  this name has to be reachable via ssh.
    129 #   STDBY_PARFILE  The standbys postgres parameter file to get the rest of the necessary parameters.
    130 #   STDBY_PING     The number of of packets the primary uses to ping the standby host. If this variable is
    131 #                  empty, it will be set to 5 packets.
    132 #   ROLECHG_RS     The rolechangers resource name. 
    133 #  SSH_PASSDIR     A directory where the ssh passphrase is stored in a the file <resourcename>-sshpass.
    134 #                  This parameter is needed only if you configured WAL file shipping and secured your
    135 #                  ssh key with a passphrase.
    136 #                  Leave it undefined if the passprase is empty.
    137 #    
    138 # If you configure the logfile shipping in a shared nothing topology, do not set the LH parameter.
    139 #
    140 # Configure the following paramters on the primary host.
    141 
    142 STDBY_RS=
    143 STDBY_RG=
    144 STDBY_USER=
    145 STDBY_HOST=
    146 STDBY_PARFILE=
    147 STDBY_PING=
    148 #
    149 # Configure the following paramters on the standby host.
    150 #
    151 ROLECHG_RS=
    152 #
    153 # Configure the following parameter on both hosts.
    154 #
    155 SSH_PASSDIR=
    156 
    157