Restoring from PostgreSQL data files?

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

Restoring from PostgreSQL data files?

Postby Longluck » Fri Sep 10, 2010 1:17 pm

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?
Longluck
 
Posts: 3
Joined: Fri Jun 20, 2008 3:10 pm

Re: Restoring from PostgreSQL data files?

Postby WhiteRider » Fri Sep 10, 2010 1:31 pm

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.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Restoring from PostgreSQL data files?

Postby Longluck » Fri Sep 10, 2010 6:27 pm

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.
Longluck
 
Posts: 3
Joined: Fri Jun 20, 2008 3:10 pm

Re: Restoring from PostgreSQL data files?

Postby WhiteRider » Sat Sep 11, 2010 3:47 am

Cool - so you're sorted?
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Restoring from PostgreSQL data files?

Postby Longluck » Sat Sep 11, 2010 6:03 am

Yes :)
Longluck
 
Posts: 3
Joined: Fri Jun 20, 2008 3:10 pm


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 15 guests

cron