Wednesday, May 26, 2010

How to dump postgres database

1. use pg_dump to dump database
pg_dump dbname | gzip > filename.gz

2.   The restore it 
createdb dbname
gunzip -c filename.gz | psql dbname



Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)