Learning MySQL / PostgreSQL and other stuff
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment