Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?

最新推荐文章于 2025-05-18 11:39:54 发布
原创 最新推荐文章于 2025-05-18 11:39:54 发布 · 1.5w 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#postgresql #connect #server

本文介绍了在遇到'Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?'错误时，如何进行问题分析和解决。问题可能源于PostgreSQL服务关闭，解决方案包括重启服务。此外，还提供了类似问题的两种情况及应对策略。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

问题

could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?

问题分析

PostgreSQL 服务关闭。（检查后发现我的pgadmin 3 缺失 msvcp120.dll，不懂和这有没有关系、未做深入研究。）

解决

重启service中的 PostgreSQL。

以上是我的解决方式，下面附上相似问题的解决方案。

1、

最低0.47元/天 解锁文章

200万优质内容无限畅学
could not connect to server: No route to host Is the server running on host "192.168.163.181" and a
qq_40907977的博客
10-31 1824
服务端日志报错 cat /var/log/zabbix/zabbix_server.log 18854:20191028:221901.747 database is down: reconnecting in 10 seconds 18854:20191028:221914.801 [Z3001] connection to database 'zabbix' failed: [0] cou...
使用pgAdmin连接到Docker中的postgres【报错：Unable to connect to server: connection to server at “localhost”】
qq_34422681的博客
04-09 1784
Unable to connect to server: connection to server at "localhost"(127.0.0.1),port 6700 failed;Connection refused is the server running on that host and accepting TCP/IP connections?connection to server at "localhost"(::1),port 6700 failed;Address not availa
  Is the server running on host "localhost" (::1) and accepting         TCP/IP connections on port 5
微电子学与固体电子学-俞驰
03-11 5248
完整报错如下: django.db.utils.OperationalError: could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on por...
访问数据库：Connection to 192.168.0.226:5432 refused. Check that the hostname and port are correct
最新发布
柳鲲鹏
05-18 376
修改/etc/postgresql/{version}/main/postgresql.conf
Is the server running on host “localhost“ (127.0.0.1) and accepting TCP/IP connections on port 5432?
qq_43417147的博客
12-27 1501
5432服务启动
postgresql数据库无法连接，提示 Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP conn
热门推荐
谷歌是检验真理的唯一标准的博客
10-16 3万+
服务 - 点击PostgreSQL database server 8.3 - 点击第二个选项卡“登录” - 选择第一行“本地系统帐户”。
Is the server running on host "192.168.121.128" and accepting TCP/IP connections on port 5432?
qq_40907977的博客
09-25 1万+
客户端连接报错 ： could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host “192.168.121.128” and accepting TCP/IP connections on port 5432? 修改配制文件 ： vi /usr/local/pgsql...
connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (::1), port 5432 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections?
03-30
好的，用户遇到了PostgreSQL连接被拒绝的问题，具体提示是“psql: could not connect to server: Connection refused”，并询问关于localhost的5432端口TCP/IP连接的解决方案。我需要逐步分析可能的原因并提供对应的...
分析错误原因 psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.15432"? 20230608:14:10:11:001124 gpconfig:b1e989ba992a:gpadmin-[ERROR]:-could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 15432? could not connect to server: Network is unreachable Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 15432? 20230608:14:10:11:001124 gpconfig:b1e989ba992a:gpadmin-[ERROR]:-Failed to connect to database, exiting without action. This script can only be run when the database is up. Failed to connect to database, exiting without action. This script can only be run when the database is up. 20230608:14:10:12:001149 gpconfig:b1e989ba992a:gpadmin-[ERROR]:-could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 15432? could not connect to server: Network is unreachable Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 15432?
06-09
2. "Is the server running locally and accepting connections on Unix domain socket": 服务器是否正在运行，并且是否在Unix域套接字上接受连接。 3. "Connection refused": 连接被拒绝，可能是因为服务器没有...
psql: 错误: 连接到"localhost" (::1)上的服务器，端口5432失败：Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections? 连接到"localhost" (127.0.0.1)上的服务器，端口5432失败：Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections?
03-31
psql "host=localhost port=5432 dbname=postgres user=postgres" # 使用TCP/IP ``` --- #### 六、日志分析 检查PostgreSQL日志文件（默认路径：`/var/log/postgresql/postgresql-<版本>-main.log`），定位具体...
这个报错是为什么？sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "localhost" (::1), port 5432 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections?
07-11
请确保防火墙允许程序通过 TCP/IP 连接到指定的 IP 地址和端口号。 4. 账户权限问题：检查你用于连接到 PostgreSQL 的账户是否具有足够的权限。确保账户具有连接到数据库的权限并执行相关操作。 5. 其他网络问题：...
Postgresql-1-解决报错：connection to localhost:5432 refused that the postmaster is accepting TCP/IP
IOT_LI的专栏
08-30 1万+
今天客户那边服务突然访问不了，数据库报错：Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432? 等提示。 该配置的都配置过，连接个数也不多，从“任务管理”-->“服务”里面看到Postgresql 服务已停止，启动不起来。 最终解决办法：...
报错 - dify - Is the server running on that host and accepting TCP/IP connections?
AI工程化、开源分享、文档翻译、代码笔记
03-18 264
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "localhost" (::1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.
连接Postgresql数据库失败：“Connection timed out (0x0000274C/10060) Is the server running on host [... ]and a
weixin_44214830的博客
05-19 5716
连接Postgresql数据库失败： “Connection timed out (0x0000274C/10060) Is the server running on host “...”and accepting TCP/IP connections on port 5432?” 解决方案 解除安全设备上端口5432 的阻塞，以便通过外部连接进行端口转发。（关闭防火墙） ...
could not connect to server: Connection refused(0x0000274D/10061) .......TCP/IP connections on 5432?
11-01 2万+
服务器是否在主机“192.168.113.154”上运行并且在5432上接受TCP / IP连接？无法连接到服务器：连接被拒绝（0x0000274D / 10061）
PostgreSQL数据库客户端连接时，遇到的几个问题
qq_35377292的博客
11-05 4102
1、连接提示could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "192.168.224.128" and accepting TCP/IP connections on port 5432? 第一步，首先检查防火墙是否开启？若开启，关闭数据库即可。 第二步，若防火墙关闭依然提示报错。修改配置文件pg_hba.conf vi /var/lib/pgsql.
postgresql 连接不上问题
kogila的博客
01-08 1万+
错误信息如下： could not connect to server: Connection refused Is the server running on host host.domain.com and accepting TCP/IP connections on port 5432? 第一步：设置pg_hba.conf $ su - postgres $ vi /usr/loca...
【PostgreSQL】解决“psql: error: could not connect to server: 拒绝连接”
Fanjufei的博客
01-11 1万+
比如：listen_addresses可以修改绑定的地址，默认是localhost，port可以修改监听的端口号，默认是5432，max_connections可以修改最大客户端连接数量，默认是100等等。psql: error: could not connect to server: 拒绝连接。pgsql默认监听的是localhost或127.0.0.1，目前只能本机访问。目录下的postgresql.conf，可以通过修改这个配置文件来调整各个参数。如果远程访问就连接不上了，具体的配置文件是。
pg数据库显示服务器未监听,记PostgreSQL的连接问题
weixin_29137489的博客
08-12 1501
今天打开psql的时候出现这个错误psql: could not connect to server: Connection refused (0x0000274D/10061)Is the server running on host “localhost” (::1) and acceptingTCP/IP connections on port 5432?could not connect ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值