Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Web Help Desk (WHD) > Backup and restore the PostgreSQL database using the web console

Backup and restore the PostgreSQL database using the web console

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 then 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
14:32, 31 Mar 2017

Tags

Classifications

Public