Database Configuration

Follow these guidelines to configure and connect the database to the VMS after the installation.

Database Configuration Guidelines

Before proceeding with the setup, ensure that PostgreSQL version 8.2 or later is installed, as earlier versions are not supported for VMS integration.

To prepare the database for connection to the VMS, it's necessary to establish the required PostgreSQL environment by creating a new user, database, and schema specifically for VMS. Follow these steps to complete the setup:

Step 1: Create a new PostgreSQL user with password:

CREATE USER <user_name> WITH PASSWORD '<password>';

Step 2: After creating the user, create a database owned by this user:

CREATE DATABASE <db_name> WITH OWNER = <user_name>;

Step 3: Switch to the newly created database and create a schema:

\c <db_name>
CREATE SCHEMA <schema_name> AUTHORIZATION <user_name>;

Database Connection Process

To start the DB connection process, access the server by opening the following URL:

  • If the VMS was installed on the current PC, use http://localhost:2002/
  • If the VMS was remotely installed on a server, use http://ip:2002/ where IP is the IP address of the remote server

The Database Configuration dialog allows setting the following parameters:

  • In the DB Type drop-down list, select the PostgreSQL DB
  • In the Host field, specify the IP address of the server where the PostgreSQL DB is preinstalled and configured
  • In the DB Name field, specify the name of the database intended for VMS
  • In the Schema Name field, provide the name of the schema created within the database
  • In the Login and Password fields, enter the user credentials of the database owner for accessing the database for VMS

The PostgreSQL DB default port is 5432. If it has been changed to any other, enter "host:port" in the Host field, where:

  • host is the PostgreSQL DB server IP address
  • port is a custom PostgreSQL DB port

Once all fields are correctly filled in:

  1. Click the Test Connection button to check the database connection
  2. Verify the Connection Status has changed to Success, which indicates the connection is successful
  3. Click the Save and Reload button to save the settings and restart the system

At this point, the database configuration and connection are successfully completed.