Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@rscardinho

rscardinho/download-db-from-heroku.md

Created March 13, 2019 20:02
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 rscardinho/d3d458a68629afe801b352129332cb28 to your computer and use it in GitHub Desktop.
Save rscardinho/d3d458a68629afe801b352129332cb28 to your computer and use it in GitHub Desktop.
Download ZIP
download-db-from-heroku.md
Raw
download-db-from-heroku.md

heroku pg:backups capture -a event-service-production

curl -o event_service_production.sqlc (heroku pg:backups public-url -a event-service-production)

rake db:drop db:create

WINDOWS (WLS)

pg_restore --verbose --clean --no-acl --no-owner -h 127.0.0.1 -d event_service_development -U postgres event_service_production.sqlc

macOS/LINUX

pg_restore --verbose --clean --no-acl --no-owner -d event_service_development event_service_production.sqlc

@Ultraeto68
Copy link

This is exactly why it is usually a good idea to verify against a number of sources about a certain weight loss tips - most of which is often found to be bogus or ineffective. Refresh Ultra Keto

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