Backup the Commander® Database with pgAdmin

During the course of investigating a technical support issue for Snow Commander, you may need to to backup 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.

Performing the Backup

Now that you are connected, you can proceed with performing the backup. Before you begin the next procedure, make sure that you have access to as much disk space as is required for the backup file.

1. Right-click the vlm database and choose Backup.
   
2. On the next dialog, click the ellipsis (…) and choose a filename and location to store your database backup.
3. For Format, select Custom.
4. Leave Compress Ratio blank.
5. For Encoding, choose UTF8.
6. For Rolename, choose vlmuser.
7. Click Backup.

See Also