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 vote125 views1 answer
Delete last commit from remote repo
Shell/Bash
1 vote141 views1 answer
Set git credentials so that i never ask for username and password while pushin
Shell/Bash
0 vote157 views1 answer
Vs code gith hub credentials aren't keep arch linux
Shell/Bash
0 vote142 views1 answer
Copy file from remote node to local
Shell/Bash
11 votes221 views2 answers
How to copy a file to a remote server using the command line
Shell/Bash
16 votes136 views4 answers
Flutter doctor --android-licenses error
Shell/Bash
1 vote134 views1 answer
Tar to directory
Shell/Bash
1 vote134 views1 answer
Git submodule update authentication
Shell/Bash
5 votes131 views3 answers
Dbeaver linux
Shell/Bash
3 votes108 views2 answers
On branch main your branch is ahead of 'origin/main' by 1 commit. (use "git push" to publish your local commits) nothing to commit, working tree clean
Shell/Bash