Submit a ticketCall us

Putting Your Logs Where They Belong with the New SolarWinds Log Manager for Orion

The new SolarWinds® Log Manager for Orion® finally puts your log data right where it belongs, in the heart of your Orion console. Gain insight into the performance of your infrastructure by monitoring your logs in a unified console allowing you to see a wealth of information about the health and performance of your network and servers.

Reserve a Seat for Wednesday May 23rd 11am CDT | Reserve a Seat for Tuesday May 22nd 10:30am GMT | Reserve a Seat for Tuesday May 22nd 1pm SGT / 3pm AEST

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

Updated September 27, 2017

Overview

This article describes how to restore your PostgreSQL database on a new server after you upgrade to the latest Web Help Desk version. 

Steps

  1. Copy the backup file from the old server to the new server.
  2. Stop Web Help Desk on the new server.
  3. On your Web Help Desk server, open the Apps page and click Services.
  4. in the Services window, ensure that one of the following services is running and displays in the list. To start the service, right-click the service and select Start.
    • Web Help Desk PostgreSQL Embedded Database
    • PostgreSQL Embedded Database
  5. Navigate to your WebHelpDesk directory.
    Apple® OS X®:  /Library/WebHelpDesk    
    Microsoft Windows®:  \Program Files\WebHelpDesk    
    Linux: /usr/local/webhelpdesk
  6. Navigate to pgsql9\bin and double-click pgAdmin3. 
  7. In the pgAdmin III window, click File > Add Server.
  8. Add the following information in the window:
    • Name: WHDDB
    • Host: localhost
    • Port: 20293
    • Maintenance DB: postgres
    • Username: whd
    • Password: whd
  9. Click OK on the Guru Hint window.
  10. Expand Databases.
  11. Right-click whd and select Delete/Drop from the menu.
  12. In the Guru Hint window, clickYes, and then click OK.
  13. Right-click Databases and select New Database.
  14. Set the following:
    • Name: whd
    • Owner: whd
  15. Right-click whd and select Restore.
  16. Navigate to the backup file that you copied from the old server, and then click Restore.
  17. Start Web Help Desk on the new server. 
Last modified

Tags

Classifications

Public