Page 1 of 1

Unable to connect to database

PostPosted: Thu Jan 21, 2010 4:19 pm
by lickupfool
My pokertracker 3 has recently started to deliver the following message - 'Unable to connect to database'.

In search of a solution I decided to update my postgreSQL and create a new database. This database is now linked to PT3 and PT3 now functions as it should.
Has my original DB been corrupted? If so do you have any advice as to how to avoid this in the future?

I attempted to export the hands from my old DB into my new one but again I get the following message - 'Unable to connect to database: PokerTracker 3 Database'.

I do not understand why PT3 suddenly cannot access my original DB.

Thanks in advance.

Kind regards,

Andrew

Re: Unable to connect to database

PostPosted: Thu Jan 21, 2010 4:57 pm
by kraada
What version of PostgreSQL did you upgrade from and to?

Re: Unable to connect to database

PostPosted: Thu Jan 21, 2010 6:43 pm
by lickupfool
I upgraded from 8.2 to 8.39.

Re: Unable to connect to database

PostPosted: Thu Jan 21, 2010 6:49 pm
by kraada
Do you have a backup of your 8.2.x database before upgrading? The 8.2.x data folder is incompatible with 8.3.x and you need to backup and restore your database to upgrade between those versions.

Re: Unable to connect to database

PostPosted: Thu Jan 21, 2010 8:04 pm
by lickupfool
The reason I downloaded the latest version was because my PT3 was unable to read the old DB anymore - I'm not sure what changed???

As for the back up, I didn't create one before I created the new DB - is it possible to back it up and restore it at this stage?

Thanks for all your help so far.

Re: Unable to connect to database

PostPosted: Fri Jan 22, 2010 5:47 am
by WhiteRider
To back up your old database you will need to re-install postgres 8.2 - different major versions cannot read databases from other major versions (8.x to 8.y).
If you still have your original hand history files in the PokerTracker 3\Processed folder you will probably find it easier to just do a Manual Import of that folder to your new database.

Re: Unable to connect to database

PostPosted: Sat Jan 23, 2010 1:34 am
by lickupfool
Thanks a lot for all your help.

Manually importing my processed folder worked a treat.

Thanks again,
Andrew

:D :D :D :D

Re: Unable to connect to database

PostPosted: Sat Jan 23, 2010 5:36 am
by WhiteRider
You're welcome.