Database Configuration

Database Configuration Guidelines

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

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.

Common Errors

Here you will find detailed descriptions of various errors that may occur during the database configuration process: