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