Error: connect ECONNREFUSED 127.0.0.1:5432

General
14

Hello everyone, please I am having the same issue and have also tried all the proposed solution. I am trying to connect a Nestjs app running in a docker container to a postgre database running in another docker container. Thanks in advance. Below is my docker-compose.yml

version: '3.8'

services:
  nginx:
    image: nginx:latest
    ports:
      - '8080:80'
    volumes:
      - ./nginx.conf:/etc/nginx/nginx.conf:ro

  db:
    container_name: lagbaja-db
    image: postgres:14.7 # match with the latest PostgreSQL version supported by AWS Aurora
    restart: always
    ports:
      - '5433:5432' # specify port forwarding
    environment:
      - POSTGRES_USER=lagbaja
      - POSTGRES_PASSWORD=la2024
      - POSTGRES_DB=lagbaja
    networks:
      - docker-network
    # volumes:
    #   - pgdata:/data/postgres

  dev:
    image: lagbaja-api-dev:1.0.0
    build:
      context: .
      target: development
      dockerfile: ./Dockerfile
    command: npm run start:debug
    ports:
      - '3000'
    volumes:
      - .:/usr/src/app
      - /usr/src/app/node_modules
    restart: always
    environment:            # Add environment variables for the app
      - DATABASE_HOST=db 
    depends_on:
      - db
      - redis
    networks:
      - docker-network

  redis:
    image: 'redis:latest'
    ports:
      - '6379'
    restart: unless-stopped
    networks:
      - docker-network

networks:
  docker-network:
    driver: bridge