Issue with PosgreSQL Docker

Docker
#1

Hello,

I have the following docker-compose.yml file:

version: "3.9"
services:
    db:
        image: postgres:9.4
        environment:
            - POSTGRES_PASSWORD=password
    result:
        image: result
        ports:
            - 8080:80

When I execute “docker-compose up” I get the following error and don’t understand why?

root-db-1      | FATAL:  password authentication failed for user "postgres"
root-db-1      | DETAIL:  Connection matched pg_hba.conf line 95: "host all all all md5"
root-result-1  | Waiting for db

If I add “POSTGRES_HOST_AUTH_METHOD=trust” all is OK, but I guess it is an incorrect solution

#2

Hello @linuxmemorywork,
make sure that you define the right password and password

environment:
    POSTGRES_PASSWORD: <password>
    POSTGRES_USER: <user name>

And yes, For simplicity, we use POSTGRES_HOST_AUTH_METHOD=trust to allow passwordless access to Postgres in real production deployment, and that option is not recommended. And instead of that configure proper credentials using POSTGRES_PASSWORD and POSTGRES_USER

Thanks,
KodeKloud Support

#3

For me “postgres” password worked in docker compose. Whereas when creating containers manually “password” password worked.

version: “3”
services:
redis:
image: redis
db:
image: postgres:9.4
environment:
- POSTGRES_PASSWORD=postgres
vote-app:
image: voting-app-img
ports:
- 5000:80
links:
- redis
worker-app:
image: worker-app-img
links:
- redis
- db
result-app:
image: result-app-img
ports:
- 5001:80
links:
- db