Central database hardware and software requirements - 2022.01 - 2022.02

Central storage for operational Forecast data. One instance per Master Controller. 

Minimum requirements

• Follow database vendor requirements for memory and CPU requirements.
• 4 GB RAM for the database server is required for a small FEWS instance with less than 5 users. 8 GB or more for larger systems.
• The database instance(s) can be hosted on an existing database server or cluster.
• See also Database connection count calculator

The Delft-FEWS client-server system is known to run with the following database versions:

Oracle

• Oracle 19c, 21c
• See https://support.oracle.com/knowledge/Oracle%20Database%20Products/742060_1.html

PostgreSQL

• PostgreSQL 11, 12, 13
• See https://endoflife.date/postgresql
• The maximum size for PostgreSQL database fields in Delft-FEWS is 1 GB. As a result all big files such as Module config files and ColdStates must respect this limit. WarmStates exceeding this size can be stored externally on the file system.

SQLServer

• MS SQL Server 2016 / 2019.
• Managed instances are possible, but In-Memory OLTP is required, see https://learn.microsoft.com/en-us/azure/azure-sql/in-memory-oltp-overview?view=azuresql.
• See https://endoflife.date/mssqlserver
• The maximum size for SQLServer database fields in Delft-FEWS is 2 GB. As a result all big files such as Module config files and ColdStates must respect this limit. WarmStates exceeding this size can be stored externally on the file system.