超时已过期pgadmin无法连接到服务器 [英] Timeout expired pgadmin Unable to connect to server

问题描述

我正在按照此链接

我在做什么错，我在macOS上安装了pgadmin，但我不明白为什么会出现此错误.请帮助

What am I doing wrong, I installed pgadmin on my macOS but I don't see why I am getting this error. Please help

推荐答案

在文件pg_hba.conf中，您必须进行以下更改:

In the file pg_hba.conf you have to change:

host    all             all             <your_ip/mask>          ident

收件人:

host    all             all             <your_ip/mask>          md5

<your_ip/mask>是您连接的IP地址. 例如10.1.1.5/32.

<your_ip/mask> is your ip address where you are connecting from. For example 10.1.1.5/32.

如果还不存在，则必须添加一个.

You have to add one if it doesn't exist yet.

我正在使用CentOS，所以文件pg_hba.conf对我来说位于/var/lib/pgsql/data中. 如果您不知道文件在操作系统上的位置，则可以使用搜索来查找文件.

I'm using CentOS so the file pg_hba.conf is located in /var/lib/pgsql/data for me. If you don't know where the file is located on your OS you can use the search to find the file.

这篇关于超时已过期pgadmin无法连接到服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！