Skip to content

v0.1.4

Choose a tag to compare

@7331 7331 released this 05 Nov 12:44
· 35 commits to main since this release

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.example to .env.database-owner (mode 600) and move POSTGRES_PASSWORD into it from .env.
  • In .env, replace <PREFIX>_DATABASE_URL with a new <PREFIX>_APPLICATION_DATABASE_PASSWORD.
  • Run docker compose up -d --build --wait. migrate runs revision 0003, which creates <database>_application and 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_FILE at it.