Database Backup / Restore Procedure

Automatic

The easiest way to backup / restore is to login as the eureka user via shell. This way, you should not need to enter a password, assuming your PostgreSQL allows local ident-user.

Inside the /sql folder, you will find two bash shell scripts that will do the proper procedure for you:

• To backup: bash backup_database.sh your_backup_file.sql
• To restore: bash restore_database.sh your_backup_file.sql

By hand (instructions not maintained)

To backup the complete database, including BLOBS (binary files) to a file called eureka.bak

pg_dump --blobs --file=eureka.bak --format=c -i -O -o -v --compress=3 -U eureka

To restore the database from the same file

pg_restore -U eureka -d eureka -v eureka.bak