PostgreSQL was unable to retrieve data from the server: the software caused an aborted connection (0x00002745 / 10053)
I tried to establish a connection in pgAdmin on 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.
Since my version was a little older, I uninstalled all postgresql and installed the newest version with the EnterpriseDB installer (PostgreSQL 9.6 on Windows 64). Everything looks good. But I can't connect to the server again from pgAdmin 4. I get the same error message.
In the logfile is written: "An existing connection was forcibly closed by the remote host"
Does anyone know what the problem might be?
source to share
A common solution for me was to restart the postgresql server every time after booting my computer using NET STOP and NET START. It was cumbersome, but it worked. Since my computer was still having connectivity issues, I subsequently upgraded my system to Windows 10, which completely resolved all my problems.
source to share