What are the database requirements?

Overview

CAST Imaging requires an RDBMS to store both the data generated during analyses and persistence data (settings/properties etc.) and at the current time CAST supports only PostgreSQL as follows:

  • CAST Storage Service - a PostgreSQL instance packaged and provided by CAST for installation on Microsoft Windows with its own custom installer.
  • PostgreSQL - an installation on Linux, or through Docker on Linux/ Microsoft Windows, of an official PostgreSQL release.

PostgreSQL installed on Linux has consistently proven to provide better performance than CAST Storage Service installed on Microsoft Windows and therefore CAST recommends this where possible.

Requirements for analysis data

Three schemas will be created in a database of your choice for each application you onboard into CAST Imaging:

  • <application_name>_local
  • <application_name>_central
  • <application_name>_mngt

An additional schema will be created in the database of your choice if you are using the CAST Health Dashboard:

  • general_measure (or other custom name)

Requirements for persistence data

  • A database called keycloak_v3 will be created during the installation - if this database already exists it will be re-used and this may cause unexpected behaviour
  • Schemas called admin_center and aip_node will be created in the database of your choice during the installation - if these schemas already exist they will be re-used and this may cause unexpected behaviour

Supported instances

CAST Storage Service

Release Bundled PostgreSQL release Architecture Default port no. Compatibility
4.13.x 13.0 64bit 2284 ≥ 8.3.29
3.0.1, 3.0.2, 3.0.3 9.6.11 64bit 2282 ≥ 8.2.6
3.0.0 9.6 64bit 2282 ≥ 8.2.6

PostgreSQL

CAST does not provide an installer for Linux Operating Systems or Docker, however, you can install the following official PostgreSQL releases on a 64bit Linux Operating System (supported by PostgreSQL) and use them as a storage host for CAST Imaging:

PostgreSQL release Architecture Notes
14.x 64bit Minimum required release of CAST Imaging Core: 8.3.23
13.x 64bit As above
12.x 64bit As above
11.x 64bit Minimum required release of CAST Imaging Core: 8.3.16
10.x 64bit As above
9.6.11 64bit As above

Note that for PostgreSQL ≥ 10.x, a minimum release of some specific CAST technology extensions is required:

Extension Minimum required release
com.castsoftware.jee ≥ 1.0.19
com.castsoftware.dotnet ≥ 1.0.13
com.castsoftware.businessobject ≥ 1.0.4 (LTS)
com.castsoftware.cpp ≥ 2.0.5-funcrel
com.castsoftware.cfamily ≥ 1.5.2-funcrel