Installation scenarios of Postgres 8.4.8

For IA
/usr/bin/cp -f /opt/psb/db/pgsql/share/pg_hba.conf.sample.md5
/var/opt/psb/db/pgsql/pg_hba.conf
/usr/bin/su - sfmdb -c '/opt/psb/db/pgsql/bin/pg_ctl reload -D
/var/opt/psb/db/pgsql' >>/tmp/restore.txt
For PA
/usr/bin/cp -f /opt/sfmdb/pgsql/share/pg_hba.conf.sample.md5
/var/opt/sfmdb/pgsql/pg_hba.conf
/usr/bin/su - sfmdb -c ‘/opt/sfmdb/pgsql/bin/pg_ctl reload -D
/var/opt/sfmdb/pgsql’ >>/tmp/restore.txt
5. Upon the success of the Step 3, the end user is expected to clean the existing data related to
the database from the system. This can be achieved through the following steps
For IA
/sbin/init.d/psbdb stop
For PA
/sbin/init.d/sfmdb stop
rm –rf <DB_DATA_PATH*>/pgsql
NOTE: Performing step 5 will allow user to proceed the installation as fresh installation scenario.
The database backup will now be available in the file db_backup.sql. This database backup file can be
used later (after completing installation) for restoring the database contents.
8