During the course of investigating a technical support issue for Embotics® vCommander®, the need may arise to restore your PostgreSQL database. A management utility for the database, called pgAdmin, is installed along with Embotics® vCommander® so that you can operate directly against your database.
Connecting to your Database
Follow the procedure below to connect to your Embotics vCommander database.
- Login to the Embotics 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.
Restoring the Database
Now that you are connected, you can proceed with restoring the database. Before you begin the next procedure, make sure that you have access to as much disk space as is required for the backup file.
- If Embotics vCommander is currently running, you will need to stop the service before you can complete the restore. To do so, issue the command services.msc from the Start menu on the Embotics vCommander application server.
- From the list of services, right-click vCommander and choose Stop.
- Back in pgAdmin3, right-click the vlm database and choose Delete/Drop. Confirm this choice when prompted.
- Right-click Databases and choose New Database.
- For Name, enter vlm.
- Click OK. The database is created.
- Right-click the vlm database and choose Restore.
- For Format, choose Custom or tar.
- Use the ellipsis (…) to browse to and select your backup file.
- For Rolename, choose vlmuser.
- Click Restore.
- Click Done. Close all pgAdmin3 windows.
- Restart the Embotics vCommander service by right-clicking it and choosing Start.