PostgreSQL Backups and Migration: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Category:PostgreSQL Category:Web Development == database snapshot == <syntaxhighlight lang="bash"> $ pg_dump -h hostname - d dbname -U username > mysnapshot.sql </syn...") |
(No difference)
|
Revision as of 17:46, 16 February 2016
database snapshot
$ pg_dump -h hostname - d dbname -U username > mysnapshot.sql
The password can be included in the command above, otherwise you'll be prompted for the password.[1]
It's also possible to compress the dump:
$ pg_dump -h hostname - d dbname -U username | gzip > mysnapshot.gz $ gunzip -c mysnapshot.gz | psql dbname
Restoring a dump
$ psql dbname < mysnapshot.sql