Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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