And how do I restore from my dump back to the db?
+3
A:
You should have a look at pg_restore and pg_dump command.
pg_dump - extract a PostgreSQL database into a script file or other archive file.
pg_restore - restore a PostgreSQL database from an archive file created by pg_dump.
claferri
2009-02-17 16:11:00
Anything wrong with the original "man" pages at http://www.postgresql.org/docs/current/static/reference-client.html ?
Milen A. Radev
2009-02-18 10:35:02