Upgrade PostgreSQL on Docker Compose
Dump your database
Dump your existing database with docker compose exec postgresql pg_dump -U authentik -d authentik -cC > upgrade_backup_12.sql.
Stop your authentik stack
Stop all services with docker compose down.
Backup your existing database
If you use Docker volumes you can run the following command: docker volume create authentik_database_backup && docker run --rm -v authentik_database:/from -v authentik_database_backup:/to alpine sh -c 'cd /from && cp -a . /to'. You can find the name of the authentik_database volume with docker volume ls.
If your data is a file path: cp -a /path/to/v12-data /path/to/v12-backup
Delete your old database
Do not execute this step without checking that the backup (previous step) completed successfully.
If you use Docker volumes: docker volume rm -f authentik_database.
If your data is a file path: rm -rf /path/to/v12-data
Modify your docker-compose.yml file
Update the PostgreSQL service image from docker.io/library/postgres:12-alpine to docker.io/library/postgres:16-alpine.
Add network_mode: none to prevent connections being established to the database during the upgrade.
Recreate the database container
Pull new images and re-create the PostgreSQL container: docker compose pull && docker compose up --force-recreate -d postgresql
Apply your backup to the new database: cat upgrade_backup_12.sql | docker compose exec -T postgresql psql -U authentik
Remove the network configuration setting network_mode: none that you added to the Compose file in the previous step.
Recreate authentik
Start authentik again: docker compose up --force-recreate -d