1. Connect to the Virtual Appliance (VA)/Linux machine via SSH as user 'admin'
2. Once connected, change to the user 'root': type 'sudo su'
3. Stop WHD > type 'service webhelpdesk stop'
4. Configure PostgreSQL to allow connection from all interface by editing 'postgresql.conf'
Scroll through the lines and look for:
#listen_addresses = 'localhost'
then PRESS 'a' key to enter into edit mode and change the previous line to:
listen_addresses = '*'
Note: '#' has been removed to uncomment the line
Save the file pressing SHIFT + 'ZZ' (two 'z' keys)
5. Switch to PostgreSQL user: su - postgres
6. Start PostgreSQL manually using the following command and do not close the SSH window:
/usr/local/webhelpdesk/bin/pgsql/usr/pgsql-9.2/bin/postmaster -p 20293 -D /usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data
7. In the Windows WHD, go to Setup > General > Database
8. Click 'Backup Now'
9. Stop WHD once the backup is done on the Windows machine
10. Browse to 'C:\Program Files\WebHelpDesk\pgsql9\bin'
11. Run pgAdmin3
12. On pgAdmin III window, go to File > Add Server
13. Add the following:
Host: [the VA IP]
Maintenance DB: postgres
Password: <enter the password you have used originally>
14. Expand 'Databases' > right-click 'whd' and select 'Delete/Drop' from the menu
15. Click 'Yes'
16. Create a new database, right-click on 'Databases'
17. Select 'New Database' and set the following:
18. Right-click on 'whd' then select 'Restore'
19. Search for the backup file of the PostgreSQL DB. It is usually in 'C:\Program Files\WebHelpDesk\pgsql9\Backups\'. However, you might have possibly changed this path from WHD webconsole > Setup > General > Database'.
20. Click 'Restore'.
21. Once the restore is done and successful, go back to the SSH Window connected to the VA/Linux
22. Do a 'CTRL + C' to stop PostgreSQL from running and type 'exit' to switch back to user 'root'
23. Start WHD on the VA/Linux: service webhelpdesk start