how to change Postgresql docker image password

Question

I have created a Postgresql docker image using the following command on Windows:

docker run --name airdb-postgres -e POSTGRES_PASSWORD=post1234 -d -p 5432:5432 postgres:alpine

is it possible to change the password I assigned to it, or I should create a new one by disposing this image?

Name of the environment variable is PGPASSWORD not POSTGRES_PASSWORD (of course provided that there is already a user with this password). However can you please elaborate on what exactly you are trying to do? — mic4ael
– mic4ael, Commented Oct 31, 2019 at 13:02
I wasn't sure how it is possible to change the password of a postgresql docker image. I realized I can do it after logging into the container @mic4ael . — brainoverflow
– brainoverflow, Commented Oct 31, 2019 at 14:30

Hassan Faghihi · Accepted Answer · 2022-09-08 06:50:27Z

21

You should be able to do that by logging into the container

docker exec -it <container_id> bash

then use psql cli to change the password.

See How to change PostgreSQL user password? for the latter part.

edited Sep 8, 2022 at 6:50

Hassan Faghihi

2,0692 gold badges42 silver badges59 bronze badges

answered Oct 31, 2019 at 13:26

msrc

8211 gold badge13 silver badges22 bronze badges

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

3 Comments

NessDan Over a year ago

I get: > psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist

msrc Over a year ago

@NessDan what command gave you that error?

bleuthoot Over a year ago

@NessDan By default, it will log you in as a the user you are using if you do not have any arguments specified. Which, if you connect to the database using the docker exec command, will be root. You can specify the database name and the username within the psql command. Example: psql mydatabase myuser. See psql --help for more information about the command.

lastlink · Accepted Answer · 2023-04-06 20:43:28Z

5

When I was upgrading postgres 12 to 15 for some reason my user passwords weren't working after the backup and restore. I was able to change fix it by doing the following. On windows I used git bash to run these commands.

bash

cat reset_password.sql | docker exec -i your-db-container-id psql -U postgres

reset_password.sql

ALTER USER postgres WITH PASSWORD 'mysecretpassword';

ALTER USER oc_admin WITH PASSWORD 'mysecretpassword';

answered Apr 6, 2023 at 20:43

lastlink

1,8302 gold badges26 silver badges34 bronze badges

2 Comments

Saaru Lindestøkke Dec 23, 2024 at 12:58

Just as extra info: your problem was likely caused by the change in default password encryption from md5 to scram-sha-256 dbod-user-guide.web.cern.ch/instance_management/…

Pieter Jan 22 at 11:56

Thanks worked for me, just had to change postgres to my user.

Collectives™ on Stack Overflow

how to change Postgresql docker image password

2 Answers 2

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related