Big postgresSQL/PT problems

[ThisKidsTough]

After instaling postgresSQL I started to encounter a lot of problems with PT2. Initially I was getting database errors saying that the database was inaccessable. After changing the configuration file to "trust" these errors happened less often, but now when I run auto import pt slows to (usually) a halt and stops responding. When I hit ctrl+alt+del there are a ton of postgres.exe running, along with a ton of svchost.exc. My cpu usage is way up. Please help me get PT2 running on auto import so I can use my HUD in real time at the tables without grinding everything to a halt. Im also getting errors with PAHud due to all of this. Thanks.

[ThisKidsTough]

opening pokertracker i get "unable to connect to the database" 101-SQLSTATE=08001 could not connect to server: connection refused. Is the server runnin on host "localhost" and accepting TCP/IP connections on port 5432?

[ptrack pat]

That error means the PostgeSQL service isn't running, changing your pg_hba.conf file would have nothing to do with fixing/causing this problem.

Go to the Start menu and select Settings > Control Panel > Administrative Tools > Services
Find PostgreSQL Database Service... in the list. Right-click on it and select "Start".
What happens? Does it give an error or does it start?

[ThisKidsTough]

"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 perfomance logs and alerts service."

[ptrack pat]

What kind of firewall/anti-virus software are you using on this computer?

When did you backup this database last?

Go to the c:\program files\postgresql\8.2\data folder. Is there a file called postmaster.pid there? If so, delete it and restart the computer and try it again.

[ThisKidsTough]

cai antivirus (from my university) and windows firewall. i will attempt deleting the folder and restarting now. thanks. brb.

[ThisKidsTough]

Okay. theres no error upon opening pt, but when i started auto import, pt basically stopped responding and my cpu usage is up to 100% (ranging from 35% to 50% other times). The only applications I have running are pt and firefox.

There are also several instances of postgres.exe and svchost.exc running in processes.

[ptrack pat]

Having multiple postgres.exe entries is not abnormal.

Is there anyway you can disable the Firewall/AV to test how it works? It may be the culprit here.

What site are you importing hands from? When you open the auto-import window for this site does it tell you there are a large number of files that need to be processed?

Is the "auto-rate on import" box checked? If so, uncheck it and see if that works any better.

[ThisKidsTough]

Im auto importing from pokerstars with the auto rate player box checked. After unchecking the auto rate player box auto import seems to be running okay and importing hands as I play them.

Unfortunately I clicked the ring game stats icon to bring up the window and auto import stopped running and now pt is not responding.

[ThisKidsTough]

this is with the firewall and av turned off btw. cpu usage is down to the normal 1-8%