connect to db heroku
heroku pg:psql -f schema.sql -a HEROKU_APP_NAMEconnect to db heroku
heroku pg:psql -f schema.sql -a HEROKU_APP_NAMEcreate heroku add on postgres
heroku addons:create heroku-postgresql:hobby-devhow to find my postgres hostname heorku
heroku pg:credentials:urlheroku cli connect to postgres
$ PGUSER=postgres PGPASSWORD=password heroku pg:pull HEROKU_POSTGRESQL_MAGENTA mylocaldb --app sushilocal pg_sql to heroku pg_sql
# set the password in an environment variable
export PGPASSWORD=mypassword # linux/mac
set PGPASSWORD=mypassword # windows
# create the database dump
$ pg_dump -Fc --no-acl --no-owner -h localhost -U myuser mydb > mydb.dumpCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
