/Shell/Bash/Heroku upload local database

Heroku upload local database

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 upload 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

8 votes180 views10 answers
Git push
Shell/Bash
1 vote168 views1 answer
Install virtualbox ubuntu 20 wsl command line
Shell/Bash
0 vote199 views1 answer
Inquiring battery power level linux fedora
Shell/Bash
0 vote170 views1 answer
Pip install lightgbm
Shell/Bash
12 votes180 views1 answer
Dos dir
Shell/Bash
13 votes190 views3 answers
List which process is running on specific port ubuntu
Shell/Bash
3 votes189 views1 answer
Pyinstaller icon image
Shell/Bash
5 votes184 views1 answer
Bash adding to array
Shell/Bash
2 votes176 views3 answers
How to open chromium on linux terminal
Shell/Bash
0 vote175 views1 answer
Win terminal turn off screen
Shell/Bash