Skip to content

Instantly share code, notes, and snippets.

@leesmith
Created August 25, 2017 12:30
Show Gist options
  • Save leesmith/f378d3593c97d1f236ca685a19d81e35 to your computer and use it in GitHub Desktop.
Save leesmith/f378d3593c97d1f236ca685a19d81e35 to your computer and use it in GitHub Desktop.
Postgres dump cluster and restore
$ 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