Tried to tune PostgreSQL now can't start PT3
Posted: Sun Aug 26, 2012 11:55 am
I have had a slowdown problem when using PT3. I use a netbook with 2GB of RAM. Without PT3 running I can have up to 7 tables running whilst watching YouTube videos or BBC iplayer which I like to have on in the background. CPU usage is at about 75-80%. With PT3 Hud running even two tables increases CPU usage to 95-100% and makes streaming video jumpy and the sound crackly.
I have defragged the hard disk, disabled last access time support and disabled legacy filename support. None of this did any good. The last thing I have tried is the process under Performance Tuning PostgreSQL. I upgraded from 8.3.19 to 8.3.20 and downloaded the Enterprise Tuning Wizard. This didn't quite work as described in the tutorial since everything just happened automatically and there were no manually selectable options to select server utilisation so I don't know if that really worked.
On restarting PT3 I get a popup to Configure PostgreSQL Database. If I click 'Create' I get 'Unable to log in to database (template 1) could not connect to server'. If I tick 'database already exists' and browse I get a similar message. Therefore I can no longer run Poker Tracker at all.
I have turned the computer off and on and I have disabled windows firewall and Avast anti-virus with no success. I have also clicked on the 'start database' option. I assume that the database then starts but don't really know how to tell.
Any help would be very much appreciated.
I have defragged the hard disk, disabled last access time support and disabled legacy filename support. None of this did any good. The last thing I have tried is the process under Performance Tuning PostgreSQL. I upgraded from 8.3.19 to 8.3.20 and downloaded the Enterprise Tuning Wizard. This didn't quite work as described in the tutorial since everything just happened automatically and there were no manually selectable options to select server utilisation so I don't know if that really worked.
On restarting PT3 I get a popup to Configure PostgreSQL Database. If I click 'Create' I get 'Unable to log in to database (template 1) could not connect to server'. If I tick 'database already exists' and browse I get a similar message. Therefore I can no longer run Poker Tracker at all.
I have turned the computer off and on and I have disabled windows firewall and Avast anti-virus with no success. I have also clicked on the 'start database' option. I assume that the database then starts but don't really know how to tell.
Any help would be very much appreciated.