Originally Posted by StrictlyStrategy
This thread is huge and since I think this latest version is pretty stable for most I think it should be locked and a new thread created. Since a lot of questions are probably going to get repeated and it's just too sloppy.
huge threds are a good thing - they already contain answers to commonly asked questions, like this one.
locking this and creating a new one will cause questions to be repeated again, and then even worse those who *do* bother to click "search this thread" will not get any answers.
Anyways. I'm formatting my computer, but I want to keep my DB obviously, what do I do?
The same as you will do for your MP3 collection, word documents etc - make a backup, and restore it afterwards.
You can do this using the pgAdmin program (right click a database -> backup), or the command line tool pg_dumpall (restore with psql). You could export all hand histories and re-import them if something goes horribly wrong.
There may even be a backup / restore button in PT3 database management, can't remember but I think not yet.