Skip to content

Instantly share code, notes, and snippets.

@tonioriol

tonioriol/heroku_pg_copy.sh

Last active September 22, 2020 09:16
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 tonioriol/c1ed518fa27bf2b940264adaf2494f07 to your computer and use it in GitHub Desktop.
Save tonioriol/c1ed518fa27bf2b940264adaf2494f07 to your computer and use it in GitHub Desktop.
Download ZIP
copy postgres from one app db to another
Raw
heroku_pg_copy.sh
# copy postgres from one app db to another
heroku pg:copy sushi::ORANGE GREEN --app sushi-staging
# This would copy data from the ORANGE database of the sushi app to the GREEN database in sushi-staging. This could be used to copy production data into a staging app for testing purposes.
# source: https://devcenter.heroku.com/articles/heroku-postgres-backups#direct-database-to-database-copies
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment