UNABLE TO CONNECT TO DATABASE?

[noobham]

Hello. I start PT tonight and get this message:

101 - SQLSTATE = 08001
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?


what does this mean? how can i repair it? I get the same exact message with PokerAce HUD, it's a bit unsettling.

Thanks for the help

[ptrack mike]

It doesn't mean you need to repair, it means you can't connect to the PostgreSQL server. Restart your computer and try again.

If it still gives the same error, go to the Start > Settings > Control Panel > Administrative Tools > Services window.
Find PostreSQL 8.x in the list. Does it say it's started? If not, try to start it. Does it give an error when you do this?

[noobham]

OK, did that, PostgreSQL was not started, so I clicked Start Service, and it says:

'The PostgreSQL 8.2 Server started and then stopped. Some services stop automatically if they have no work to do.'

I then tried running PT and still, it would not start. Every time I try to start it, it stops after 1 second...

[ptrack mike]

Does it give an error?

[noobham]

it does not specify an error, no.

[noobham]

and, this is after multiple restarts and trying again.... I'm seeing what happens if I import using an Access database, if there are any problems.

[noobham]

no problems importing using an Access database as of yet

[ptrack pat]

The problem is the PostgreSQL service isn't staying started. What have you been doing to this computer? Have you updated Windows or installed any anti-virus or firewall software?

When was the last time you backed up the db?

Go to the c:\program files\postgresql\8.2\data folder and if there is a file called postmaster.pid there, delete it and restart the computer and then see if you can start the service without error.