Here's another script, one you can put in your crontab:
/usr/local/bin/svc -d /service/ibr
/bin/sleep 60
/usr/local/pgsql/bin/dropdb ibr
/usr/local/pgsql/bin/createdb -E UNICODE ibr
/usr/local/pgsql/bin/psql -f /home/ibr/8000/packages/acs-kernel/sql/postgresql/postgresql.sql ibr
mv /home/ibr/8000/database-backup/ibr-nightly-backup.dmp /home/ibr/8000/database-backup/ibr-nightly-backup-old.dmp
/bin/gunzip /home/ibr/8000/database-backup/ibr-nightly-backup.dmp.gz
/usr/local/pgsql/bin/psql ibr < /home/ibr/8000/database-backup/ibr-nightly-backup.dmp
/usr/local/bin/svc -u /service/ibr
/bin/gzip /home/ibr/8000/database-backup/ibr-nightly-backup-old.dmp
