Page 1 of 2
error postgresSQL

Posted:
Tue Jun 08, 2010 8:23 am
by mats
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
Re: error postgresSQL

Posted:
Tue Jun 08, 2010 8:53 am
by kraada
Did you upgrade or add a new firewall/antivirus software to your machine lately?
Re: error postgresSQL

Posted:
Tue Jun 08, 2010 1:32 pm
by mats
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
Re: error postgresSQL

Posted:
Tue Jun 08, 2010 3:01 pm
by kraada
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.
Re: error postgresSQL

Posted:
Tue Jun 08, 2010 3:40 pm
by mats
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....
Re: error postgresSQL

Posted:
Tue Jun 08, 2010 5:00 pm
by kraada
It does. What version of Windows are you running?
Re: error postgresSQL

Posted:
Wed Jun 09, 2010 2:01 am
by mats
hallo again,i have windows xp
Re: error postgresSQL

Posted:
Wed Jun 09, 2010 4:06 am
by mats
i found this page
http://www.postgresql.org/docs/8.3/stat ... start.html17.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
Re: error postgresSQL

Posted:
Wed Jun 09, 2010 9:10 am
by kraada
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.
Re: error postgresSQL

Posted:
Wed Jun 09, 2010 9:17 am
by mats
# 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