Answers for "database on heroku"

1

heroku download database

heroku pg:backups:capture # Save current remote database
heroku pg:backups:download # Download from remote
# load remote on local machine
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U {user} -d {db name} latest.dump
Posted by: Guest on January-05-2022
3

connect to db heroku

heroku pg:psql -f schema.sql -a HEROKU_APP_NAME
Posted by: Guest on July-28-2020
1

heroku download database

$ heroku pg:backups:download
Posted by: Guest on April-21-2020

Browse Popular Code Answers by Language