During the course of investigating a technical support issue for vCommander®, the need may arise to run a query against your PostgreSQL database. A management utility for the database, called pgAdmin, is installed along with vCommander 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 vCommander database.
- Login to the vCommander application server and browse to <INSTALL_DIRECTORY>\Embotics\vCommander\pgsql\bin and execute pgAdmin3.
- From the File menu, choose Add Server.
- In the New Server Registration dialog, enter localhost in the Name and Host fields.
- Enter vlmuser in the Username field.
- Enter vlmpasswd in the Password field.
- Click OK.
- Expand Server Groups > Servers > localhost > Databases. An X appears beside the vlm database, indicating you are not currently connected.
- Select the vlm database. A connection is established.
Running a Query
- Right-click the vlm database and choose CREATE Script.
- Clear the contents of the SQL Editor pane and copy in the query provided by Embotics® Technical Support.
- Under the Query menu, choose Execute.