Postgres Service Starts & Immediately Stops

[mudpi]

I've just re-installed PT3 & postgres 8.3 separately to import my PT2 DBs. I noticed that the service was stopped at each operation. I opened PgAdmin and started service to get that step done and so on. I have my data in PT3 now and fired up Tabletracker and noticed the table stats were not being updated. These stats are current on my table HUD so it appears that I am capturing the HH OK. I searched the forums and found a FAQ on starting postgres on boot up. However, my settings were automatic, yet the computer management screen noted that the service was not running. I started it with the button, but it eventually came back with a msg "The PostgreSQL service started and then stopped. Some stop automatically if not in use." The FAQ showed this service as started so I think mine should be also, especially since I'm datamining right now. It's been 45 minutes and no update. I hit the start search button and do get the current stats.

[mudpi]

I should have added that I'm running Vista Home premium and set the PT3 shortcut to run as Administrator.

[WhiteRider]

Do you see any postgres processes if you go to Task Manager -> Processes?
Table Tracker does not update 'live' - it is search-based, so you get stats of the players that were on the tables when the search was done.
If the auto import is working and the HUD is updating, then postgres must be running.

[mudpi]

Yes, postgres is in task manager. When I switch to services tab though it says it's stopped. I guess it starts and stops immediately. Import seems to be working fine and my HUD is updated. I'm concerned because I saw the faq screenshot with it running while mine is always stopped and the problems I had with converting PT2 files. I can continue to restart the service when I get the Convert error msgs in future so it's not a big issue.

Thanks for the info on Tabletracker. I'll check out the threads on that issue.

[WhiteRider]

That's very strange - maybe one of the postgres experts will shed some light on it for us, but if PT3 is importing, then postgres must be running OK..

[mudpi]

That's very strange - maybe one of the postgres experts will shed some light on it for us, but if PT3 is importing, then postgres must be running OK..

I just switched from tabletracker to the Texas Holdem tab (general tab) and get this msg on the top right pane: "Unable to login to database (PT3 DB). Reason: server closed the connection unexpectedly....

[WhiteRider]

OK, so it sounds like something is stopping your postgres service.
What anti-virus software are you running? Firewall, etc.?

Next time it gets stopped, have a look in the Windows 'Event Viewer' and see if there's anything relevant.
To open Event Viewer, click Start, click Control Panel, double-click Administrative Tools, and then double-click Event Viewer.

One of the systems/postgres experts may be able to offer better diagnostic help about this than I can..

[mudpi]

Thanks for the idea. I found 66 events for Postgres. Here's the latest: 2008-08-10 17:13:07 GMT FATAL: lock file "postmaster.pid" already exists
2008-08-10 17:13:07 GMT HINT: Is another postmaster (PID 2156) running in data directory "C:/Program Files/PostgreSQL/8.3/data"?

[WhiteRider]

OK, that kind-of ties in with the problem that we see sometimes for people trying to start postgres and having to delete that postmaster.pid file, but here it sounds like maybe something else is creating that file..
You don't have anything else that uses postgres on your system, I suppose?

[mudpi]

Yes, I need to use PT2 for Microgaming, but that's all.