PostgreSQL无法从服务器接收数据：软件导致连接中断（0x00002745 / 10053） [英] PostgreSQL could not receive data from server: Software caused connection abort (0x00002745/10053)

问题描述

我试图在pgAdmin中建立到PostgresSQL服务器的连接。
我总是收到以下消息：

I tried to establish a connection in pgAdmin to the PostgresSQL server. I always get the message:

could not receive data from server: Software caused connection abort (0x00002745/10053).

我读了几篇人们遇到相同问题但没有帮助我的帖子。

I read several posts where people had the same problem but they didn't help me.

因为我的版本稍旧，所以我卸载了整个postgresql并使用EnterpriseDB的安装程序（Windows 64上的PostgreSQL 9.6）安装了最新版本。一切看起来都很好。但是我无法再次从pgAdmin 4连接到服务器。我收到相同的错误消息。

Because my version was a bit older I uninstalled the whole postgresql and installed the newest version with the installer of EnterpriseDB (PostgreSQL 9.6 on windows 64). Everything looks fine. But I can't connect to the server from pgAdmin 4 again. I get the same error message.

In the logfile is written: "An existing connection was forcibly closed by the remote host"

有人知道这个问题可能是什么吗？

Has anybody a clue what the problem could be?

推荐答案

对我来说，部分解决方案是在每次使用NET STOP和NET START启动计算机后重新启动postgresql-server。这很麻烦但是有效。
因为我的计算机仍然存在其他连接问题，所以后来我将系统更新为Windows 10，从而完全解决了所有问题。

A partial solution for me was to restart the postgresql-server each time after booting up my computer with NET STOP and NET START. This was cumbersome but worked. Because my computer still had other connection problems, subsequently I updated my system to Windows 10 which totally solved all my problems.

这篇关于PostgreSQL无法从服务器接收数据：软件导致连接中断（0x00002745 / 10053）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！