Database installation

Owned by Tom Polman
Last updated: Apr 03, 2023 by Maarten van der Heijden (Unlicensed)
3 min read

Software Installation Article | SIA-20211210-CS-01

VDG Sense | Software Installation

With VDG Sense 2.6.10 Postgres 13.3 is included in SenseSetup. It replaces Postgres 9.2, but does not upgrade current Postgres / database installations. New installations will use Postgres 13.3.

Key differences with previous installations are:

  • Configurable installation path, port and user credentials in SenseSetup

  • Configurable host, port and user credentials in Sense Server

Installation with postgres 9.2

If Postgres 9.2 is already installed, it will not upgrade the installation with version 13.3. In the Components page the database installation cannot be selected:

Installation with postgres 13

If the server does not have the database installed, the Components page shows the option to install the database:

In the following page the installation parameters can be configured. The username and password need to be at least 4 characters to maximum of 16 characters. It is recommended to use a complex password for the installation.

Sense configuration

After installation the server tab shows where the database connects to and the connection status itself.

A Disconnected status can occur for the following reasons:

  • Wrong user credentials

  • Wrong host or port

  • Postgres servers not running (check windows services)

To change the postgres connection or to resolve issues with user credentials, host or port, press ‘Setup Database’ button. The following dialog appears:

The following settings can be configured:

  • Host: host ip or dns name from database

  • Port: port number of database

  • Username: username of user to connect to database

  • Password: password of user to connect to database

Note: It is possible to configure a postgres host address from a postgres instance running at cloud provider like AWS, GCP or Azure.

Multi-server configuration

In all VDG Sense 2.6.9 and before the sub-servers connect to the database on the management server. This connection was automatically done by configuring the management server address on the sub servers. With VDG Sense 2.6.10 this behaviour has changed and the database configuration has to be done seperately per sub server.

IMPORTANT: In a Cluster configuration events are always stored on the Management server.

IMPORTANT: If the Database host is not set to Management server it is not possible to use License Plate matching for cameras on the cluster servers.