Unable to establish a connection: connection refused

1. The "Web Help Desk PostgreSQL 13.3 Embedded Database" service is stopped and not running.
2. Missing Microsoft Visual C++ 14.28.29914 requirement.

Web Help Desk PostgreSQL 13.3 Embedded Database" service is not running.

1. Run the Service.msc as an admin.
2. Check the status of the Web Help Desk PostgreSQL 13.3 Embedded Database" service.
3. If the status is stop, start it, or run the whd_start.bat as an admin from the WHD installation path (C:\Program Files\WebHelpDesk), which will run both the WHD service and PostgreSQL service.

Web Help Desk PostgreSQL 13.3 Embedded Database" service is missing.

1. Install the Microsoft Visual C++ 14.28.29914 (KB2999226)
   • Ref: The program can't start because api-ms-win-crt-stdio-l1-1.0.dll is missing from your computer When Upgrading Webhelpdesk Database to PGSQL13 
2. Ensure that Powershell is version 5.1 and above,
   • To check the version, open PowerShell and type in $PSVersionTable
3. Restart the service once Microsoft Visual C++ or Powershell was upgraded.
4. After reboot, stop the WHD.
5. Stop WHD by running the whd_stop.bat as an admin from the WHD installation path (C:\Program Files\WebHelpDesk).
6. Rename data folder of C:\Program Files\WebHelpDesk\pgsql13\data to data_old
7. Launch CMD as an admin. Navigate to C:\Program Files\WebHelpDesk and run the following command:
   • 

   • INSTALL_SERVICES.bat "C:\Program Files\WebHelpDesk"
     -- Scripts are not supported under any SolarWinds support program or service.
     -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
     -- disclaims all warranties including, without limitation, any implied warranties
     -- of merchantability or of fitness for a particular purpose. The risk arising
     -- out of the use or performance of the scripts and documentation stays with you.
     -- In no event shall SolarWinds or anyone else involved in the creation,
     -- production, or delivery of the scripts be liable for any damages whatsoever
     -- (including, without limitation, damages for loss of business profits, business
     -- interruption, loss of business information, or other pecuniary loss) arising
     -- out of the use of or inability to use the scripts or documentation.
     

8. Check now in the Services.msc if Web Help Desk PostgreSQL 13.3 Embedded Database" service exists.
9. Start WHD by running the whd_start.bat as an admin from the WHD installation path (C:\Program Files\WebHelpDesk) which will run both the WHD service and PostgreSQL service.
10. If both WHD and Web Help Desk PostgreSQL 13.3 Embedded Database" services are now running, retry creating the database.