Postgres pgAdmin III访问数据库被拒绝

Postgres pgAdmin III访问数据库被拒绝

问题描述:

尝试连接到我的服务器上的Postgres实例时,我收到以下错误。

I get the following error when attempting to connect to the Postgres instance on my server.

访问数据库被拒绝
服务器不授予访问数据库的权限:服务器报告
FATAL:no pg_hba.conf主机fe80 :: 2d93:af94:879c:4fa%12,用户postgres,数据库postgres,SSL关闭

Access to database denied The server doesn't grant access to the database: the server reports FATAL: no pg_hba.conf entry for host "fe80::2d93:af94:879c:4fa%12", user "postgres", database "postgres", SSL off

I尝试了这里提供的三个明显的解决方案。也就是说,我尝试Syed Aslam解决方案中找到的^链接。

I have tried the three obvious solutions found HERE. Namely I attempted Syed Aslam solution found in that^ link.

我测试,我正在重新启动服务,通过删除一些配置来打破我的本地pgAdmin III连接。我已经检查我的防火墙是否通过暂时关闭它来阻止连接。

I tested that I was restarting the service correctly by removing some config to break my local pgAdmin III connection. I have checked if my firewall was blocking the connection by temporarily turning it off.

任何人都可以帮我找出为什么会收到这个错误?

Can anyone help me figure out why I am getting this error?

Postgres 9.4.1

pgadmin III版本1.20

Windows Server 2012(主机)

Windows 7(尝试从此连接到主机)

Postgres 9.4.1
pgadmin III version 1.20
Windows Server 2012 (host)
Windows 7 (trying to connect from this to the host)

原来我有一个IPv4作为IP地址在我的pg_hba.conf条目。将其更改为如下所示的IPv6版本后:

It turns out that I had an IPv4 as the IP address in my entry for the pg_hba.conf. After changing it to an IPv6 version like this:

IPv4 = 0.0.0.0/0
IPv6 = :: / 0

IPv4 = 0.0.0.0/0 IPv6 = ::/0

这一切都按我预期的工作。来自user_0的评论和此处的文档为我清除它。

It all worked as I would have expected. The comment from user_0 and the documentation found HERE cleared it up for me.

显然,如果你使用IPv6,应该使用IPv4时,答案是相反的。

Obviously the answer works in reverse if you're using an IPv6 when you should be using an IPv4.