POSTGRES_DB and POSTGRES_USER don't work in Docker run

Question

So I am running the following command:

docker run --name psql-instance -d -p 5432:5432 -e POSTGRES_DB=mydb -e POSTGRES_USER=root -e POSTGRES_PASSWORD=pass postgres

This creates the container.

However when I run:

docker exec -it psql-instance psql -U root

I get the following error:

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

I've seen many similar questions and they all say its docker-compose causing the error for them and that docker run works fine but for me, docker run doesn't work.

How can I fix this?

Hans Kilian · Accepted Answer · 2023-02-02 08:41:04Z

2

You need to tell psql to connect to the mydb database like this

docker exec -it psql-instance psql -U root mydb

answered Feb 2, 2023 at 8:41

Hans Kilian

26.6k4 gold badges39 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

POSTGRES_DB and POSTGRES_USER don't work in Docker run

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related