no pg_hba.conf，只是不工作.我已经找到并尝试了很多次改变它

Question

我没有pg_hba.conf错误与Heroku Postgres。我搜索了所有地方，特别是在这里，并尝试了许多用户的建议。我尝试将pg_hba.conf文件更改为许多用户在这里建议的几乎所有不同的设置，但没有运气。我的数据库正在返回正确的信息，但我仍然不能让我的应用程序工作。

错误是:

2021-03-09T15:58:42.393656+00:00 app[web.1]: error: no pg_hba.conf entry for host "34.203.11.205", user "XXX", database "XXX", SSL off
2021-03-09T15:58:42.393667+00:00 app[web.1]: at Parser.parseErrorMessage (/app/node_modules/pg-protocol/dist/parser.js:278:15)
2021-03-09T15:58:42.393667+00:00 app[web.1]: at Parser.handlePacket (/app/node_modules/pg-protocol/dist/parser.js:126:29)
2021-03-09T15:58:42.393668+00:00 app[web.1]: at Parser.parse (/app/node_modules/pg-protocol/dist/parser.js:39:38)
2021-03-09T15:58:42.393668+00:00 app[web.1]: at Socket.<anonymous> (/app/node_modules/pg-protocol/dist/index.js:10:42)
2021-03-09T15:58:42.393669+00:00 app[web.1]: at Socket.emit (events.js:315:20)
2021-03-09T15:58:42.393670+00:00 app[web.1]: at addChunk (internal/streams/readable.js:309:12)
2021-03-09T15:58:42.393670+00:00 app[web.1]: at readableAddChunk (internal/streams/readable.js:284:9)
2021-03-09T15:58:42.393670+00:00 app[web.1]: at Socket.Readable.push (internal/streams/readable.js:223:10)
2021-03-09T15:58:42.393671+00:00 app[web.1]: at TCP.onStreamRead (internal/stream_base_commons.js:188:23) {
2021-03-09T15:58:42.393672+00:00 app[web.1]: length: 167,
2021-03-09T15:58:42.393673+00:00 app[web.1]: severity: 'FATAL',
2021-03-09T15:58:42.393673+00:00 app[web.1]: code: '28000',
2021-03-09T15:58:42.393673+00:00 app[web.1]: detail: undefined,
2021-03-09T15:58:42.393674+00:00 app[web.1]: hint: undefined,
2021-03-09T15:58:42.393674+00:00 app[web.1]: position: undefined,
2021-03-09T15:58:42.393675+00:00 app[web.1]: internalPosition: undefined,
2021-03-09T15:58:42.393676+00:00 app[web.1]: internalQuery: undefined,
2021-03-09T15:58:42.393676+00:00 app[web.1]: where: undefined,
2021-03-09T15:58:42.393676+00:00 app[web.1]: schema: undefined,
2021-03-09T15:58:42.393676+00:00 app[web.1]: table: undefined,
2021-03-09T15:58:42.393677+00:00 app[web.1]: column: undefined,
2021-03-09T15:58:42.393677+00:00 app[web.1]: dataType: undefined,
2021-03-09T15:58:42.393678+00:00 app[web.1]: constraint: undefined,
2021-03-09T15:58:42.393678+00:00 app[web.1]: file: 'auth.c',
2021-03-09T15:58:42.393678+00:00 app[web.1]: line: '496',
2021-03-09T15:58:42.393679+00:00 app[web.1]: routine: 'ClientAuthentication'
2021-03-09T15:58:42.393679+00:00 app[web.1]: }
2021-03-09T15:58:42.394559+00:00 heroku[router]: at=info method=GET path="/api/questions" host=my-new-quiz.herokuapp.com request_id=065c82c8-8fce-43e8-a877-136e97d3f596 fwd="188.223.116.76" dyno=web.1 connect=0ms service=13ms status=500 bytes=289 protocol=https

我的pg_hba.conf文件是:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
# "local" is for Unix domain socket connections only
local   all             all                                  trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust
Allow replication connections from localhost, by a user with the
replication privilege.
local   replication     all                                     trust
host    replication     all             127.0.0.1/32            trust
host    replication     all             ::1/128                 trust

我添加了:

host all all 192.168.0.0/24 trust/md5 -- no luck
host all all 0.0.0.0/0 trust/md5 --- no luck
host (database info) (user info) (ip address) trust/md5 -- no luck
local all all 0.0.0.0/0 trust/md5 -- no luck

我已经改变了Postgresql.conf文件有#listen_addresses = '*'

我试图将连接字符串更改为ssl: true

有人可以帮助，它在开发模式下工作，只是不是当我上传到heroku。

我的git仓库是:https://github.com/jamesgill11/quiz-server.git

Answer 1

请记住，PostgreSQL不会说谎:p

对于IPv4，只有

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust

表示您只期望本地连接。只需为IP"34.203.11.205"添加作用域

例如:

host    all             all             34.203.11.205/32            md5