Last modified 9 years ago Last modified on 10/02/07 14:55:22

Database Backup / Restore Procedure


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 your_backup_file.sql
  • To restore: bash 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