Skip to content

Validate API ↔ PostgreSQL connectivity and migrations #99

@imrightguy

Description

@imrightguy

Ensure the api-backend can connect to PostgreSQL and schema is applied.

Acceptance Criteria

  • api-backend pod logs show successful DB connection
  • api-backend responds to a DB-backed endpoint or migration check
  • No CrashLoopBackOff due to DB connection

Implementation Details

  • Confirm DB_HOST=postgresql.cloudtolocalllm.svc.cluster.local and credentials from api-secrets
  • kubectl port-forward to DB or use psql client in a debug pod to verify connectivity
  • Run services/api-backend/database/migrate-pg.js if needed

Dependencies

  • Helm PostgreSQL deployed and Ready
  • api-secrets contains db-password matching Helm secret

Effort: S (2–4 hours)
Priority: P0

Testing & Validation

  • kubectl logs deployment/api-backend -n cloudtolocalllm
  • curl API endpoints that hit DB
  • psql auth with secret values

Related to #96 (Phase 1 Epic)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions