Heroku Postgres: "psql: FATAL: no pg_hba.conf entry for host" | ReadMeFeed

Heroku Postgres: "psql: FATAL: no pg_hba.conf entry for host"

steel

Feb 3

0 views1

There are a number of Heroku CLI Postgres commands that all return the same error. For example:

$ heroku pg:bloat
psql: FATAL:  no pg_hba.conf entry for host "...", user "...", database "...", SSL off

At least one of these commands has worked in the past, but does not now.

The database appears to be working fine otherwise. I can access it via my application's interfaces.

I do not see a way to toggle SSL in the Heroku Postgres dashboard. What could be causing this and how could I fix it?

heroku-postgres postgresql-10

heroku heroku-cli

postgresql

1 answer

Accepted answer · original discussion

steel

Feb 4

Permalink

It turns out that commands like heroku pg:bloat use the local installation of Postgres and psql under the hood. I recompiled my Postgres installation with ssl support (--with-openssl) and everything worked.

Heroku Postgres: "psql: FATAL: no pg_hba.conf entry for host"

1 answer

Your perspective belongs here.

0 question comments