How do I connect pgadmin with postgres after installed by docker?

Question

This is my docker-compose.yml

services:

    db:
        container_name: postgres
        image: postgres:latest
        restart: always
        environment:
            POSTGRES_USER: root
            POSTGRES_PASSWORD: root
            POSTGRES_DB: test_db
    pgadmin:
        container_name: pgadmin
        image: dpage/pgadmin4
        restart: always
        environment: 
            PGADMIN_DEFAULT_EMAIL: [email protected]
            PGADMIN_DEFAULT_PASSWORD: admin123
        ports:
            - 8002:80

Pg-admin is running in port 8002

To connect pgsql with pgadmin I have used below credential to add new server in pgadmin, I am getting below error,

How do I will map this connection ?

In docker panel it's showing postgres is running

My operating system : Mac m1.

Few things to check, is postgres running, if it is running is the Port open if you are not listening in the loopback device, if you are not listening in loopback you might need to edit your pg_hba.conf. if your postgres is using a stocket you need to Connect to the socket not the nic with 127.0 0.1 or your external up. — Markus Rosjat
– Markus Rosjat, Commented Jun 19, 2021 at 18:05

JRichardsz · Accepted Answer · 2021-06-19 18:38:42Z

1

When you using more than one container and there are related, localhost not works.

Instead of localhost set the ip of the host in which your postgress is running.

Read these topics to understand ip vs localhost in docker

edited Jun 19, 2021 at 18:38

answered Jun 19, 2021 at 18:30

JRichardsz

16.9k9 gold badges70 silver badges118 bronze badges

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

Collectives™ on Stack Overflow

How do I connect pgadmin with postgres after installed by docker?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related