PokerTracker

Before I re-install the system, forgot to back up SQL databases, so cause of the current database can not be used. Is there any way to restore the SQL database?



PS: I'm very sorry for my English, it is too bad .[code][/code]

Do you still have your original hand histories? Did you backup the database through PT3?

Do you still have your original hand histories?

A: NO

Did you backup the database through PT3?

A: NO I forgot to backup my database through PT3! but I have the old database files

Do you have the entire PostgreSQL folder then?

Do you have the entire PostgreSQL folder then?

A: yes I have it . I have the folder which name is "data" the size is 13G

Ok in that case, all you should need to do is install PostgreSQL manually and point it to that folder - once you do that when you restart PostgreSQL everything should connect properly.

sorry , I did that like you said to re-install the SQL8.3,but it tell me this "the existing data directory (data/time setting:floating-point numbers)is not compatible with this server(data/time setting:64-bit integers)" what's the matter?

PS：The original database is installed in the XP system, but now I use windows7 32-bit

In that case you need to use the one click installer (same major version though - 8.3) and then it should work with that data directory.

it's still not working. what's the meaning of "one click installer"? if I have the Program which named postgresql-8.4.9-1-windows.exe. and I click this program and install it . is that right ? but I chose the data folder like you said it has a same error.

You actually need the pgInstaller. The One Click Installer from Enterprise DB will not work on your old data.

You can download 3.8.16 from here.