Page 1 of 2

postgres tuning -- crashes

PostPosted: Fri Nov 19, 2010 9:44 pm
by Learning Curved
I recently upgraded from 4gb of ram to 12gb. Windows 7 64bit. postgres 8.4. I have installed the database tuning wizard and followed the prompts. When I use the postgresql config file after the wizard runs with 12gb of ram, PT crashes. Every time. It takes about 5 minutes to load PT, then it just says "cannot connect to the databases" or something like that.

The 4gb config file works fine. PT runs no problem with that file. I still think I can get better performance though and I am not sure what to do. I can send both config files if you need to see them. Thanks for any help.

Re: postgres tuning -- crashes

PostPosted: Fri Nov 19, 2010 9:46 pm
by Learning Curved
fwiw, I have run multiple memory tests and there are no errors with my system.

Re: postgres tuning -- crashes

PostPosted: Sat Nov 20, 2010 5:02 am
by WhiteRider
With the 12 GB setup are you able to connect to your database using PGAdmin III?
Start > Programs > PostgreSQL > PGAdmin III. Double click the database server at the top to open it – the default password is dbpass if it asks for one.

If that works please report your problem – your PokerTracker.log should give us more idea what is going on.

Re: postgres tuning -- crashes

PostPosted: Sat Nov 20, 2010 5:44 pm
by Learning Curved
I could not connect to the databases through PGadmin3 using the 12gb config. I guess thats probably good meaning there is a problem otehr than hardware :)

Could it be something to do with me installing postgres 8.4 using the HM bundled install package? I am currently downloading PT3 on another computer and going to get the default postgresql.cong file and transfer it to my main setup. I will manually change the values using the advanced method and see if taht works.

Re: postgres tuning -- crashes

PostPosted: Sat Nov 20, 2010 10:45 pm
by Learning Curved
no idea what the cause is. It must be something to do with my "default" configs being originally generated by the HM installer and not the PT installer?

I downloaded PT3 on a backup computer, and copied the postgres.conf file from that computer and tried it on my main computer. That file did not work, I assume the reasons were that I used HM to download postgres on main computer and PT3 on backup?

I know you have heard this before, but please fix me :)

Re: postgres tuning -- crashes

PostPosted: Sun Nov 21, 2010 6:27 am
by WhiteRider
Please report your problem and include your PostgreSQL config file too. Kraada should be on later and he may have more ideas too.

Re: postgres tuning -- crashes

PostPosted: Sun Nov 21, 2010 9:50 am
by kraada
Let me know when you've created the ticket with the configuration files so that I can take a look; that will probably be easiest.

Re: postgres tuning -- crashes

PostPosted: Thu Nov 25, 2010 9:46 am
by Learning Curved
For anyone else with this problem, we found the answer is that you must be using 64bit windows and postgres 9.x or higher installed as the 64bit version. All other windows postgres before 9.0 are 32bit and will not handle more than 4gb of ram.

Re: postgres tuning -- crashes

PostPosted: Thu Nov 25, 2010 9:58 am
by WhiteRider
Thanks for following up.

Re: postgres tuning -- crashes

PostPosted: Thu Dec 02, 2010 12:07 am
by zubs1aa
Learning Curved wrote:For anyone else with this problem, we found the answer is that you must be using 64bit windows and postgres 9.x or higher installed as the 64bit version. All other windows postgres before 9.0 are 32bit and will not handle more than 4gb of ram.


Does this mean that i MUST use postgres 9.x now?

I just bought a win 7 64 bit/ 8gb of memory machine.

Was about to post about what the recommended postgres was for this setup and found this post.

so 9x mandatory? or do any of the 8x support this....

highfalutin