PostgreSQL Database

PostgreSQL serves as the centralized relational database for HALO, providing data persistence for workflows, user profiles, and system state.

Overview

PostgreSQL 16.4 runs as a containerized service within Nexus, offering:

• Schema Isolation: Separate schemas for each service
• Transaction Safety: ACID compliance for data integrity
• JSON Support: Native JSON/JSONB for flexible data structures
• Full-Text Search: Built-in search capabilities
• Extensions: PostGIS, pg_trgm, and other extensions

Schema Organization

The database uses schema-based isolation for service separation:

• n8n: Workflow definitions and execution history
• omnia: Widget configurations and user profiles (planned)
• apollo: Conversation context and memory (planned)

Configuration

PostgreSQL configuration is managed through:

• Docker Compose file: nexus/compose/postgres.yml
• Environment variables for credentials
• Volume mounts for data persistence
• Health checks for availability monitoring

Backup Strategy

Database backups are handled through:

• Automated snapshots via n8n workflows
• Encrypted backup storage
• Point-in-time recovery capability (planned)

Access Control

Database access is restricted through:

• dbnet Docker network isolation
• Service-specific credentials
• Schema-level permissions
• Connection pooling for efficiency

See Also

• Nexus Overview - Infrastructure architecture
• Container Reference - PostgreSQL container details
• Data & Backups - Database backup strategies
• n8n Workflows - Workflow data persistence