Repository navigation
v0.1.4
The API connects as a non-superuser application role, and only postgres and migrate get the superuser credentials.
Update by hand
An app made before v0.1.4 has its API on the superuser. After copier update:
- Copy
.env.database-owner.exampleto.env.database-owner(mode 600) and movePOSTGRES_PASSWORDinto it from.env. - In
.env, replace<PREFIX>_DATABASE_URLwith a new<PREFIX>_APPLICATION_DATABASE_PASSWORD. - Run
docker compose up -d --build --wait.migrateruns revision0003, which creates<database>_applicationand sets its password. The data stays. - In production, put the new file beside the deploy env file, outside the checkout, and point
<PREFIX>_DATABASE_OWNER_ENVIRONMENT_FILEat it.