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

postgresql server database-connection psql pgadmin
S. Maurer picture S. Maurer · May 5, 2017 · Viewed 13.6k times · Source

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.

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?

Answer

S. Maurer picture S. Maurer · May 15, 2017

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.

Related questions

PostgreSQL Connection Refused

I have installed PostgreSQL. However everytime I try to connect through PGAdmin or through psql it gives me the below error. could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/…

Read More
How do I install/update to Postgres 9.4?

I just installeed Postgres, but it seems to have installed 9.3 and I'd like to start with 9.4 I simply did apt-get install postgresql from a new Ubuntu 14.04.1 machine. http://www.postgresql.org/download/linux/ubuntu/ says you can do: apt-get install …

Read More
/phppgadmin Forbidden You don't have permission to access /phppgadmin/ on this server

I recently upgrade my server from Debian Wheezy to Debian Jessie (Debian 8). A lot of packages was updated and now, I don't have the right to access to phppgadmin from http://myIP/phppgadmin Forbidden You don't have permission to access /…

Read More