backuping the db on external disk

[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

[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

[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.

[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.

[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?!

[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.

[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?

[WhiteRider]

The exported files will contain all the HH, so all should import OK.

[leotsou]

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?

[WhiteRider]

Ah, no - if the HH isn't saved, then there is no way to retrieve it.