Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for 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