How to upgrade Web Help Desk to version 12.7.7 using PostgreSQL as the Database

Starting with WHD 12.7.7, PostgreSQL 13.3 is now required for all WHD deployments using PostgreSQL. WHD 12.7.7 ships with a script that will upgrade the embedded PostgreSQL version 9 to version 13.3.
You'll first need to upgrade the application, after which you can then proceed to upgrade your current PostgreSQL database to PostgreSQL version 13.

NA

Pre-Implementation Steps:
1. Review the 12.7.7 System Requirements
2. Current Database Backup of your Web Help Desk
3. Create a Server Snapshot
4. Access your current WHD Server
    a. Backup your WebHelpDesk\conf directory files
    b. Backup your WebHelpDesk\bin\wrapper\conf directory files
    c. If you have any customization with WHD CSS, make sure to backup WebHelpDesk\bin\webapps\helpdesk\css

5. Review this article for more information on the Upgrading to Web Help Desk Version 12.7.8 with Default PostgresSQL Database in-use 

Implementation Steps:
1. Log in to Web Help Desk Server
2. Stop the Web Help Desk services.
3. Run the install file, hit the next button until you complete the Upgrade Configuration Wizard
4. It will prompt and launch the Web help Desk Web Console, verify the Web Help Desk version, go to Setup > General > System Information.
5. After the Upgrade, a new PostgreSQL Services: PostgreSQL13ServiceWHD will be added in Services.


!!!IMPORTANT NOTE: Please ensure that this PostgreSQL13ServiceWHD service status was set to Disabled. This is to avoid conflict with current PostgreSQL9 (see below) and avoid Database Upgrade Issues.


6. Upgrade the PostgreSQL database to the latest version (13.3)
7. Navigate to C:\Program Files\WebHelpDesk\bin
Double-click the following file:
upgradeDatabase.bat
8. Follow the prompts on your screen to complete the upgrade.


9. Then it will prompt and launch the Web help Desk Web Console, verify the PostgreSQL version.
Go to Setup > General > Database


10. Go back to the Web Help Desk Services, please make sure that the old PostgreSQL Services (version 9) were disabled and the new PostgreSQL Services: PostgreSQL13ServiceWHD is now running.




11. Go back to the Web Help Desk console, Setup > General > Database, and change the database credentials if they are still using the default "whd" username. Follow the change the default PostgreSQL database credentials article. 
Note: If you already performed this, skip this step.

If your Web Help Desk server is running on Linux, please see How to upgrade to PostgreSQL 13 from PostgreSQL 9 on Web Help Desk running on Linux for steps to perform the upgrade in your environment.

*Note: If a client upgrades to WHD 12.7.8 from a version prior to 12.7.7 without upgrading PostgreSQL9 to PostgreSQL13, WHD 12.7.8 will not recognize PostgreSQL9. Make sure to upgrade PostgreSQL9 to PostgreSQL13 first in WHD 12.7.7 before upgrading to 12.7.8