Page 1 of 1

Restoring from PostgreSQL data files?

PostPosted: Fri Sep 10, 2010 1:17 pm
by Longluck
My old computer gave up the other day. Now I have bought a new one and would like to restore my pokertracker database.

I have all my files from old computer. I have an backup.zip from 2010-09-14. So I'm missing a couple of weeks data. Am I able to restore the database in any other way? Maybe by using the data files in the postgree directory?

Re: Restoring from PostgreSQL data files?

PostPosted: Fri Sep 10, 2010 1:31 pm
by WhiteRider
Probably the easiest thing will be to restore your database and Manual Import the hand history files from the last couple of weeks. They will be in the PokerTracker 3\Processed folder by default (on your old disk).

Otherwise if you copy the PostgreSQL "Data" folder to your new computer and install PostgreSQL over it you may be able to recover it that way, but it depends what state the database was in when your old computer gave up.
The How to reinstall PostgreSQL guide explains how to install PostgreSQL and reconnect to an existing Data folder, if you need to go that way.

Re: Restoring from PostgreSQL data files?

PostPosted: Fri Sep 10, 2010 6:27 pm
by Longluck
Thanks for the fast reply! I managed, despite a couple of failed tries, to recover the database from the data folder on a third maschine and make a backup in pokertracker that I could use on the new maschine.

Re: Restoring from PostgreSQL data files?

PostPosted: Sat Sep 11, 2010 3:47 am
by WhiteRider
Cool - so you're sorted?

Re: Restoring from PostgreSQL data files?

PostPosted: Sat Sep 11, 2010 6:03 am
by Longluck
Yes :)

highfalutin