by ptrack pat » Sun Jul 26, 2009 8:46 am
You just need to use the Utilities > PostgreSQL Database Functions window to make a backup of your db, like you did when I asked you to send me the .backup file a few days ago. You don't then need to backup any other PostgreSQL files. After you reformat, you will have to reinstall PostgreSQL and restore the database.
To do the restore (after the reformat):
1. Open the Utilities/PostgreSQL Database Functions window.
2. In the Restore section, use the Browse button to select the backup file you created when you backup up the db.
3. Click the Restore button. Let the DOS window that opens when the restore starts close by itself. That will mean the restore is done. It could take 20 minutes or so.
4. Go to the File/Maintain Database Names window, click the Add button and then select "Select existing PostgreSQL database" option from the last field in the new row. Then on the window that opens, select the database that was created by step 3. Check the "Dflt" box next to this new entry. Then save the changes and close the window and RESTART PT and you'll be ready to go.