Tools

How to connect and view the Web Help Desk embedded PostgreSQL database

This article describes how to connect and view the Web Help Desk embedded PostgreSQL database

First published date

2/15/2020 12:59 PM

Last published date

6/18/2020 1:07 PM

Overview

Similar to other SQL database, you can view and configure your PostgreSQL database using a user interface called pgAdmin3. pgAdmin3 is automatically installed along with Web Help Desk for Windows and macOS installations.
 

Product section

Web Help Desk

Resolution

Use pgAdmin3 to connect to the PostgreSQL database

1. Log into Web Help Desk Server
2. Go to this directory: C:\Program Files\WebHelpDesk\pgsql9\bin    
3. Run pgAdmin3. Run as Administrator.



4. Connect to the WHD database.



Name is whddb
The default Username is whd.
The default Password is whd.
Host is either Localhost or 127.0.0.1

Pr oper tes SSL Main tenance DE Password Store password Group New Server Registration Adv anced 127.0.0.1 20293 postgr es Servers

5. Click Ok. Then close pgAdmin3, then run it again.
6. Expand "Databases" then double click 'whd'


Run SQL queries using pgAdmin3

1. Click the SQL icon at the top (the icon that looks like a magnifying glass)
2. Type the SQL command, then click the green play button at the top to execute.



Note: pgAdmin3 is only a database interface, and is not the actual database program. pgAdmin3 may display any number of database connections to PostgreSQL. However, it does not mean that there are multiple instances of the database running in your deployment.