NodeJS Cannot Connect to Postgres at Dockerized Environment

Question

I am trying to run a NodeJS application on Docker. However I get that error:

could not connect to postgres: Error: connect ECONNREFUSED

When I debug the problem I can see that my environment file is considered from the application and I can access the application endpoints until it tries to connect database.

What can be the reason?

This is my docker-compose.yml file:

version: "3.8"

services:
  postgres:
    image:postgres:12.4
    restart: always
    environment:
      POSTGRES_USER: workflow
      POSTGRES_DB: workflow
      POSTGRES_PASSWORD: pass
    ports:
      - "5429:5432"
    expose:
      - 5429
    networks:
      - db

  workflow:
    image:workflow:0.1.0-SNAPSHOT
    environment:
      NODE_ENV: prod
    env_file:
      - ./.env.prod
    logging:
      driver: "json-file"
      options:
        max-size: "10m"
        max-file: "3"
    ports:
      - "3000:3000"
    networks:
      - db
    depends_on:
      - postgres

networks:
  db:

volumes:
  db-data:

This is my Dockerfile:

FROM node:16.14.2

WORKDIR /app

COPY ["package.json", "package-lock.json*", "./"]

RUN npm ci --only=production && npm cache clean --force
COPY . .

CMD [ "npm", "run", "start"]

This is .env.prod file:

PORT=3000
DATABASE_URL=postgresql://workflow:pass@postgres:5429/workflow

Here is the related script from package.json:

"scripts": {
  "start": "npm run migrate up && node src/app.js"
}

This is error output:

workflow_1  | Error: connect ECONNREFUSED 172.21.0.2:5429
workflow_1  |     at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1157:16) {
workflow_1  |   errno: -111,
workflow_1  |   code: 'ECONNREFUSED',
workflow_1  |   syscall: 'connect',
workflow_1  |   address: '172.21.0.2',
workflow_1  |   port: 5429
workflow_1  | }

This is from docker ps command:

CONTAINER ID   IMAGE                 COMMAND                  CREATED          STATUS          PORTS                              NAMES
c8971741b19d  postgres:12.4   "docker-entrypoint.s…"   50 seconds ago   Up 49 seconds   5429/tcp, 0.0.0.0:5429->5432/tcp   workflow_postgres_1

matic1123 · Accepted Answer · 2022-04-29 12:00:08Z

0

Based on the official Dockerfile of the postgres:12.4 database it exposes default port 5432. So unless you changed that port with the pg configuration your application needs to connect to port 5432, not the 5429.

Also based on your

ports:
    - "5429:5432"

section of the docker compose. If you go to the official documentation it is

ports (HOST:CONTAINER)

for the syntax. So you are technically mapping port 5429 to the "outside/host" port. Meanwhile all the internal docker traffic still goes to the port 5432.

answered Apr 29, 2022 at 12:00

matic1123

1,1499 silver badges17 bronze badges

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

4 Comments

kamaci Over a year ago

It should be true? stackoverflow.com/a/37775826/453596

David Maze Over a year ago

Connections between containers completely ignore ports:; you always need to use the standard port number 5432. Compose expose: does absolutely nothing and you can safely delete it.

kamaci Over a year ago

So, I should use command: -p 5429. Are you sure that there is not a way to startup the postgres container from default port but mapping it to a different port for another container?

matic1123 Over a year ago

Yes exactly (is comment on the link, not your ports comment): "Note that only the host will respect the port directive. Other containers will not." So you still need to adjust DATABASE_URL=postgresql://workflow:pass@postgres:5429/workflow to: DATABASE_URL=postgresql://workflow:pass@postgres:5432/workflow and it should work.

thayne · Accepted Answer · 2024-09-23 21:32:28Z

0

The postgres container is set up so you can tell it to run on a different port by setting the PGPORT environment variable.

In docker-compose, you can do this:

environment:
  - PGPORT: 5429

or on command-line:

docker run ... -e "PGPORT=5429" ... postgres:12.4

no need to map ports this way.

answered Sep 23, 2024 at 21:32

thayne

1,14812 silver badges26 bronze badges

Collectives™ on Stack Overflow

NodeJS Cannot Connect to Postgres at Dockerized Environment

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related