Sorry for opening a new thread if one already exists. I have couple of questions. I need to format my local drives because I have performace issues with windows. I have PT3 and is it possible to somehow backup my current database and HH and to restore it in a new clean insalation of poker tracker? If it is possible can someone please tell me how exactly to do that so that when I install PT3 on new windows everything is exactly the same as it was before? thx

The easiest way is to update to Beta 30.8 (if you don't already have it) and use File > Backup. This will store all of your databases and config files in one .zip file.
Save that and when you have reinstalled PT3 use File > Restore.

Download page
PT3 Build History / Release Notes

Pretty sure you could just use the pgAdmin III tool to backup the database, which I'm guessing would include all hand histories and everything else that's imported into the database.

I use the backup functionality to swap my database between a laptop and desktop installation. When I go on a trip or something and I know I might want to get in a few sessions on the laptop, I restore my main database over - then when I'm back, I back it up on the laptop and restore back to the desktop so I'm always using the latest data.

When importing the backed up database, I found the easiest way is just to drop the old DB entirely, and re-create a new empty DB with the same name, and same parameters as the old. Then you can simply restore the backup right into the empty DB. If it's the same exact name PT3 will find it exactly the same as the previous DB.

If this sounds like the way you want to go, I can post a little bit more detailed instructions for you. I also have a .bat (windows batch file) that I created to perform the backups without even having to launch the pgAdmin utility. Just post back and let me know.

PA

You can indeed backup and restore via PGAdmin (or even a DOS prompt) but the new backup/restore mechanism in PT3 is much easier.

If you prefer to do it manually PA_Kid's bat file may help you, but there are also directions in the Database / PostgreSQL FAQ.