Database Error:

[jmillerdls]

Started yesterday, and now happens everytime I open PT (version 2.17.03b).

Unable to connect to the database.

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?



I have no clue what this means or how to resolve it. Any help is appreciated.

[ptrack pat]

It means PostgreSQL isn't running. Restart the computer and try it again.
If it still gives the same error, go to the Start menu and select Settings > Control Panel > Administrative Tools > Services
Find PostgreSQL in the list of services. Does it say it's "Started"? If not, try to start it. Does this give an error?

[jmillerdls]

I went there and it was not started. I started it (no error), and proceeded to open PT. Got the exact same error message.

[ptrack pat]

It must have stopped again then. Go back to the services window, is it still started?

[jmillerdls]

You're right. I checked it and it wasn't started again. I started, closed services, then immediately re-opened services and it wasn't started again. This time it gave me a prompt:

The PostgreSQL Database Server 8.2 service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.

So...umm, how do I get it to stay started?

[ptrack pat]

Go to the c:\program files\postgresql\8.x\data folder (where 8.x is the version # of PostgreSQL you are using, i.e. 8.2 or 8.3). Is there a file called postmaster.pid there? If so, delete it and then restart the computer and try it again.

[jmillerdls]

There isn't...there's a postmaster.opts, but not .pid

[jmillerdls]

Any further advice? I'll check again later tonight and tomorrow if needed.

[ptrack pat]

When did you backup the database last?

[jmillerdls]

Not a good question...I don't back it up. Not the end of the world if I have to start a new database...but It would obviously be preferably not to have to do that.