Restore from Backup

[dbot2006]

I am trying to restore an SQL database from a *backup file and it will not work for me.
I open the Database functions window and choose the file to be restored. I hit the RESTORE button and a dos window opens that seems to be restoring the DB. When that window closes nothing has changed.
Please help. What am I doing wrong?

[ptrack pat]

See step #4 at the bottom of this FAQ
viewtopic.php?f=30&t=1369

[Jonas]

I am trying to restore an SQL database from a *backup file and it will not work for me.
I open the Database functions window and choose the file to be restored. I hit the RESTORE button and a dos window opens that seems to be restoring the DB. When that window closes nothing has changed.
Please help. What am I doing wrong?

Hi ptrack pat,

i have exactly the same problem as dbot2006 had. but i use PT3 so your explanation does not really help to solve my problem. Cound you please explain how these prob can be fixed under PT3???

best regards, jonas

[ptrack pat]

Please post your issue in the PT3 forums, I don't support PT3.

[dbot2006]

I am having problems restoring again. I reinstalled PT and SQL on a new Vista system as an Admin with UAC turned off. I have edited the pg_hba.conf file to say "true". After I choose the file to restore and the location of restore.exe a dos window opens for 1 second then closes. I have tried stopping and restarting the server.
Help please.

[ptrack pat]

The values in the pg_hba.conf file should say "trust" not "true".

[dbot2006]

Yes sorry I meant trust, I was reciting from memory (poorly). The file is set to "trust". The result is the same.

[ptrack pat]

What is the size of the .backup file you are trying to restore? Are you sure it's a PT2 PostgreSQL .backup file you are selecting?

Are you sure you are running PT as administrator? Vista should be prompting you to cancel/allow PT to run.

[dbot2006]

The backup I am restoring is 230MB. It is most surely a PT2 PostgreSQL .backup file.
I am running as an admin.

Please continue helping.
Thank you.

[ptrack pat]

go to the c:\program files\poker tracker v2 folder. There should be a file called "ptpgrdump.txt" there. Open that file, copy all the text and paste it into a reply.