Answers for "access heroku postgres database from local"

0

how to find my postgres hostname heorku

heroku pg:credentials:url
Posted by: Guest on August-17-2020
0

local 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.dump
Posted by: Guest on October-22-2021

Code answers related to "access heroku postgres database from local"

Browse Popular Code Answers by Language