We have a serious permission problem, as the notifications_backend table is owned by user but the extension needs to be created as superuser. The app is connection to postgres as user as well and thus the migration can’t run

We could use the db superuser connection to run flyway and then for normal operation with the reactive client log in as 'user' to run with lower credentials.

{pre}
Migration V1.0.0__notifications.sql failed
------------------------------------------
SQL State : 42501
Error Code : 0
Message : ERROR: permission denied to create extension "pgcrypto"
Hint: Must be superuser to create this extension.
Location : db/migration/V1.0.0__notifications.sql (/deployments/file:/deployments/notifications-backend-1.0.0-SNAPSHOT-runner.jar!/db/migration/V1.0.0__notifications.sql)
Line : 23
Statement : CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA public{pre}