Installation scenarios of Postgres 8.4.8

For PA
/usr/bin/cp -f /opt/sfmdb/pgsql/share/pg_hba.conf.sample
/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
7. Use the following command to take the database backup:
<DB_PATH*>/pg_dumpall -c -U sfmdb> <DB_DATA_PATH*>/db_backup.sql
8. Move the database back to the authenticated mode and reload the db.
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
9. After taking the database backup and creating the backup file successfully, restore the test-
setup with postgres 7.4.2 binaries to its original state. Therefore, stop the postmaster
using
step 3.
10. Remove the file
<DB_DATA_PATH*>/pgsql and replace the file <DB_DATA_PATH*>/pgsql_orig
as <DB_DATA_PATH*>/pgsql
11. Start the postmaster using
step 5.
12. Reconfigure the product SFM(for PA) and PSB(for IA) to complete the database restoration.
For IA
swconfig -x reconfigure=true -x autoselect_dependencies=false -x
enforce_dependencies=false ProviderSvcsBase
For PA
swconfig -x reconfigure=true -x autoselect_dependencies=false -x
enforce_dependencies=false SysFaultMgmt
5