error postgresSQL

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

error postgresSQL

Postby mats » Tue Jun 08, 2010 8:23 am

worked perfectly for 1 year,today when logged in,got error
"unable to log in to database"
"reason,server closed the connection unexpectedly"
at a loss of what to do. tried to deinstall postgreSQL and reinstall,suceeded,but samt error message
thankful for help
ps, im no computer expert
mats
 
Posts: 9
Joined: Tue Jun 08, 2010 7:57 am

Re: error postgresSQL

Postby kraada » Tue Jun 08, 2010 8:53 am

Did you upgrade or add a new firewall/antivirus software to your machine lately?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: error postgresSQL

Postby mats » Tue Jun 08, 2010 1:32 pm

no,but i have been playing around with my proxysettings lately,but everything,s back to like it was before now.
Can i deinstall pokertracker and reinstall it again,will that fix the problem and will i be able to retain all the info I have there
thank you for your help
mats
 
Posts: 9
Joined: Tue Jun 08, 2010 7:57 am

Re: error postgresSQL

Postby kraada » Tue Jun 08, 2010 3:01 pm

Uninstalling and reinstalling likely won't help. Click Start --> Control Panel --> Administrative Tools -> Event Viewer and see if you see any PostgreSQL related errors in the Application logs there - if you do, please let me know what they say.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: error postgresSQL

Postby mats » Tue Jun 08, 2010 3:40 pm

yes ,plenty error messenges

"warning could not create listen socket for localhost

error cest fatal could not create any TCP/IP sockets

"timed out waiting for server startup"

hope that says more to you,than it says to me....
mats
 
Posts: 9
Joined: Tue Jun 08, 2010 7:57 am

Re: error postgresSQL

Postby kraada » Tue Jun 08, 2010 5:00 pm

It does. What version of Windows are you running?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: error postgresSQL

Postby mats » Wed Jun 09, 2010 2:01 am

hallo again,i have windows xp
mats
 
Posts: 9
Joined: Tue Jun 08, 2010 7:57 am

Re: error postgresSQL

Postby mats » Wed Jun 09, 2010 4:06 am

i found this page http://www.postgresql.org/docs/8.3/stat ... start.html
17.3.1. Server Start-up Failures
FATAL: could not create TCP/IP listen socket

seems it is what I,ve got
heres are my exakt errors

"CEST WARNING could not create listen socket for localhost"
"CEST FATAL could not create any TCP/IP sockets"

However, I dont know how to proceed from here

cheers
mats
mats
 
Posts: 9
Joined: Tue Jun 08, 2010 7:57 am

Re: error postgresSQL

Postby kraada » Wed Jun 09, 2010 9:10 am

Click Start --> Programs --> PostgreSQL 8.3 --> Configuration Files --> Edit pg_hba.conf

Paste everything after the line that begins "# TYPE DATABASE USER "; it's possible it is not set up properly.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: error postgresSQL

Postby mats » Wed Jun 09, 2010 9:17 am

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 trust
mats
 
Posts: 9
Joined: Tue Jun 08, 2010 7:57 am

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 27 guests

cron