The init script inside the docker container did not depend on the environment variables that were set in the backend (USERNAME / PASSWORD). This can lead to problems when trying to connect to the database and expecting the same credentials as set in the environment.
No errors where visible because postgre "trusts" connections from localhost by default, hence the backend did not have to authenticate / was allowed to authenticate incorrectly.
Modifications
The first SQL command to alter the role is made dependent on the environment variables.
Verifying this change
[ ] Make sure that the change passes the ./gradlew build checks. (they are not part of these checks I assume)
Motivation
The init script inside the docker container did not depend on the environment variables that were set in the backend (USERNAME / PASSWORD). This can lead to problems when trying to connect to the database and expecting the same credentials as set in the environment.
No errors where visible because postgre "trusts" connections from localhost by default, hence the backend did not have to authenticate / was allowed to authenticate incorrectly.
Modifications
The first SQL command to alter the role is made dependent on the environment variables.
Verifying this change
./gradlew buildchecks. (they are not part of these checks I assume)