Skip to content

Provision fuzesocial DB + fuzesocial_app role on shared Postgres #149

Description

@izzywdev

@claude

Request

Please ensure the following are provisioned on the shared FuzeInfra Postgres cluster (Contabo k3s, fuzeinfra-postgres.fuzeinfra.svc.cluster.local:5432):

Resource Details
Database fuzesocial
Role fuzesocial_app
Permissions CONNECT on fuzesocial, CREATE/SELECT/INSERT/UPDATE/DELETE on all tables in public schema, USAGE/SELECT on all sequences

Context

FuzeSocial (repo: izzywdev/FuzeSocial) is a new consumer of the shared FuzeInfra Postgres. Per the consumer onboarding guidelines, FuzeSocial must NOT hold the superuser credentials — DB + role provisioning is FuzeInfra's responsibility.

The FuzeSocial Helm chart (deploy/helm/fuzesocial/) has a pre-sync bootstrap Job that connects as fuzesocial_app (via DB_PASSWORD SealedSecret) to apply schema.sql and seed.sql. It requires the DB and role to already exist at sync time.

The password for fuzesocial_app should be delivered as a GitHub Actions secret FUZESOCIAL_DB_PASSWORD on the izzywdev/FuzeSocial repo (never in this issue).

Acceptance

  • fuzesocial database exists on the shared Postgres
  • fuzesocial_app role exists with the above permissions
  • FUZESOCIAL_DB_PASSWORD GH Actions secret is set on izzywdev/FuzeSocial
  • FuzeSocial bootstrap Job (kubectl -n fuzesocial logs job/fuzesocial-db-bootstrap) completes successfully

STATE: pending — awaiting provisioning

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