Skip to content

Instantly share code, notes, and snippets.

@hazmatzo

hazmatzo/postgres_command.txt

Created September 19, 2019 18:24
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 hazmatzo/61a4979a114ef7638bea6c087194fd92 to your computer and use it in GitHub Desktop.
Save hazmatzo/61a4979a114ef7638bea6c087194fd92 to your computer and use it in GitHub Desktop.
Download ZIP
Commands for uploading a local downloaded database, because I do that all the time and always forget the parameters
Raw
postgres_command.txt
heroku pg:backups:capture --app some-website-acceptance
heroku pg:backups:download --app some-website-acceptance
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U postgres -d some_website_development latest.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment