Installation scenarios of Postgres 8.4.8

DRD Session- Perform backup on booted system and sync to the clone for IA

Assumption

The booted disk and cloned disk are always kept in sync with respect to data. If they are not in sync, use

‘drd sync’ command.

Steps to be followed

1. Create metafile at /var/opt/psb/db/restore_pid_data

# echo “123” > /var/opt/psb/db/restore_pid_data

# ll /var/opt/psb/db/restore_pid_data

-rw-rw-rw- 1 root sys 4 Oct 27 19:49 /var/opt/psb/db/restore_pid_data

2. As a sfmdb user, take backup of the diagnostic data using ‘sfmDBUtil’ on booted disk and save

it in /var/opt/psb/db/db_backup.sql.123

# su sfmdb

$ /opt/sfm/bin/sfmDBUtil bkup /tmp/db_backup.sql.`cat var/opt/psb/db/restore_pid_data`

postmaster successfully signaled

$ ll /tmp/db_backup.sql.`cat /var/opt/psb/db/restore_pid_data`

-rw-rw-rw- 1 sfmdb users 19674876 Oct 27 19:53 /tmp/db_backup.sql.123

$ exit

# mv /tmp/db_backup.sql.`cat /var/opt/psb/db/restore_pid_data` /var/opt/psb/db/

# ll /var/opt/psb/db/db_backup.sql.123

-rw-rw-rw- 1 sfmdb users 19674876 Oct 27 19:53 db_backup.sql.123

3. Perform DRD sync. Ensure that data backup file and metafile are part of sync

# /opt/drd/bin/drd sync –p

# cat /var/opt/drd/sync/files_to_be_copied_by_drd_sync

…

/var/opt/psb/db

/var/opt/psb/db/db_backup.sql.123

/var/opt/psb/db/restore_pid_data

…

# /opt/drd/bin/drd sync

4. Perform upgrade of diagnostic products and boot the clone disk.