Unable to load PT2 DB after PT3/PostgreSQL revamp

[mrpkf]

Hi,

I recently reinstalled PT3 and PostgreSQL v. 8.3. Now I'm not able to use PT2 anymore, I get the following error when I click on PostgreSQL Database Functions:




When I try to open Ring Game Stats, I get another Error twice.
Database transaction information not available.
Call SetTrans or SetTransObject function.

I manually started the PostgreSQL service numerous times and browsed some of the other topics, but couldnt find any solution. Please help me!

[ptrack pat]

Please translate that part of the error that is not in English.

Where you using PostgreSQL with PT2 before you installed PT3? If so, what version of PostgreSQL?

Also, open the Utilities > PostgreSQL Settings window. What is the value you have selected in the "ODBC Entry to Use" field?

[mrpkf]

I used PostgreSQL 8.2 with PT2 before I switched to PT3, which wouldnt work at first, but after reinstalling PostgreSQL (I thought updating might be good, thats why I use 8.3 now) PT3 works.

The ODBC Entry To Use value is set to PostgreSQL Unicode.

The German part of the error says: The name of the data source wasnt found, and no standard driver has been given/selected.
I get this part of the error now when I start PT2, too.

Sorry I wasnt able to reply earlier, I'm short on time currently.

[ptrack pat]

Did you uninstall PostgreSQL 8.2 before you reinstalled 8.3?
What port # did you use to for 8.3?

Go to the Start menu and select Settings > Control Panel > Administrative Tools > Services

Find the PostgreSQL 8.2 entry in the list. Does it say it's started?

[mrpkf]

I uninstalled PostgreSQL 8.2. I use the default port for 8.3 (5432 i believe). The service 8.3 is started by default.

[ptrack pat]

You can't just uninstall the old version of PostgreSQL and then install a new version and expect it to be able to use the same database.

Do you have data in your PT3 database that you want to keep? Because if not you should uninstall PostgreSQL 8.3 and reinstall PostgreSQL 8.2. When you get to the part of the reinstall for 8.2 that has "Initialize database cluster" at the top left corner of the window you should uncheck that box and click the Next button. Then hopefully that will cause it to find and use the old 8.2 data files provided they are still on the computer.

[mrpkf]

What do you mean by data I want to keep? Hands I imported are stored safely, so I could just reimport them I guess? I'm only afraid about Tournament Summaries I manually entered, wouldnt want to enter 200 SNGs manually again...

The 8.2 data folder is still existent btw.

[ptrack pat]

You are going to need to reinstall PostgreSQL 8.2 then without uninstalling 8.3. And since 8.3 is now on port 5432 you will need to install 8.2 using a different port #, 5433 for example.

So you are going to need to go to the c:\program files\postgesql\8.2\data folder and edit the file called postgresql.conf and change the port # there in that file to be 5433 BEFORE you reinstall PostgreSQL 8.2

When you get to the part of the reinstall for 8.2 that has "Initialize database cluster" at the top left corner of the window you should uncheck that box and click the Next button.

[mrpkf]

could you provide me with a download link for a standalone version of postgreSQL 8.2? The last time I installed it it was included with the PT3 beta, and for some reason all the download links I googled are either confusing (like on postgresql.org) or broken :/

[ptrack pat]

http://wwwmaster.postgresql.org/downloa ... .2.6-2.zip