the SQL Restoration

[wangloveyu]

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]

[kraada]

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

[wangloveyu]

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

[kraada]

Do you have the entire PostgreSQL folder then?

[wangloveyu]

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

[kraada]

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.

[wangloveyu]

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

[kraada]

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.

[wangloveyu]

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.

[tarix]

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.