Heroku Postgres:"psql:致命:主机没有pg_hba.conf条目" [英] Heroku Postgres: "psql: FATAL: no pg_hba.conf entry for host"

问题描述

有许多Heroku CLI Postgres命令都返回相同的错误.例如:

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.

我在Heroku Postgres仪表板中看不到切换SSL的方法.可能是什么原因造成的，我该如何解决?

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 pg:bloat 这样的命令在以下位置使用Postgres和 psql 的本地安装引擎盖.我使用ssl支持(-with-openssl )重新编译了Postgres安装，一切正常.

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:致命:主机没有pg_hba.conf条目"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！