Skip to content

TASK: Provision the Auth Service SIT persistence database #214

Closed
1 of 1 issue completed
Closed

Description

@ramioooz

Objective

Add the missing auth_service logical database to the shared PostgreSQL chart used by digital-bank-sit. Auth Service session persistence is merged and requires this database before SIT rollout.

Scope

  • Add auth_service to the chart database initialization list.
  • Keep the existing mfa_service entry and all current databases unchanged.
  • Validate Helm lint and rendered PostgreSQL initialization configuration.
  • Do not add credentials or secret values.

Dependencies

Acceptance Criteria

  • A fresh or upgraded SIT PostgreSQL release creates auth_service when absent.
  • Existing databases remain unchanged and initialization remains idempotent.
  • Helm lint and template validation pass.

This is a local SIT prerequisite; AWS database provisioning remains deferred to Sprint 7.

Activity

  1. self-assigned this
    on Sep 4, 2026
  2. added theissue type on Sep 4, 2026
  3. ramioooz commented on Sep 4, 2026

    @ramioooz
    MemberAuthor

    Implementation PR: infra-sit#31

    The shared PostgreSQL chart now includes auth_service and reconciles all configured logical databases on Helm install and upgrade, including existing persistent volumes. The PR is non-draft and awaiting review; no fixed delay is required after merge, but PostgreSQL must be upgraded before Auth Service rollout.

  4. ramioooz commented on Sep 4, 2026

    @ramioooz
    MemberAuthor

    Current SIT evidence - 2026-09-05

    • PostgreSQL pod postgres-0 is 1/1 Ready and the existing data-postgres-0 PVC is Bound.
    • A read-only query using the existing Kubernetes Secret through PGPASSWORD confirmed these logical databases exist: account_service, customer_service, ledger_service, mfa_service, notification_service, payment_service, and transaction_service.
    • auth_service is still absent, so this task remains open.
    • The database-init hook fix is tracked by infra-sit#33; after it merges, retry the PostgreSQL Helm upgrade and verify auth_service is created.

    No credential values were printed or recorded.

  5. ramioooz commented on Sep 4, 2026

    @ramioooz
    MemberAuthor

    Completion evidence - 2026-09-05

    • Merged implementation: infra-sit#31.
    • Retried the PostgreSQL Helm upgrade in digital-bank-sit using the merged database-init password wiring.
    • Helm release postgres is deployed at revision 5.
    • The post-upgrade database-init hook completed successfully and was removed by its hook-succeeded policy.
    • PostgreSQL remains 1/1 Ready with the existing persistent volume; no PVC or data replacement was performed.
    • Read-only verification confirmed the expected logical databases, including auth_service: account_service, auth_service, customer_service, ledger_service, mfa_service, notification_service, payment_service, postgres, and transaction_service.

    No credentials or secret values were printed or recorded.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions