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

postgresql heroku heroku-postgres heroku-cli postgres-10
steel picture steel · Feb 4, 2020 · Viewed 7k times · Source

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?

Answer

Simon Borsky picture Simon Borsky · Oct 13, 2020

I get the error while connecting to Postgres from external application. The fix is relative to language that you use. In Java you need to chain the ?sslmode=require to query string, in NodeJS (my situation) you should add rejectUnauthorized: false as following -

const client = new Client({
  connectionString: process.env.DATABASE_URL,
  ssl: {
    rejectUnauthorized: false
  }
});

Refer to https://devcenter.heroku.com/articles/heroku-postgresql for more details.

Enjoy!

Related questions

Getting "Unknown primary key for table" while the ID is there

I've been debugging this strange problem of Rails giving me "Unknown primary key for table...", even when the table's ID is there. I've copied the database from one heroku app to another, on the original databse there is no problem …

Read More
How can I download db from heroku?

I'm using heroku and I want to download the database from my app(heroku) so I can make some changes in it, I've installed pgbackups, but using heroku pgbackups:url downloads a .dump file How can I download a postgresql …

Read More
How to change DATABASE_URL for a heroku application

I wanted to use an external Database with my heroku application. But I'm unable to edit the configuration cariables. I tried using GUI, Which says, Cannot overwrite attachment values DATABASE_URL. While I tried using CLI as well. I used …

Read More