Just somewhere to keep my notes while I'm playing.

Thursday, May 8, 2008

Backing up the database

/usr/bin/pg_dump -h localhost -p 5432 -U timj -F c -v -f "/home/timj/db/backup_08_05_2008.backup" cddb

-h = host
-p = port
-U = database user
-F c = Format suitable for pg_restore
-v = verbose
-f = file to back up to

Could just say

pg_dump -U timj -F c -f "/home/timj/db/backup_08_05_2008.backup" cddb

No comments: