Example: Modifying the PostgreSQL Configuration File

1. Modify the PGROOT and PD_LIBRARY_PATH environment variables according to the needs of your build.

   The databases are stored under /global/mnt3/postgres/data.

   The log is stored under /global/mnt3/postgres/logs/sclog.

   phys-schost-1# PG_ROOT=/global/mnt3/postgres/postgresql-8.1.0
   phys-schost-1# LD_LIBRARY_PATH=/global/mnt3/postgres/postgresql-8.1.0/lib \
   phys-schost-1# LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/sfw/lib:/usr/local/lib: \
   /usr/lib:/opt/csw.lib
   phys-schost-1# export LD_LIBRARY_PATH PG_ROOT

2. Store the pfile in a directory in the zone clu1.

   The configuration file name must be available in the zone.

3. Copy the PostgreSQL configuration file from the agent directory to its deployment location.

   phys-schost-1# cp /opt/SUNWscPostgreSQL/util/pgs_config /global/mnt3

4. Add this cluster's information to the configuration file.

   The following listing shows the relevant file entries and the values to assign to each entry.

   …
   RS=RS-PGS
   RG=RG-PGS
   PORT=5432
   LH=hahostix1
   HAS_RS=RS-PGS-HAS
   PFILE=/global/mnt3/postgres/RS-PGS-pfile
   …
   # local zone specific options
   ZONE=clu1
   ZONE_BT=RS-PGS-ZONE
   ZUSER=postgres
   PROJECT=
   …
   USER=postgres
   PGROOT=/usr/local/pgsql
   #PGROOT=/global/mnt3/postgres/postgresql-8.1.0
   PGDATA=/global/mnt3/postgres/data
   PGPORT=5432
   PGHOST=
   PGLOGFILE=/global/mnt3/postgres/logs/sclog
   LD_LIBRARY_PATH=/usr/local/pgsql/lib:/usr/sfw/lib:/usr/local/lib:/usr/lib:/opt/csw/lib
   #LD_LIBRARY_PATH=/usr/sfw/lib:/usr/local/lib:/usr/lib:/opt/csw/lib
   #LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/sfw/lib:/usr/local/lib:/usr/lib:/opt/csw/lib
   ENVSCRIPT=
   SCDB=sctest
   SCUSER=scuser
   SCTABLE=sctable
   SCPASS=

5. Save and close the file.
6. Transfer this configuration file in the zone clu1 under /tmp/pgs_config.

   phys-schost-1# scp /global/mnt3/pgs_config clu1:/tmp