To dump:
pg_dump dbname > dbname.sql
To restore:
cat dbname.sql | psql dbname
NOTICE:
You can use gzip to compress the file while doing scp transfer.
Last active
December 9, 2015 23:29
-
-
Save yorzi/4344922 to your computer and use it in GitHub Desktop.
dump / restore postgresql database.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment