PokerTracker

Hi guys,

I/m encountering lots of troubles since i reinstalled PT and psql. databse is slow, and update cache takes more then 19 hours (i admt i quited when i saw 19 hours and running)

Can it be so that my psq 4.xx - installed by accident- causes all this trouble. I had 3.xx before...

Anyways, what is the best and easiest work around from here ? I am no wizz / expert so playing around in my registery is something i rather avoid.

Complete unistall / install pt and SQL again ?

I cant wait to get this going again :)
Thanks,\
Edwin.

Do you mean PostgreSQL 8.4?

We've found a setting in PostgreSQL 8.4 which should speed up the slow queries.
Please try this:

Edit the postgresql.conf file (Start > Programs > PostgreSQL 8.4 > Configuration Files > postgresql.conf) - if you're using Vista or Win 7 then right click > Run As Administrator in order to be able to save the file.

On Mac the files are in /Library/PostgreSQL/8.4/data (note: not ~/library) and you can edit them with any text editor. If you don't have permission see this page.
Mac Files and Folders

Find "from_collapse_limit" and "join_collapse_limit" and set them both to 12. You must REMOVE the # from the start of the lines, like this:
from_collapse_limit = 12
join_collapse_limit = 12

Save the file and then Start > Programs > PostgreSQL > Reload Configuration (on Mac: Applications > PostgreSQL 8.4 > Restart Server).

That should help performance.

Hi Whiterider,
Indeed it's 8.4.

Thanks for the info, it is however something usefull fo the future. At this vey moment im struggeling with the "error to connect to default database"

I have tried to change the config file pg_hba.conf according to the manual somewhere else on the forum -Unfortunate without result:(

BTW i have PT3 version 3.07.1 beta running on win XP

What to do, next step ?

Best,
Edwin.

Is PostgreSQL currently running? Click Start --> Run, type services.msc and hit enter. Locate the postgres service and attempt to start it - does it start?

Hello Kraada,

followed your instruction, and the status is "blanc" when i do start it an error appears telling me postgres started but stopped, this happens when ...."

Weird msg, never seen before.
What would you suggest ?

Best, Edwin.

Click Start --> Control Panel --> Administrative Tools --> Event Viewer. There should be errors under the Applications section relating to PostgreSQL - please tell me what those errors say.

Hi kraada,

Thanks for the spot on rply.
I've checked event viewer the next errors are displayed:
Failed to query jobs table!
2010-06-24 17:56:00 CESTFATAL: could not create any TCP/IP sockets


And the next warnings are displayed:
2010-06-24 17:56:00 CESTWARNING: could not create listen socket for "*"

Hopefully you can make something out of this, i know i don't :)

Thanks,
Edwin.

What version of Windows are you using?

Im using windows XP Service pack 3

Try running this winsock fix and then rebooting your computer; that may help.