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

最新推荐文章于 2025-03-18 19:55:05 发布
原创 最新推荐文章于 2025-03-18 19:55:05 发布 · 1.6w 阅读 · 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服务关闭，解决方案包括重启服务。此外，还提供了类似问题的两种情况及应对策略。

问题

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元/天 解锁文章
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 1861
服务端日志报错 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...
Table Inheritance, Table Partitioning and Copy Table in PostgreSQL
u011868279的博客
04-27 885
Table Inheritance, Table Partitioning and Copy Table in PostgreSQL
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 - 点击第二个选项卡“登录” - 选择第一行“本地系统帐户”。
postgresql在win10环境下用pgAdmin4打开登陆时报错
weixin_42583946的博客
05-05 4781
首先错误是这个 使用navicat连接本地PostgreSQL数据库时报错： could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host"localhost" (:1) and acceptingTCP/IP connections on port 5433 ?...
  Is the server running on host "localhost" (::1) and accepting         TCP/IP connections on port 5
微电子学与固体电子学-俞驰
03-11 5365
完整报错如下: 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...
Is the server running on host “localhost“ (127.0.0.1) and accepting TCP/IP connections on port 5432?
qq_43417147的博客
12-27 1597
5432服务启动
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432? 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?
07-08
当遇到 `Connection refused` 错误，提示信息为“PostgreSQL connection refused error 10061 localhost port 5432”时，这通常表示客户端无法连接到 PostgreSQL 数据库服务器。以下是一些可能的原因和对应的解决...
createdb: 无法联接到数据库 template1: 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? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
05-29
用户的问题涉及TCP/IP连接，因此需要确认postgresql.conf中的listen_addresses是否包含localhost或*，并且端口是否正确设置为5432。然后，查看pg_hba.conf文件，确认客户端认证设置是否正确。如果该文件中没有允许...
Connection refused 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 Is the server running on that host and accepting TCP/IP connections?
最新发布
09-08
用户可能遇到的衍生问题包括：防火墙阻拦（虽然localhost通常不受限）、IPv4/IPv6双栈配置冲突（引用[2][4]都提到::1地址）、其他进程占用5432端口。这些都要在注意事项里覆盖。 最后生成的问题要引导用户深入：...
could not connect to server: Connection refused (0x0000274D/10061) ls the server running on host "localhost" (..1) and accepting TCP/lP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) s the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
06-06
psql --host localhost --username postgres --password --dbname template1 ``` 如果仍然无法连接，请检查防火墙设置，确保5432端口未被阻止。 #### 6. 源码安装时的注意事项 如果从源码安装PostgreSQL，确保编译...
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...
报错 - dify - Is the server running on that host and accepting TCP/IP connections?
AI工程化、开源分享、文档翻译、代码笔记
03-18 479
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-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 服务已停止，启动不起来。 最终解决办法：...
连接Postgresql数据库失败：“Connection timed out (0x0000274C/10060) Is the server running on host [... ]and a
weixin_44214830的博客
05-19 5802
连接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）
could not connect to server:Connection refused (0x0000274D/10061) Is the server running on host“loca
迹
01-28 1万+
could not connect to server:Connection refused (0x0000274D/10061) Is the server running on host"localhost"(::1)and accepting TCP/IP connection on port 5434?.. 打开postgresql输入密码连接不上报错 这种情况大概率是数据库没有启动 启动一下就好了 打开任务管理器-----服务----找到postgresql服务-----右键开始 然后重开p
使用pgAdmin连接到Docker中的postgres【报错：Unable to connect to server: connection to server at “localhost”】
qq_34422681的博客
04-09 1999
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
PostgreSQL数据库客户端连接时，遇到的几个问题
qq_35377292的博客
11-05 4258
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...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值