Skip to content

Instantly share code, notes, and snippets.

@leesmith

leesmith/postgres-dump-all-and-restore.txt

Created August 25, 2017 12:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save leesmith/f378d3593c97d1f236ca685a19d81e35 to your computer and use it in GitHub Desktop.
Save leesmith/f378d3593c97d1f236ca685a19d81e35 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres dump cluster and restore
Raw
postgres-dump-all-and-restore.txt
$ pg_dumpall > pg_all.sql
$ psql -U lsmith -f pg_all.sql postgres
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment