PgAdmin not working with Postgres container

Question

I am connecting to a postgresql docker service with the following commands :

docker create --name postgres-demo -e POSTGRES_PASSWORD=Welcome -p 5432:5432 postgres:11.5-alpine
docker start postgres-demo
docker exec -it postgres-demo psql -U postgres

I can successfully connect to postgresql conatiner service

Now I want to connect to PgAdmin4 to make some queries to the existing data in postgres database However I keep having this error

The IP address that I am using is the one I extracted from docker inspect DOCKERID

I have restarted the postgresql service on windows but nothing happens. What I am doing wrong ?

Thanks

atline · Accepted Answer · 2020-12-29 04:43:20Z

2

In fact, what you get with docker inspect(172.17.0.2) is just the ip of container, to visit the service in container, you need port binding host's port to container's port.

I see you already used -p 5432:5432 to do it, so please get the ip of host using ip a s, then if you get e.g. 10.10.0.186, then use this host ip to visit the service, use 5432 as a port.

To publish a port for our container, we’ll use the --publish flag (-p for short) on the docker run command. The format of the --publish command is [host port]:[container port]. So if we wanted to expose port 8000 inside the container to port 3000 outside the container, we would pass 3000:8000 to the --publish flag.

A diagram let you know the topologic of docker network, FYI:

answered Dec 29, 2020 at 4:43

atline

32.1k19 gold badges102 silver badges134 bronze badges

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

Comments

Danizavtz · Accepted Answer · 2020-12-28 23:42:26Z

0

You should try to connect to:

host: 0.0.0.0
port: 5432

while your docker container is up and running.

answered Dec 28, 2020 at 23:42

Danizavtz

3,3214 gold badges27 silver badges28 bronze badges

1 Comment

JPV Over a year ago

I needed to close my postgresql service and only have my docker up and running

Collectives™ on Stack Overflow

PgAdmin not working with Postgres container

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related