Page 1 of 2

Can't Start Postgress

PostPosted: Wed Apr 24, 2013 3:44 pm
by RiverOfJustice
I'm getting this error when starting PT4:
"Unable to login to database (template1). Reason: server closed the connection unexpectedly
This probably means the server terminated abnormally before or while processing the request."

And in the pg_log, I see this:
2013-04-24 15:09:20 EDT LOG: incomplete startup packet
2013-04-24 15:09:21 EDT LOG: could not receive data from client: An operation was attempted on something that is not a socket.

Two things I know for sure- I have no firewall, and my password is correct. Postgres is not started in the services list, and I can't get it to start. What's going on here? FYI, it's postgres 9.0

Re: Can't Start Postgress

PostPosted: Wed Apr 24, 2013 4:57 pm
by kraada
What operating system are you using?

Re: Can't Start Postgress

PostPosted: Wed Apr 24, 2013 5:30 pm
by RiverOfJustice
Windows 8. It worked a few months ago without issue, but now it seems to be having a problem.

Re: Can't Start Postgress

PostPosted: Thu Apr 25, 2013 7:53 am
by kraada
Please try running the Fix It option on this page and let me know if that helps.

Re: Can't Start Postgress

PostPosted: Thu Apr 25, 2013 11:11 am
by RiverOfJustice
Ok I did the fix and then restarted- no change.

Re: Can't Start Postgress

PostPosted: Thu Apr 25, 2013 12:43 pm
by kraada
Open up the Start screen type cmd and right click on it and click Run as Adminstrator.

At the command prompt run these two commands, reboot your machine and let me know if that works better for you:
netsh winsock reset catalog
netsh int ip reset reset.log hit

Re: Can't Start Postgress

PostPosted: Thu Apr 25, 2013 1:52 pm
by RiverOfJustice
Problem solved! Thanks Kraada!!

Re: Can't Start Postgress

PostPosted: Wed Nov 20, 2013 2:00 pm
by Anasuya
Hi Kraada...thank you very much for the solutions,i have been trying to solve this since 3 hours...you made my day..thanks

Re: Can't Start Postgress

PostPosted: Thu Dec 12, 2013 12:48 pm
by AcerRacer
i have an open support ticket, but im still searching for answers while i wait for my turn to come. just noting that i did the suggestions here and it didn't work for me. perhaps i did something wrong.

Re: Can't Start Postgress

PostPosted: Thu Dec 12, 2013 3:53 pm
by kraada
Please let us know that via your ticket. It will be easier if you keep all of your data there so that it's in one place.

highfalutin