Page 1 of 1
backuping the db on external disk

Posted:
Sat May 24, 2008 6:20 pm
by enafonja
Hi,
Where i can find the backup of my postgres sql db so i can copy paste it do an external drive from time to time if i have followed the standard installation procedure. with access it was simple because it was stored in ptreker folder...
tnx,
Peter
Re: backuping the db on external disk

Posted:
Sat May 24, 2008 6:57 pm
by APerfect10
There currently is not an easy way to backup/restore databases; this is on our to-do list.
The only way to backup a database is to run the PostgreSQL
pg_dump application from the command line.
Go Start->Run, 'cmd' OK.
At the command prompt change your directory to PostgreSQL/8.3/bin:
- Code: Select all
cd "C:\Program Files\PostgreSQL\8.3\bin"
Then run pg_dump:
- Code: Select all
pg_dump -U postgres [database name]
Best regards,
Derek
Re: backuping the db on external disk

Posted:
Sun May 25, 2008 11:22 am
by dorado16
couldn't you just copy all the processed HH's from PT3 in my computer> prog files> PT3.... etc... and just move them onto a flash drive? it would be annoying to re-import them but it's pretty simple to do.
Re: backuping the db on external disk

Posted:
Sun May 25, 2008 11:28 am
by WhiteRider
Yes, storing the hand history files is the ultimate backup, in a way - the only potential problem with this is for tournaments, with the summary information not being in the HH files.
Re: backuping the db on external disk

Posted:
Wed May 28, 2008 5:12 am
by enafonja
yes great tip to just copy all the moved HH files...but this is possible for party for example....tower doesn`t have that option...but i can copy the mystatistics.db file in towergaming-resources folder,...if i am not mistaken all the hans are stored there?!
Re: backuping the db on external disk

Posted:
Wed May 28, 2008 5:19 am
by WhiteRider
I would guess so, though I don't know tower personally.
If that is the file (or it's the file in the folder) specified in the auto-import then that's where PT3 gets the hands from, so backing up multiple instances of that will do it.
Re: backuping the db on external disk

Posted:
Fri May 30, 2008 1:49 pm
by leotsou
What happens when you export you observed Hands DB and your Hands Played DB and then manually import them to your second copy of PT3 on say your laptop? Do you get the same stats and the original or do you need the HH for the observed hands?
Re: backuping the db on external disk

Posted:
Fri May 30, 2008 2:21 pm
by WhiteRider
The exported files will contain all the HH, so all should import OK.
Re: backuping the db on external disk

Posted:
Fri May 30, 2008 4:47 pm
by leotsou
WhiteRider wrote:The exported files will contain all the HH, so all should import OK.
My "Observed Hands" DB is saved without HH so would I get all those stats (I do know that PT3 can only read from 1 DB at a time for the time being) to show up, even without the HH?
Re: backuping the db on external disk

Posted:
Fri May 30, 2008 4:52 pm
by WhiteRider
Ah, no - if the HH isn't saved, then there is no way to retrieve it.