Using PostgreSQL🔗

Note

This feature is available for all Eocortex licenses and requires no additional licensing.

Starting from version 3.4 of Eocortex, certain components use PostgreSQL database management system of version 11 or later.

Using PostgreSQL in Eocortex

Version Eocortex

Required PostgreSQL version

Components Eocortex

PostgreSQL installation

Windows

Linux

3.3 or lower

Not required

Not required

Not required

3.4–3.6

11

Search for objects analytics module

Automatically, when installing the Search for objects module with the Eocortex Neural Networks package

Separate PostgreSQL installation

4.0 or higher

12

All Eocortex databases

Automatically, when installing Eocortex Server or Eocortex Standalone from the common distributive

Separate PostgreSQL installation

Requirements and recommendations
  • The minimum required DBMS version when working with Eocortex 3.6 or lower is PostgreSQL 11.

  • The minimum required DBMS version when working with Eocortex 4.0 or higher is PostgreSQL 12.

  • If the system version 3.4-3.6 uses or has previously used the Search for objects module, then after updating to version 4.0 the first time Eocortex starts, the module database will be moved to the EocortexArchivedb directory common to all databases. Module's operation will be suspended while the database is being moved.

  • If the system previously used Face or License Plate Recognition modules, then after updating to version 4.0 the first time Eocortex starts, databases of these modules will migrate from Firebird to PostgreSQL. The modules will be suspended during the migration.

  • Before installing the required version of PostgreSQL, it is recommended to uninstall other DBMS versions to avoid conflicts.

  • It is recommended to install PostgreSQL automatically during the installation of Eocortex components.

  • It is recommended to use local disks for storing the database. The use of network drives for this purpose is prohibited.

  • In large systems it is not recommended to use the same disk for parallel recording of the video archive and the database, as it may adversely affect the performance of the database.

  • The proper operation of Eocortex is not guaranteed when transferring database privileges to manually created DBMS users.

Related references