Can't Start Postgress

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Can't Start Postgress

Postby RiverOfJustice » Wed Apr 24, 2013 3:44 pm

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
RiverOfJustice
 
Posts: 36
Joined: Fri Feb 05, 2010 11:07 pm

Re: Can't Start Postgress

Postby kraada » Wed Apr 24, 2013 4:57 pm

What operating system are you using?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Can't Start Postgress

Postby RiverOfJustice » Wed Apr 24, 2013 5:30 pm

Windows 8. It worked a few months ago without issue, but now it seems to be having a problem.
RiverOfJustice
 
Posts: 36
Joined: Fri Feb 05, 2010 11:07 pm

Re: Can't Start Postgress

Postby kraada » Thu Apr 25, 2013 7:53 am

Please try running the Fix It option on this page and let me know if that helps.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Can't Start Postgress

Postby RiverOfJustice » Thu Apr 25, 2013 11:11 am

Ok I did the fix and then restarted- no change.
RiverOfJustice
 
Posts: 36
Joined: Fri Feb 05, 2010 11:07 pm

Re: Can't Start Postgress

Postby kraada » Thu Apr 25, 2013 12:43 pm

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
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Can't Start Postgress

Postby RiverOfJustice » Thu Apr 25, 2013 1:52 pm

Problem solved! Thanks Kraada!!
RiverOfJustice
 
Posts: 36
Joined: Fri Feb 05, 2010 11:07 pm

Re: Can't Start Postgress

Postby Anasuya » Wed Nov 20, 2013 2:00 pm

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

Re: Can't Start Postgress

Postby AcerRacer » Thu Dec 12, 2013 12:48 pm

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.
AcerRacer
 
Posts: 3
Joined: Tue Dec 10, 2013 3:53 pm

Re: Can't Start Postgress

Postby kraada » Thu Dec 12, 2013 3:53 pm

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 6 guests

cron