Postgres: mispelling of docker-compose evironment variable POSTGRES_PASSWORD

[Matthias-Schaub]

In docker-compose.yaml POSTRES_PASSWORD had a typo during first deployment.
The consequence of this was no password for postgres.
When no password is provided the docker postgres instance will set the authentication method in pg_hba.conf to "trust" (host all all all trust) which disabled the password checks for all users, even if a password will added later on (ALTER USER username WITH PASSWORD 'password').

See open issue of docker-library/postgres describing this behavoir in more detail: docker-library/postgres#580

[Matthias-Schaub]

Resolved by changing pg_hba.conf inside the container and restarting postgres docker container.