Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Commands for WHD database export and import

Commands for WHD database export and import

Example of commands needed to export/import the database.

 

Source server

  1. Stop WHD
  2. Open a command line and execute:
    WHD_INSTALL_DIR/pgsql9/bin
  3. Export the database by executing the following command:
    pg_dump -Fc -v -p 20293 -U whd whd > whd.pgdump
  4. Move whd.pgdump to the new server. 

Destination server

 

  1. Stop WHD by running the command,  WHD_INSTALL_DIR/webhelpdesk/whd stop
  2. Navigate to WHD_INSTALL_DIR/pgsql9/bin.
  3. If there is already an initialized whd database in place, rename the database using following commands in the psql tool:
    psql -p 20293 -U whd -d template1
    ALTER DATABASE whd rename to whd_old;
  4. Create an empty whd database in psql tool:
    CREATE DATABASE whd;
  5. Restore the database. Exit the psql tool first (\q) to return to the cmd directory (directory WHD_INSTALL_DIR/pgsql9/bin):
    pg_restore -Fc -v -p 20293 -U whd -d whd "path_to_whd.pgdump"
Last modified

Tags

Classifications

Public