Error connecting to the server: server closed the connection unexpectedly
This probably means the server terminated abnormally before or while processing the request.
If you're running Windows, PostgreSQL and you've seen this, it's probably driving you bonkers!
No matter what programming language you use, what interface library or even the default client, you'll get this damn cryptic error!
Thankfully, the solution is simple. Postgre is fine, your setup is not broken.
NOD32
If you've got Nod32 antivirus, then it is known to have some incompatibility issues. Apparently you have to find "postmaster.exe" and add it to the exclusions list.
That can be done via "Setup" > "Advanced Setup Tree" > "Antivirus and Spyware" > "Exclusions" > "Add".
NetLimiter
Otherwise, you'll also have issues if you have NetLimiter.
I'm still rocking the old v1.30 so these instructions will vary with the newer ones.
- Find the "postgres.exe" entry
- Click on the "Info" tab at the bottom
- Click "Ignore all traffic"
This worked like magic for me, so I hope it helps you too!
Now back to practicing things that matter, like walking on air!
PS. SHE IS HOT!
Sources
- Running & Installing PostgreSQL On Native Windows (See "What Anti-Virus software is compatible?")
