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

no pg_hba.conf entry for host

no pg_hba.conf entry for host

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}

?ssl={"rejectUnauthorized":false}

?ssl={"rejectUnauthorized":false}

?ssl={"rejectUnauthorized":false} to work around this I'm getting

Cannot use 'in' operator to search for 'key' in {"rejectUnauthorized":false}

Cannot use 'in' operator to search for 'key' in {"rejectUnauthorized":false}

Cannot use 'in' operator to search for 'key' in {"rejectUnauthorized":false}

Cannot use 'in' operator to search for 'key' in {"rejectUnauthorized":false}. Any hints on how I might get this one connected?

polkovnikOP•7/27/23, 3:55 PM

Got it working by using ?sslmode=no-verify?sslmode=no-verify

Laurens Lavaert•7/29/23, 8:27 AM

Thanks! Had the same issue

Peter Boling•3/20/24, 6:57 AM

Struggling with the same thing, but adding ?sslmode=no-verify?sslmode=no-verify hasn't worked yet

Peter Boling•3/20/24, 7:31 AM

I had to set sslmode=requiresslmode=require, or ssl: truessl: 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-ssl

Connecting to Heroku Postgres | Heroku Dev Center

Connect to Redis from different programming languages and frameworks.

Peter Boling•3/20/24, 7:35 AM

More: https://devcenter.heroku.com/changelog-items/2035

neural•11/27/24, 3:05 PM

Packages:

pg: ^8.13.1
drizzle: ^0.36.4
Database: PostgreSQLPostgreSQL

Here was almost different, inserting it directly in the URL link doesn't work in any way: false, no-verify, require, true...

The solution was set directly in

drizzle.config.ts

drizzle.config.ts

where you should add most of credentials at

dbCredentials

dbCredentials

to work as expected:

url
host
user
password
database
ssl: "require" // don't tried other ssl configsssl: "require" // don't tried other ssl configs

neural•11/27/24, 3:06 PM

I've come from github issues so I'll post there too!

neural•11/27/24, 3:10 PM

I've come from DiscussionsDiscussions instead of IssuesIssues

neural•11/27/24, 3:16 PM

Introspect failing no pg_hba.conf entry for host

Similar Threads

Similar Threads

Similar Threads