Binary & Standalone PostgreSQL Deployment
Deploy the single yearning binary directly with systemd against an existing HA PostgreSQL 14–18 cluster (RDS / Patroni / self-managed).
1. Create PostgreSQL Least-Privilege Roles
In production (environment: production), Yearning enforces database_role_self_check and rejects superuser, CREATEDB, postgres, or migrator roles on the runtime connection:
2. Generate 6-Purpose keyring.json (0400 / 0440 required)
3. Apply Versioned Migrations & db/roles/grants.sql
4. Runtime /etc/yearning/config.yaml & systemd Unit
Start with YEARNING_SCHEMA_MIGRATIONS_DIR=/opt/yearning/db/migrations /opt/yearning/yearning serve --config /etc/yearning/config.yaml --bootstrap-admin-password-file /etc/yearning/secrets/admin-password, verify GET /api/v4/health/ready, and place behind HTTPS Nginx with proxy_buffering off on /api/v4/events/stream.