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 vote285 views1 answer
Grep stack overflow
Shell/Bash
0 vote255 views1 answer
Macos netcat start listening
Shell/Bash
137 votes277 views3 answers
Git create empty branch
Shell/Bash
0 vote240 views2 answers
Reattach screen linux
Shell/Bash
0 vote225 views1 answer
Make a batch file that accepts pipe input
Shell/Bash
0 vote232 views1 answer
How to run a ipynb file in cmd
Shell/Bash
0 vote194 views1 answer
How to install puppet on centos 7
Shell/Bash
0 vote251 views1 answer
Error: cannot find module '/usr/src/app/ng' Docker
Shell/Bash
0 vote267 views1 answer
How to remove go in ubuntu
Shell/Bash
0 vote259 views2 answers
Add sudo user ubuntu 18
Shell/Bash