@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
STATE: pending — awaiting provisioning
@claude
Request
Please ensure the following are provisioned on the shared FuzeInfra Postgres cluster (Contabo k3s,
fuzeinfra-postgres.fuzeinfra.svc.cluster.local:5432):fuzesocialfuzesocial_appCONNECTonfuzesocial,CREATE/SELECT/INSERT/UPDATE/DELETEon all tables inpublicschema,USAGE/SELECTon all sequencesContext
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 asfuzesocial_app(viaDB_PASSWORDSealedSecret) to applyschema.sqlandseed.sql. It requires the DB and role to already exist at sync time.The password for
fuzesocial_appshould be delivered as a GitHub Actions secretFUZESOCIAL_DB_PASSWORDon theizzywdev/FuzeSocialrepo (never in this issue).Acceptance
fuzesocialdatabase exists on the shared Postgresfuzesocial_approle exists with the above permissionsFUZESOCIAL_DB_PASSWORDGH Actions secret is set onizzywdev/FuzeSocialkubectl -n fuzesocial logs job/fuzesocial-db-bootstrap) completes successfullySTATE: pending — awaiting provisioning