leeeandroo/pg_dump_restore

Created March 15, 2018 11:12

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/leeeandroo/cdc6988616b93f0274a7d7bb1819b741.js"></script>
Save leeeandroo/cdc6988616b93f0274a7d7bb1819b741 to your computer and use it in GitHub Desktop.

Download ZIP

dump & restore psql

Raw

pg_dump_restore

	sudo su - postgres
	pg_dump -Fc mydatabase > /tmp/mydatabase.sql

	sudo su - postgres
	pg_restore --verbose --clean -d mydatabase /tmp/mydatabase.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment