Introspect failing no pg_hba.conf entry for host
I'm trying to introspect an existing postgres db. It's hosted on heroku and I'm facing
no pg_hba.conf entry for host error. I am able to connect with TablePlus to the same db without issues.
As I'm attempting to also use ?ssl={"rejectUnauthorized":false} to work around this I'm getting Cannot use 'in' operator to search for 'key' in {"rejectUnauthorized":false}. Any hints on how I might get this one connected?5 Replies
Got it working by using
?sslmode=no-verifyThanks! Had the same issue 🙂
Struggling with the same thing, but adding
?sslmode=no-verify hasn't worked yetI had to set
sslmode=require, or ssl: true, everywhere possible, and then it suddenly started working! It appears this is now required by Heroku always.
https://devcenter.heroku.com/articles/connecting-heroku-postgres#heroku-postgres-sslConnecting to Heroku Postgres | Heroku Dev Center
Connect to Redis from different programming languages and frameworks.