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) > Move the WHD database to another disk on the same server

Move the WHD database to another disk on the same server

Table of contents
Created by Miroslav Beno, last modified by Steve.Hawkins on Aug 18, 2017

Views: 125 Votes: 0 Revisions: 4

Overview

This article explains how to move the WHD database to another disk (from C to E) on the same server.

Environment

All supported Web Help Desk versions with an integrated PostgreSQL database

Steps

  1. Back up your Web Help Desk database to a separate location. 
  2. Uninstall Web Help Desk from the current location. 
  3. Install Web Help Desk in the new location.
  4. Navigate to:
    C:\Program Files\
    WebHelpDesk\pgsql9\bin
  5. Run pgAdmin3.
  6. In the pgAdmin III window, click File > Add Server.
  7. Add the following:
    • Name: WHDDB
    • Host: localhost or IP address
    • Port: 20293
    • Maintenance DB: postgres
    • Username: whd
    • Password: whd
  8. Expand Databases.
  9. Right-click whd and select Delete/Drop from the menu.
  10. Click Yes
  11. Right-click Databases.
  12. Select New Database and set the following:
    • Name: whd
    • Owner: whd
  13. Right-click on whd and select Restore.
  14. Locate the backup file of the PostgreSQL database.
  15. Click Restore.

 

Last modified
13:47, 18 Aug 2017

Tags

Classifications

Public