Installation scenarios of Postgres 8.4.8

database (7.4.2) will be saved in the .tar format. The installation is expected to continue with the

remaining steps once the NOTE and the user data backup is taken successfully. The location of the

database backup is given below:

<DB_DATA_PATH*>/pgsql.<pidswinstall>.tar

See the

Annexure for the DB_DATA_PATH details.

In order to have the data recovery in place, the database backup should be performed manually by

using the following steps:

1. Port the database backup file (

<DB_DATA_PATH*>/pgsql.<pidswinstall>.tar) on a system

where the postgres 7.4.2 is available.

2. Take the backup of the existing <DB_DATA_PATH*>/pgsql file on the test setup where

postgres binaries are available. For example as

<DB_DATA_PATH*>/pgsql_orig

3. Stop the postmaster on the test setup with the postgres 7.4.2 version. Use the following

command to stop the postmaster.

For IA

/sbin/init.d/psbdb stop

For PA

/sbin/init.d/sfmdb stop

4. Untar the

<DB_DATA_PATH*>/pgsql.<pidswinstall>.tar file.

5. Start the postmaster on the test setup with the postgres 7.4.2 version. Use the following

command to start the postmaster.

For IA

/sbin/init.d/psbdb start

For PA

/sbin/init.d/sfmdb start

6. Move the database into trust mode and reload it by using the following command

For IA

/usr/bin/cp -f /opt/psb/db/pgsql/share/pg_hba.conf.sample

/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