Database Stack (PostgreSQL)

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

Namespace: db
Image: postgres:18-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: pg18-pvc, 5 GiB, Longhorn, ReadWriteOnce.
• Service: pg-svc on port 5432.
• Consumers: n8n, NocoDB, and pgAdmin.
• Backup: Longhorn backup coverage is configured for the database volume.

pgAdmin Management

• Deployment: Kubernetes Deployment managed through ArgoCD.
• Image: dpage/pgadmin4:9.17.
• Access: Internal Traefik route pga.lab.

---

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.