Authentication error when connecting to Postgres in a Docker container

Question

I'm getting the following error when I try to connect to a Postgres database inside a Docker container. I'm using pgAdmin 4 on windows as my client.

Password does not match for user "postgres".

My docker-compose file is as follows:

version: "3"
services:
  db:
    image: postgres
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=postgres
      - POSTGRES_DB=postgres
    ports:
      - "5433:5432"
    volumes:
      - pgdata:/var/lib/postgresql/data
volumes: 
  pgdata:

Not sure what I'm doing wrong. The file states that the username and password are both postgres. I was able to connect when I just docker run the image. Now I'm using the compose file I seem to be getting this problem.

Remotec · Accepted Answer · 2017-10-14 21:41:45Z

4

Fixed by doing the following:

Stopped container.
Removed container.
Removed volume.

Volume must have contained previous configuration.

answered Oct 14, 2017 at 21:41

Remotec

10.8k28 gold badges118 silver badges161 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Pavel Agarkov Over a year ago

For me it didn't work even if you are right. Looks like old password has been stored somewhere deeper. So I had to change password back... And then connect to the running container and change it through alter user

Remotec Over a year ago

The key seemed to be removing the container and volume to completely clear it up.

Collectives™ on Stack Overflow

Authentication error when connecting to Postgres in a Docker container

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related