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# PGROOT=/global/mnt3/postgres/postresql-8.1.0 phys-schost-1# LD_LIBRARY_PATH=/global/mnt3/postgres/postgresql-8.1.0:/usr/sfw/lib:\ /usr/local/lib:/usr/lib:/opt/csw/lib phys-schost-1# export PGROOT phys-schost-1# export LD_LIBRARY_PATH |
If you are installing the software in the default directory, set PGROOT to /usr/local/pgsql and LD_LIBRARY_PATH to /usr/local/pgsql/lib:/usr/sfw/lib:/usr/local/lib:/usr/lib:/opt/csw/lib.
Copy the PostgreSQL configuration file from the agent directory to its deployment location.
phys-schost-1# cp /opt/SUNWscPostgreSQL/util/pgs_config /global/mnt3 |
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 . . . USER=postgres PGROOT=/usr/local/pgsql #PGROOT=/global/mnt3/postgres/postgresql-8.1.0 PGDATA=/global/mnt3/postgres/data PGPORT=5432 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=/global/mnt3/postgres/postgresql-8.1.0/lib:/usr/sfw/lib #LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib:/usr/lib:/opt/csw/lib |
Save and close the file.