Heroku push local database

How to push database to heroku

heroku run rails db:migrate

Heroku push local database

heroku pg:push postgres://<name-host-local-db>/<name-local-db>  <your-remote-postgresql-db-url> --app <your-app-name>

Heroku push local database

# For Postgres / psql
pg_dump --verbose -F c -Z 0 -U postgres -h localhost -p 5432 yourdbname > local.dump # Save local database to file
heroku pg:reset DATABASE # Reset must occur before upload
heroku config:get DATABASE_URL #postgres:// username : password @ hostname : port / databasename
pg_restore --verbose --no-acl --no-owner -U username -h hostname -p 5432 -d databasename < local.dump
# Enter DATABASE_URL password when prompted

Source: stackoverflow.com

Similar codes

0 vote183 views1 answer
Git view entire log
Shell/Bash
93 votes153 views6 answers
How to remove remote origin git
Shell/Bash
5 votes168 views4 answers
How to remove git history for a file
Shell/Bash
-1 vote173 views2 answers
Remove frmo staging git
Shell/Bash
0 vote142 views1 answer
Include nsis plugin in install.nsh
Shell/Bash
0 vote159 views2 answers
Permission denied in /var/log in ubuntu
Shell/Bash
0 vote145 views1 answer
What is echo in a batch file
Shell/Bash
-1 vote113 views2 answers
Docker getting started
Shell/Bash
0 vote147 views1 answer
Tcp traffic analysis linux command line mb per second
Shell/Bash
0 vote175 views1 answer
Rails no migration with version number
Shell/Bash