PostgreSQL 无法从服务器接收数据:软件导致连接中止 (0x00002745/10053)
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/43802310/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
PostgreSQL could not receive data from server: Software caused connection abort (0x00002745/10053)
提问by S. Maurer
I tried to establish a connection in pgAdmin to the PostgresSQL server. I always get the message:
我试图在 pgAdmin 中建立到 PostgresSQL 服务器的连接。我总是收到消息:
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.
我阅读了几篇帖子,其中人们遇到了同样的问题,但他们没有帮助我。
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.
因为我的版本有点旧,所以我卸载了整个 postgresql 并使用 EnterpriseDB 的安装程序(Windows 64 上的 PostgreSQL 9.6)安装了最新版本。一切看起来都很好。但是我无法再次从 pgAdmin 4 连接到服务器。我收到相同的错误消息。
In the logfile is written: "An existing connection was forcibly closed by the remote host"
Has anybody a clue what the problem could be?
有没有人知道问题可能是什么?
回答by S. Maurer
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.
对我来说,部分解决方案是每次使用 NET STOP 和 NET START 启动我的计算机后重新启动 postgresql 服务器。这很麻烦,但有效。因为我的电脑还有其他连接问题,随后我将系统更新到Windows 10,完全解决了我的所有问题。