Installation scenarios of Postgres 8.4.8

/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
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
Use the following command to restore the data.
<DB_PATH>/psql –p10864 -Usfmdb -f<DB_DATA_PATH*>/db_backup.sql.<pidswinstall>
postgres 1>/dev/null 2>> /tmp/restore.txt
5. 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
Note: Before Step 5, the end-user must ensure that the database is empty and no data/event is
available at the time of restore operation in the database.
Before clearing the evweb, a reference file consisting of existing data can be created using the
command as below:
evweb eventviewer –Lxf >> /tmp/reference_restore.txt
For clearing/deleting events from the database the following commands can be used.
evweb eventviewer –Df (for clearing evweb)
evweb eventviewer -Df -b history (for clearing evweb_history)
10