Back up and restore the PostgreSQL database using the web console on Web Help Desk

Back up the PostgreSQL database

1. Log in to Web Help Desk as an administrator. 
2. Click Setup > General > Database.
3. Click the Vendor drop-down menu and select PostgreSQL.

4. (Optional) In the Backup Schedule row, select a weekly backup schedule. 
5. Verify that the Backup Folder path is correct. 
6. Click Backup Now to back up the database. 

Restore the PostgreSQL database using pgAdmin3

This procedure requires you to replace the Web Help Desk database.

1. Log in to Web Help Desk as an administrator.
2. Stop and start Web Help Desk.
3. If you are running Web Help Desk 12.7.6 and earlier, go to the <WHD_install_location>\WebHelpDesk\pgsql9\bin folder and double-click pgAdmin3.exe. If you are running Web Help Desk 12.7.7 and later, go to the <WHD_install_location>\WebHelpDesk\pgsql13\bin folder and double-click pgAdmin4.exe
4. Start the pgAdmin application.
5. Click the connector  icon.
6. In the New Server Registration window, enter the following parameters in the Properties tab, leaving the other fields empty or with default data:
   • Name:
   • Host: localhost
   • Port: 20293
   • Username: whd
   • Password: whd
   • whd is the default password
7. In the pgAdmin Object Browser, expand Servers > WHDDB > Databases > whd.
8. Right-click whd and select Delete/Drop.
9. Right-click Databases and select New Database.
10. Enter whd as the new database name,  whd  as Owner in the drop-down menu.
11. Go to Definition tab and set Collation and Character type to English_United_States.1252 in the dropdown lists.
12. Click OK.
13. Right-click the new whd database and click Restore.
14. Navigate to the database file or enter the filename.
15. Select Custom in the Format.
16. Leave Number of Jobs as blank.
17. Select whd as the Rolename.
18. Click Restore.
19. Restart Web Help Desk.