Docker Compose PostgreSQL environment variables, explained

Set POSTGRES_PASSWORD, USER and DB in Docker Compose the right way: a working .env file, why a new password gets ignored, and how to fix each error.