Can't connect to db - Githubissues

heroku / heroku-pg-extras

A heroku plugin for awesome pg:* commands that are also great and fun and super.

MIT License

1.33k stars 102 forks source link

Can't connect to db #194

Closed kiskoza closed 11 months ago

kiskoza commented 1 year ago

Hi. I'm sure that I'm just missing a simple step, but can't figure out the reason why I got this error message.

heroku --version
# heroku/7.68.3 linux-x64 node-v14.19.0

heroku plugins:inspect heroku-pg-extras
# version: 1.2.4
# tag: latest
# ...

heroku pg:ps --app <my App> -v
# psql: error: FATAL:  no pg_hba.conf entry for host "<my public IP>", user "<REDACTED>", database "<REDACTED>", no encryption
 # ▸    psql exited with code 2

Could you help me find out what's missing?

binarycleric commented 11 months ago

Please reach out to support for connection issues: https://www.heroku.com/support. Issues are only for reporting bugs within heroku-pg-extras itself.