HELP! Disk crash

[kraada]

You need to get the other installer - download the file at this link, then unzip it and use that installer and it should work for you.

[illerpiller]

Ok, so i managed to install 8.3.19 into my old directory, using your link.
I also managed to connected to the postgreSQL server with pgAdmin III. In there I found my old PT3 database. I right-clicked it and used the backup option.

So now I have file named PT3DB.sql that is huge. I tried to use the "Browse Databases"-button but it only shows my PT4 database. I tried to use the "Restore..."-button too but it doesnt accept the .sql file, I get an error message saying "Invalid Archive".

How do I import the PT3DB.sql file into PT4?

[kraada]

The PT3 backup mechanism expects zipped archives in a particular format - create a test one and then replace the database portion with the file you have and it should restore.

[illerpiller]

The PT3 backup mechanism expects zipped archives in a particular format - create a test one and then replace the database portion with the file you have and it should restore.

I tried this, by creating a new DB in PT4, then clicking Restore on that DB in pgAdmin. It didnt work. Probably because the PT3 database structure doesnt look like the PT4 one. That is probably why the "Browse Database"-button didnt work either.

I did get it to work though after a lot of trial and error.
The advice, I think, you should have given me when I said that pgAdmin detected my database was:
In PT4, go to "Tools"->"Setup Assistant"->"Convert pokerTracker 3 Database". Here PT4 actually detects both the PT3 and PT4 databases (which the "Browse Database"-button doesnt). Then you just mark the PT3 database you want and then select a PT4 database that you want the PT3 hands read into.

This might be something to remember if anyone else asks about a similar issue; even though pgAdmin detects all databases, PT4 databases doesnt seem to accept restores from PT3 files.

Lastly I want to thank you for all your help, especially with finding the .exe file that could install postgreSQL over my old directory. I am so happy I finally got my DB back.
I could not have done it without you.

[kraada]

Sorry I wasn't being clear enough I meant to use the PT3 restore function in PT3, then use the conversion tool you are referring to in Setup Assistant. Do you now have everything working?

[illerpiller]

Yes, I think everything DB-related is working now. I want to uninstall 8.3.19 from my old drive tho and reinstall to my new one. But after this whole ordeal I almost feel like a postgreSQL expert so I dont think there will be any major issues.

[kraada]

I'm glad to hear you got it worked out