Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Back up and restore the PostgreSQL database using the web console

Back up and restore the PostgreSQL database using the web console

Updated: November 1, 2017

This article describes how to back up and restore the Web Help Desk 12.x PostgreSQL embedded database.

Environment

Web Help Desk 12.x installed on a server running Microsoft® Windows Server®

Steps

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. Download pgAdmin from the pgAdmin website. 
  2. Log in to Web Help Desk as an administrator.
  3. Stop Web Help Desk
  4. Start pgAdmin3.
  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: whd

    • Host: localhost

    • Port: 20293

    • Username: whd

    • Password: whd

      whd is the default password. 

  7. In the pgAdmin3 Object Browser, expand Servers > whd > 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, and click OK.
  11. Right-click the new whd database and click Restore.
  12. Navigate to the database file or enter the filename.
  13. Select whd as the Rolename.
  14. Click Restore.
  15. Restart Web Help Desk.
Last modified

Tags

Classifications

Public