PostgreSQL in Docker - access from host

Question

I've been trying to get access to PostgreSQL running in a docker container. I'm able to connect to the PostgreSQL from within the adminer on localhost:8080, which is another container, but I'm not able to connect from my host machine, although I'm mapping the port 5432 to the host machine.

As a container's IP to connect to I've been using an IP address fetched from "docker inspect <postgre_container>" - usually 172.21.0.2/3.

This is what my docker-compose.yml looks like:

version: '3.1'

services:
  db:
    image: postgres:9.6.0
    restart: always
    environment:
      POSTGRES_PASSWORD: root
      POSTGRES_USER: root
    ports:
      - "5432:5432"
    volumes:
      - pgdata:/var/lib/postgresql/data

  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:8080

volumes:
  pgdata:

I'll be glad for any hints, thanks

ely · Accepted Answer · 2017-12-01 16:34:38Z

1

The IP address shown using docker inspect is the internal IP address within the container. Since you are using port mapping with external port 5432, you should access Postgres via localhost:5432 (e.g. 127.0.0.1:5432).

answered Dec 1, 2017 at 16:34

ely

77.8k36 gold badges157 silver badges233 bronze badges

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

1 Comment

MelkorNemesis Over a year ago

Thanks mate, for some reason "localhost" did not work when I was trying to connect to it, but 127.0.0.1 works.

Md. Saifur Rahman · Accepted Answer · 2025-01-07 05:58:31Z

Network

sudo docker network create local_central_db_network

create a file docker-compose.yml

version: '3.3'

services:
  postgres:
    image: postgres:16.4 # Using PostgreSQL version 16.4
    container_name: local-central-db-pgsql-container-16.4
    restart: always
    ports:
      - "5432:5432" # Expose port 5432 for external access
    environment:
      POSTGRES_USER: root # Replace with your username
      POSTGRES_PASSWORD: root # Replace with your password
    volumes:
      - ./dbdata:/var/lib/postgresql/data # Persist data between restarts
    networks:
      - local_central_db_network

networks:
  local_central_db_network:
    external: true

Command : Docker : Setup : Initialized

sudo docker-compose down
sudo docker-compose build && docker-compose up -d

Connect in command line

docker exec -it local-central-db-pgsql-container-16.4 bash
psql -U root
\q

Note: in clients use like this

Collectives™ on Stack Overflow

PostgreSQL in Docker - access from host

2 Answers 2

1 Comment

Network

create a file docker-compose.yml

Command : Docker : Setup : Initialized

Connect in command line

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Network

create a file docker-compose.yml

Command : Docker : Setup : Initialized

Connect in command line

Comments

Related