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

Created August 25, 2017 12:30

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/leesmith/f378d3593c97d1f236ca685a19d81e35.js"></script>
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