Transfer of data

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Re: Transfer of data

Postby WhiteRider » Tue May 17, 2011 3:26 am

Are you sure that old folder is complete? If any files are missing then it won't work.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Transfer of data

Postby Mountain runner » Tue May 17, 2011 3:45 pm

Yes, the folder is just the way it was before reinstalled.
Only thing that might be missing - couple of days before reinstallation I deleted one ~1GB file from folder "G:\PostgresSQL\8.3\data\base\11510" (there are many such files in it). However PT3 worked fine after that.
Could that missing file be a problem now? Isn't it just some hands that I could do without now?
Mountain runner
 
Posts: 15
Joined: Tue Dec 29, 2009 8:36 pm

Re: Transfer of data

Postby kraada » Tue May 17, 2011 3:57 pm

That file is 1G worth of data from your database. Without the rest of the files it's impossible to know what data that is - it could be just about anything. With files like that missing, it is extremely unlikely that the database will start up again as it would fail all integrity checks.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Transfer of data

Postby Mountain runner » Tue May 17, 2011 4:00 pm

Isn't it just a bunch of hands that I deleted?
So I understabd, that this old 30GB database now became useless without that one file? Is there any way how I could get anything back from it?
Mountain runner
 
Posts: 15
Joined: Tue Dec 29, 2009 8:36 pm

Re: Transfer of data

Postby kraada » Tue May 17, 2011 4:29 pm

No, it's not. It's all binary data - you may have deleted part of the holdem_hand_histories table or the holdem_hand_player_statistics table or the holdem_cache table - we really can't tell. Deleting any of those files permanently breaks the database beyond repair and you will need to recreate it and reimport it from the original hand histories.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Transfer of data

Postby Mountain runner » Tue May 17, 2011 4:33 pm

Ok, thank you. Should have asked you before deletion, my fault.
Mountain runner
 
Posts: 15
Joined: Tue Dec 29, 2009 8:36 pm

Re: Transfer of data

Postby kraada » Tue May 17, 2011 4:43 pm

I wish I had a better answer for you, but there's really nothing to be done.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 17 guests

cron
highfalutin