PG :: ConnectionBad(致命:pg_hba.conf拒绝主机"172.17.0.1"，用户"XXX"，数据库"XXX"，SSL关闭的连接): [英] PG::ConnectionBad (FATAL: pg_hba.conf rejects connection for host "172.17.0.1", user "XXX", database "XXX", SSL off ):

问题描述

我正在使用 digitalocean 小滴上的 dockers 在我的项目中使用 postgres:9.4.5 图像.

I am using postgres:9.4.5 image for my project using dockers on digitalocean droplet.

以下是 postgres 的 docker-compose.yml 配置.

db:

  # use the preferred version of the official Postgres image
  # see https://hub.docker.com/_/postgres/
  build: .
  # build with a different Dockerfile
  dockerfile: Dockerfile-pg

  # persist the database between containers by storing it in a volume
  volumes:
    - postgres:/var/lib/postgresql/data
  ports:
    - "5432:5432"
  environment:
    POSTGRES_USER: XXX

在 Dockerfile-pg 内部，我具有以下配置

Inside Dockerfile-pg i have following configurations

FROM postgres:9.4.5

EXPOSE 5432

何时，我 build 并运行图像，出现以下 error

When, I build and run images I get the following error

PG::ConnectionBad (FATAL:  pg_hba.conf rejects connection for host "172.17.0.1", user "XXX", database "XXX", SSL off ):

我已经设置了以下行以允许 postgresql.conf 文件中的所有连接

I already set the following line to allow all connections in postgresql.conf file

listen_addresses = '*'  

在 pg_hba.conf 文件中，我还设置了以下行以允许所有连接

inside pg_hba.conf file I also set up following line to allow for all connections

host all all 0.0.0.0/0 trust

我还在本地系统上以相同的 configuration 设置了 local 环境.在我的本地计算机上一切正常.几天前，在 digitalocean 上的服务器上，一切都工作正常.

I also set the local environment with the same configurations on my local system. Everything is working fine on my local machine. Everything was also working fine on server on digitalocean few days back.

我不知道为什么要尝试使用此IP 172.17.0.1 连接.我已经为 postgres 设置了 HOST_IP ，这是我的 drop ip .

I don't know why it is trying to connect with this IP 172.17.0.1. I have set up HOST_IP for postgres which is my droplet ip.

我不知道为什么会出现此错误.我尝试了所有修复方法.

I don't know why I am getting this error. I tried everything to fix it.

请帮助我！

推荐答案

检查您的 pg_hba.conf 文件.您可能有尚未添加的选项，例如

Check you pg_hba.conf file. You might have options that you haven't added such as

host all pgdbadm 0.0.0.0/0 md5

此pgdbadm以加密采矿黑客创建的帐户而闻名.

This pgdbadm is known for account created by crypto-mining hackers.

这篇关于PG :: ConnectionBad(致命:pg_hba.conf拒绝主机"172.17.0.1"，用户"XXX"，数据库"XXX"，SSL关闭的连接):的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！