Skip Navigation Links
Exit Print View
| Oracle Solaris Cluster Data Service for PostgreSQL Guide Oracle Solaris Cluster 4.1

Search Scope:

- This Document
- Entire Library

## 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

Copyright © 2000, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices |