During the course of investigating a technical support issue for Commander®, the need may arise to run a query against your PostgreSQL database. A management utility for the database, called pgAdmin, is installed along with Commander so that you can operate directly against your database.

Before running any queries, make sure you have valid backups of your database and/or snapshots of the application server virtual machine.

Connecting to your Database

Follow the procedure below to connect to your Commander database.

1. Login to the Commander application server and browse to <INSTALL_DIRECTORY>\Snow Software\Commander\pgsql\bin and execute pgAdmin3.
   
2. From the File menu, choose Add Server.
   
3. In the New Server Registration dialog, enter localhost in the Name and Host fields.
4. Enter vlmuser in the Username field.
5. Enter vlmpasswd in the Password field.
   
6. Click OK.
7. Expand Server Groups > Servers > localhost > Databases. An X appears beside the vlm database, indicating you are not currently connected.
8. Select the vlm database. A connection is established.

Running a Query

1. Right-click the vlm database and choose CREATE Script.
   
2. Clear the contents of the SQL Editor pane and copy in the query provided by Snow Software Technical Support.
   
3. Under the Query menu, choose Execute.

See Also

• Backing Up the Commander® Database Using pgAdmin
• Restoring the Commander® Database Using pgAdmin