Bitnami postgres image is unsupported

[wes-otf]

The docker container we use for out postgreSQL image is now considered legacy and bitnami seems to be moving to a paid subscription model for their hardened images as per bitnami/containers#83267. The postgresql image we use will still be available via bitnamilegacy/postgresql:17 but will not be receiving updates, thus we should migrate to another solution.

[wes-otf]

I wonder if we could just swap in the official docker postgres image?

[frjo]

We switches to bitnami version since it supports POSTGRESQL_FSYNC and POSTGRESQL_REPLICATION_USE_PASSFILE that improves CI performance.

This should also work:

      postgres:
        image: postgres:17-alpine
        env:
          POSTGRES_USER: hypha
          POSTGRES_PASSWORD: hypha
          POSTGRES_DB: hypha

[frjo]

This has been fixed.