Re: Saving time

On the Terminal:

Backup:

1. cd /Library/PostgreSQL/8.4/bin/
2. ./pg_dump -U postgres -Ft -b resolve > /tmp/resolvedb.tar

In the command #2 above, replace "resolve" with the database name, and /tmp/resovledb.tar with the file you want to save it to

3. Compress the backup file

gzip /tmp/resolvedb.tar

To Restore to a new DB:

1. gunzip /tmp/resolvedb.tar.gz
2. ./createdb -U postgres resolve1
3. ./pg_restore -U postgres -d resolve1 /tmp/resolvedb.tar