Data Tier Prerequisites

Estimated reading: 2 minutes

This section outlines the database and data storage requirements for Robility Flow. The data tier is responsible for storing workflow definitions, execution metadata, user and role information, configuration settings, audit records, and operational data generated by the platform. To ensure reliability, performance, and data integrity, the underlying database infrastructure must meet the following prerequisites.

PostgreSQL

PostgreSQL serves as the primary relational database for Robility Flow and stores critical platform information including workflow definitions, execution history, user accounts, variables, application configurations, and audit records.

Parameter	Requirement
Engine & Version	PostgreSQL 15 or higher.
Database Name	`robilityflow` database must be pre-created and empty prior to deployment.
Service Account	Dedicated database login with CREATE privileges, `db_owner`-equivalent permissions, and DDL rights required for schema creation and updates.
Connection String	Must be supplied securely through a Kubernetes Secret or Docker environment variable and should not be hardcoded in application configuration files.
SSL / TLS	SSL encryption is required for all database connections using settings such as `sslmode=require` or `sslmode=verify-full`.
Backup Policy	Daily automated backups must be configured with a minimum retention period of 7 days. A 30-day retention period is recommended for production environments.
High Availability	Multi-AZ deployment or streaming replication is recommended for Kubernetes production environments. For VM-based deployments, `pg_basebackup` or an equivalent replication strategy is recommended.

Redis

Redis is used for session caching, real-time execution event pub/sub, and as the task-queue broker for asynchronous flow execution.

1. Version: Redis 7.0 or higher
2. Persistence: AOF (appendonly yes) enabled; RDB snapshots recommended
3. Authentication: AUTH password required; provide via Kubernetes Secret or Docker environment variable
4. TLS: Enable TLS on the Redis connection for production deployments
5. Cluster mode: Required for Kubernetes production (minimum 3 primary nodes + 3 replicas); single-node acceptable for VM deployments

Data Tier Prerequisites

PostgreSQL

Redis

Data Tier Prerequisites

CONTENTS