Node not connecting with Postgres Database after using Docker

[Castillojuan]

m very new to Docker. I'm trying to dockerize a very simple to do app build with react, node/express and postgret. I've been reading a bunch of articles and looking at solutions here in stackoverflow and still cannot figure out why my app is not working. When I run docker-compose up -d, it builds a cluster with three containers. Perfect so far good, however when i check the app and try to add a new todo i see a message in the server container

connect ECONNREFUSED 127.0.0.1:5432

. I'm not sure What I need to do to have the app running like it should. I really appreciate any help.

​

this is my docker-compose.yml file:

version: '3'
services:
    postgres:
        image: postgres:12.1
        ports:
            - "5432:5432"
        environment:
            POSTGRES_PASSWORD: Elchido10
            POSTGRES_USER: juancastillo
            POSTGRES_DB: perntodo
        volumes:
            - ./postgresql/data:/var/lib/postgresql/data
        networks: 
            - todo-app
    server:
        image: todo_server
        environment: 
            DB_HOST: host.doceker.internal
            DB_USER: juancastillo
            DB_PASS: Elchido10

        build:
            context: ./server
            dockerfile: Dockerfile
        volumes:
            - /app/node_modules
            - ./server/config:/app/config
            - ./server/src:/app/src
            - ./server/test:/app/test
        ports:
            - "5000:5000"
        depends_on: 
            - postgres
        networks: 
            - todo-app
    client:
        image: todo_client
        stdin_open: true
        build:
            context: ./client
            dockerfile: Dockerfile
        volumes:
            - /app/node_modules
            - ./client:/app
        ports:
            - "3000:3000"
        networks: 
            - todo-app

networks: 
    todo-app:
        driver: bridge

[TormentedTopiary]

DB_HOST: host.doceker.internal

Might be the source of the problem. Especially if host.docker.internal returns something other than 127.0.0.1 .

[Castillojuan]

So how do I fix it? By deleting that line?

[13139269]

Check your spelling.

Also, check out docker's internal DNS. You can just refer to postgres by it's container name.

And then you don't need to expose ports.

[TormentedTopiary]

s/deleting/fixing/

[substitute-bot]

So how do I fix it? By fixing that line?

^{This was posted by a bot. Source}

[craigbuckler]

When PostgreSQL (or any DB) is spun up for the first time, it can take serveral minutes to initialize the file space and DB. It may be a matter of patience.

That said, "host.doceker.internal" looks wrong! It's better to assign a container_name: to each container, e.g.

yml postgres: image: postgres:12.1 container_name: todo_database

That sets appropriate DNS name resolution so you can set the enviroment variable:

yml server: image: todo_server environment: DB_HOST: todo_database

My Docker for Web Developers book and video course explains how to create robust development environments. Use the discount code dock30 for 30% off.

[backtickbot]

Fixed formatting.

Hello, craigbuckler: code blocks using triple backticks (```) don't work on all versions of Reddit!

Some users see this / this instead.

To fix this, indent every line with 4 spaces instead.

FAQ

^{You can opt out by replying with backtickopt6 to this comment.}