Password does not match for user "postgres"

Question

I am trying to raise a service in my docker-compose to use postgres, I can raise the container correctly, the problem is that it does not allow me to authenticate with the password that I am setting in the environment variables

this is my docker-compose service:

version: "3"
services:
  api:
    build:
      context: .
      dockerfile: docker/nodejs/Dockerfile
    ports:
      - "3000:3000"
    volumes:
      - .:/app
    links:
      - postgresql

  postgresql:
    image: postgres:11-alpine
    restart: always
    environment:
      POSTGRES_PASSWORD: 00000000
    volumes:
      - ~/docker/postgresql:/var/lib/postgresql/data
    ports:
      - "5432:5432"

what can be the problem here? i trying to get in with pgadmin. In the console show me the error:

password authentication failed for user "postgres"
Password does not match for user "postgres".

I am not sure but here's an example of a compose file that has postgres and pgadmin working together if it's of any help: github.com/ruairitobrien/docker-dev-setup-example/blob/master/… — Ruairi O'Brien
– Ruairi O'Brien, Commented Feb 19, 2019 at 18:01

camba1 · Accepted Answer · 2020-06-20 06:09:31Z

9

The Postgres password is set on the first initialization if the db (when the var/lib/postgresql/data folder is empty). Since you probably ran docker-compose before with a different password, the new one will not take effect. To fix this, remove the volume in your host machine and have docker-compose automatically recreate it next time you run docker-compose up. Note that removing this volume will delete all data stored in PostgreSQL

answered Jun 20, 2020 at 6:09

camba1

1,8302 gold badges14 silver badges18 bronze badges

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

Comments

Midriaz · Accepted Answer · 2021-02-22 10:27:34Z

2

Another way to fail with POSTGRES_PASSWORD is to set a password with forbidden characters. You won't get any warnings, but you won't be able to login with this password.

answered Feb 22, 2021 at 10:27

Midriaz

1901 silver badge8 bronze badges

Comments

dfundako · Accepted Answer · 2020-06-20 00:14:59Z

0

This might have to do with your volumes. Try pruning your volumes and then bring up your containers again. MAKE SURE YOU DON'T NEED THE VOLUMES BEFORE YOU PRUNE THEM!

To see what existing volumes you have

docker volume ls

And then clear them out if you can

docker volume prune

answered Jun 20, 2020 at 0:14

dfundako

8,3643 gold badges21 silver badges36 bronze badges

Comments

Giga Kokaia · Accepted Answer · 2020-04-28 12:12:07Z

-1

If you are not runing it first time, you could already change it. You can manualy edit pg_hba.conf file and set trust authorisation type

answered Apr 28, 2020 at 12:12

Giga Kokaia

9698 silver badges16 bronze badges

Collectives™ on Stack Overflow

Password does not match for user "postgres"

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related