Page 1 of 2

error postgresSQL

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

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

Re: error postgresSQL

PostPosted: Wed Jun 09, 2010 2:01 am
by mats
hallo again,i have windows xp

Re: error postgresSQL

PostPosted: Wed Jun 09, 2010 4:06 am
by mats
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

Re: error postgresSQL

PostPosted: 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

PostPosted: 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

highfalutin