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.