Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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