postgres tuning -- crashes

[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.

[Learning Curved]

fwiw, I have run multiple memory tests and there are no errors with my system.

[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.

[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.

[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

[WhiteRider]

Please report your problem and include your PostgreSQL config file too. Kraada should be on later and he may have more ideas too.

[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.

[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.

[WhiteRider]

Thanks for following up.

[zubs1aa]

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....