During the course of investigating a technical support issue for Snow Commander, you may need to to restore your PostgreSQL database. A management utility for the database called pgAdmin is installed on the Commander application server that you will use to do this.

Connecting to your Database

Follow the procedure below to connect to your Snow Software Commander database.

1. Login to the Snow Software Commander application server and browse to <INSTALL_DIRECTORY>\Embotics\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.

Restoring the Database

Now that you are connected, you can restore the database. Before you begin make sure that you have access to as much disk space as is required for the backup file.

1. If Snow Commander is running, you will need to stop the service. Launch services.msc from the Start menu on the Commander application server.
2. Stop all the Commander services except for the Commander Database service. 
3. Back in pgAdmin3, right-click the vlm database and choose Delete/Drop. Confirm this choice when prompted.
4. Right-click Databases and choose New Database.

5. For Name, enter vlm. For Owner, choose vlmuser.
6. Switch to the Definition tab and for Encoding choose UTF8.
7. Click OK. The database is created.
8. Right-click the vlm database and choose Restore.
9. For Format, choose Custom or tar.
10. Use the ellipsis (…) to browse to and select your backup file.

11. For Rolename, choose vlmuser.
12. Click Restore.
13. Click Done. Close all pgAdmin3 windows.
14. Restart the Commander services.

See Also

• Backing up the Commander® Database Using pgAdmin