PostgreSQL - Deployment requirements

End of Life Notice

CAST Storage Service (com.castsoftware.css) is End of Life and is no longer supported or distributed. Customers previously using CAST Storage Service must migrate to a standard PostgreSQL installation. CAST recommends PostgreSQL 18.x.

Info

Summary: information to help you plan your PostgreSQL installation.

Hardware

On-premise

Server type	Architecture	CPU	RAM	DISK	OS	Notes
Physical/virtual	64-bit	Minimum 2 processors: Intel Core i5, 2.6 GHz Intel Xeon, 2.2 GHz Recommended 4 processors: Intel Core i7, 2.8 GHz Intel Xeon, 2.6 GHz	32GB min	512GB (SSD recommended)	Windows or Linux	CAST highly recommends the use of PostgreSQL on a Linux instance as this consistently gives the best performance.

Server type

Architecture

CPU

RAM

DISK

Notes

Physical/virtual

64-bit

Minimum 2 processors:

Intel Core i5, 2.6 GHz
Intel Xeon, 2.2 GHz

Recommended 4 processors:

Intel Core i7, 2.8 GHz
Intel Xeon, 2.6 GHz

32GB min

512GB (SSD recommended)

Windows or Linux

CAST highly recommends the use of PostgreSQL on a Linux instance as this consistently gives the best performance.

Cloud services

Amazon Web Services EC2

The following requirements are based on CAST’s own testing for the analysis of a single “large Application”, using Amazon EC2 R5 Instances:

Minimum instance type	Volume Size	Volume Type	Minimum IOPS
r5.xlarge r5d.xlarge	512GB	General purpose SSD (gp2) or Provisioned IOPS SSD (io1)	400

Amazon Web Services RDS

CAST supports PostgreSQL instances deployed via Amazon Web Services RDS. See also Accessing PostgreSQL on Amazon Web Services RDS.

Supported Operating Systems

Info

Note that CAST highly recommends the use of a Linux Operating System to host a PostgreSQL RDBMS, instead of using the CAST Storage Service on a Microsoft Windows operating system. PostgreSQL installed on Linux has consistently proven to provide better performance than CAST Storage Service installed on Microsoft Windows.

PostgreSQL

Operating System	Supported	Supported by ref.	Deprecated support	Notes
Recommended - all Linux distributions based on (or derived from) Red Hat.	✅			See the following PostgreSQL documentation for more information: https://www.postgresql.org/docs/14/supported-platforms.html https://www.postgresql.org/docs/13/supported-platforms.html https://www.postgresql.org/docs/12/supported-platforms.html https://www.postgresql.org/docs/11/supported-platforms.html https://www.postgresql.org/docs/10/supported-platforms.html https://www.postgresql.org/docs/9.6/supported-platforms.html https://www.postgresql.org/docs/9.2/supported-platforms.html

Operating System

Supported

Supported by ref.

Deprecated support

Notes

Recommended - all Linux distributions based on (or derived from) Red Hat.

✅

See the following PostgreSQL documentation for more information:

Supported PostgreSQL releases

CAST does not provide a custom installer for Linux Operating Systems, however, you can install the following official PostgreSQL RDBMS on to a 64bit Linux Operating System (supported by PostgreSQL) and use it as a storage host for CAST AIP:

PostgreSQL release

Supported

Supported by ref.

Deprecated support

Notes

18.x

✅

Minimum required release of CAST AIP core: 8.3.61

17.x

✅

16.x

✅

Minimum required release of CAST AIP core: 8.3.60

15.x

✅

Minimum required release of CAST AIP core: 8.3.55

14.x

✅

13.x

✅

Minimum required release of CAST AIP core: 8.3.23

12.x

✅

11.x

✅

Support is available for PostgreSQL 10.x and 11.x (64bit) as storage, i.e. AIP schemas can be created on these versions and analyses will run as expected. Some prerequisites do apply:

Minimum required release of CAST AIP core: 8.3.16
Minimum required release of some specific extensions:

JEE Analyzer extension	com.castsoftware.jee	≥ 1.0.19	The required minimum releases of these extensions are delivered as "shipped extensions" in AIP 8.3.16.
.NET Analyzer extension	com.castsoftware.dotnet	≥ 1.0.13
SAP BusinessObjects Analyzer extension	com.castsoftware.businessobject	≥ 1.0.4 (LTS)
C and Cpp Analyzer extension	com.castsoftware.cpp	≥ 2.0.5-funcrel	-
iOS - Objective-C Analyzer extension	com.castsoftware.cfamily	≥ 1.5.2-funcrel	-

10.x

✅

9.6.11

✅

9.2.x

✅

PostgreSQL running in encrypted SSL mode

Support is available for connecting to PostgreSQL instances running in encrypted SSL mode. See SSL encrypted mode configuration for PostgreSQL:


CAST AIP Core (any application provided with the CAST AIP “core” setup)	✅	≥ 8.3.24
CAST Architecture Checker (standalone)	✅	≥ 1.2.0-funcrel
CAST Dashboards	✅	≥ 2.0.0-beta1
CAST Imaging (for Source Code configuration)	✅	≥ 2.0.0-funcrel (when using Microsoft Windows traditional installer)
CAST Console (AIP Node)	✅	≥ 1.17.0-funcrel
Sherlock (CAST Support tool)	✅	Sherlock delivered in AIP Core ≥ 8.3.25.

All official CAST AIP Extensions are compatible, however some extension require specific minimum releases:


JEE Analyzer extension	com.castsoftware.jee	≥ 1.0.28	The required minimum releases of these extensions are those that are delivered as “shipped extensions” in AIP 8.3.24.
.NET Analyzer extension	com.castsoftware.dotnet	≥ 1.0.17
SAP BusinessObjects Analyzer extension	com.castsoftware.businessobject	≥ 1.0.6 (LTS)
C and Cpp Analyzer extension	com.castsoftware.cpp	≥ 2.1.0-funcrel	-
iOS - Objective-C Analyzer extension	com.castsoftware.cfamily	≥ 1.5.4-funcrel	-

Info

User or Lab extensions should be compatible provided the Python SDK is used to build them and built-in connections APIs are used, rather than any specific connection layers.

Required ports

The following TCP ports must be opened on the server hosting PostgreSQL:

CSS / PostgreSQL release	Listening Port
CSS 4.13.x	2284
CSS 3.0.x	2282
CSS 2.0.x	2280
PostgreSQL ≥ 10.x	Custom port (2282/2284 highly recommended)
PostgreSQL 9.6.11	Custom port (2282 highly recommended)
PostgreSQL 9.2.x	Custom port (2280 highly recommended)