Database Stack (PostgreSQL)

The database stack provides persistence for automation tools and data management platforms.

Namespace: db
Image: postgres:16-alpine

---

1. Overview

Persistence for n8n and NocoDB is provided by the PostgreSQL stack. Web-based GUI management is facilitated through pgAdmin.

---

2. Component Configuration

PostgreSQL Engine

• Storage: Persistent Volume Claims (PVC) via Longhorn are utilized.
• Backup: Automated daily dumps are performed to block storage.

pgAdmin Management

• Deployment: Standard Helm chart deployment.
• Access: Restricted via internal VPN or authenticated proxy.

---

3. Operational Standards

Procedures for database maintenance:

1. Initialization: Database schemas are provisioned during application startup.
2. Performance: Resource limits (CPU/RAM) are enforced via Kubernetes quotas.
3. Logs: Standard output logs are aggregated for troubleshooting.