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) > Restore PostgreSQL on a new server after a Web Help Desk (WHD) upgrade

Restore PostgreSQL on a new server after a Web Help Desk (WHD) upgrade

Table of contents
No headers

Updated March 11th, 2016

 

To restore PostgreSQL on the new server after upgrading to the latest version of WHD:

  1. Copy the backup file from the old server to the new server.
  2. Stop WHD on the new server - Stop and start Web Help Desk.
  3. Go to Start > Run > services.msc and check if Web Help Desk PostgreSQL Embedded Database or PostgreSQLServiceWHD is running. Click Start it if it is not running.
  4. Browse to ..\WebHelpDesk\pgsql9\bin and run pgAdmin3.
  5. In the pgAdmin III window, go to File > Add Server and add the following information:
    • Name: WHDDB
    • Host: localhost
    • Port: 20293
    • Maintenance DB: postgres
    • Username: whd
    • Password: whd
  6. Click OK on the Guru Hint window.
  7. Expand Databases.
  8. Right-click whd and select Delete/Drop from the menu. Click Yes and click OK in the Guru Hint window.
  9. Create a new database. Right-click Databases and select New Database.
  10. Set the following:
    • Name: whd
    • Owner: whd
  11. Right-click whd then select Restore.
  12. Search for the backup file that was copied from the old server and click Restore.
  13. Start Web Help Desk  - Stop and start Web Help Desk.
Last modified
13:37, 6 Feb 2017

Tags

Classifications

Public