PokerTracker

Hello,

when i want to restore one of my PostgreSQL Databases i first got many of this errors
7-Sqlstate=S1000

ERROR:
could not open relation 1663/17253/xxxxx
X= Number
I made some 0 KB files with the name they look for, but after i made like 20 of them i get an other error

7-Sqlstate=S1000

ERROR:
could not open relation 1663/0/xxxxx

I don`t know what to do, because i don`t have a fodler called 0 and if I create one and put the searched file in i get the same error.

If you are getting these errors during the restore process then it means the .backup file is corrupted. I don't know any way to get around this kind of problem. Is this backup from another computer? Are you able to try to do another backup?

Iam sorry i mean while i do Vacuum/Analyze i was a bit confused. So while Compressing

Do you run some kind of utility that scans your harddrive for 0kb files? Because that's the times I have seen this problem and the only way I know how to fix it is to restore from an old backup file. Do you have an old backup file?

I have no backup files and i don`t use such files. I Made a new Database yesterday and now i can`t compress it today. between the time i didn`t use such programs. Or are there any Windowsprogramms or sth like that, deleting such files.

The only time I've seen these files get deleted is when you have some sort of utility program that runs and cleans 0kb files off the hard drive.

Are you able to use the Utilities > Export Hand Histories To File option to export the hands to text files without error?

If so, I would create a new database and use those files to import into it.