airportyh/instructions.md

Created October 21, 2016 18:59

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

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/airportyh/b48590ba816f0f9a0a9f92d0f8dd7f36.js"></script>
Save airportyh/b48590ba816f0f9a0a9f92d0f8dd7f36 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

instructions.md

Dump

$ pg_dump -Fc -d DBNAME -f DBNAME.dump

Replace DBNAME with the name of your database.

Restore

pg_restore -O -d DBNAME -h SERVER_IP -W DBNAME.dump -U postgres

Replace DBNAME with the name of your database and SERVER_IP with the IP address of your server.

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