Error: cannot connect to Postgres. Details: getaddrinfo ENOTFOUND db

[evgeniyworkbel]

I try to run my app on production VPS server via docker-compose, but I get error when running deploy script. How to fix it?

=> ERROR [builder 4/4] RUN corepack enable pnpm && pnpm run deploy;                14.0s
------                                                                                    
 > [builder 4/4] RUN corepack enable pnpm && pnpm run deploy;:                            
1.900 ! Corepack is about to download https://registry.npmjs.org/pnpm/-/pnpm-10.25.0.tgz
3.990 
3.990 > like-volley@0.1.0 deploy /app
3.990 > payload migrate && pnpm build
3.990 
13.45 [17:37:59] ERROR: Error: cannot connect to Postgres. Details: getaddrinfo ENOTFOUND db
13.45     err: {
13.45       "type": "Error",
13.45       "message": "getaddrinfo ENOTFOUND db",
13.45       "stack":
13.45           Error: getaddrinfo ENOTFOUND db
13.45               at /app/node_modules/.pnpm/pg-pool@3.10.1_pg@8.16.3/node_modules/pg-pool/index.js:45:11
13.45               at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
13.45               at async connectWithReconnect (/app/node_modules/.pnpm/@payloadcms+db-postgres@3.68.5_payload@3.68.5_graphql@16.12.0_typescript@5.9.3_/node_modules/@payloadcms/db-postgres/src/connect.ts:22:14)
13.45               at async Object.connect (/app/node_modules/.pnpm/@payloadcms+db-postgres@3.68.5_payload@3.68.5_graphql@16.12.0_typescript@5.9.3_/node_modules/@payloadcms/db-postgres/src/connect.ts:58:7)
13.45               at async BasePayload.init (/app/node_modules/.pnpm/payload@3.68.5_graphql@16.12.0_typescript@5.9.3/node_modules/payload/src/index.ts:836:7)
13.45               at async migrate (/app/node_modules/.pnpm/payload@3.68.5_graphql@16.12.0_typescript@5.9.3/node_modules/payload/src/bin/migrate.ts:65:3)
13.45               at async runBinScript (/app/node_modules/.pnpm/payload@3.68.5_graphql@16.12.0_typescript@5.9.3/node_modules/payload/dist/bin/index.js:110:9)
13.45               at async bin (/app/node_modules/.pnpm/payload@3.68.5_graphql@16.12.0_typescript@5.9.3/node_modules/payload/dist/bin/index.js:44:29)
13.45               at async start (file:///app/node_modules/.pnpm/payload@3.68.5_graphql@16.12.0_typescript@5.9.3/node_modules/payload/bin.js:30:7)
13.45       "errno": -3008,
13.45       "code": "ENOTFOUND",
13.45       "syscall": "getaddrinfo",
13.45       "hostname": "db"
13.45     }
13.46 node:internal/process/promises:392
13.46       new UnhandledPromiseRejection(reason);
13.46       ^
13.46 
13.46 UnhandledPromiseRejection: This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). The promise rejected with the reason "undefined".
13.46     at throwUnhandledRejectionsMode (node:internal/process/promises:392:7)
13.46     at processPromiseRejections (node:internal/process/promises:475:17)
13.46     at process.processTicksAndRejections (node:internal/process/task_queues:106:32) {
13.46   code: 'ERR_UNHANDLED_REJECTION'
13.46 }
13.46 
13.46 Node.js v22.21.1
13.56  ELIFECYCLE  Command failed with exit code 1.
------
Dockerfile:18
--------------------
  16 |     COPY --from=deps /app/node_modules ./node_modules
  17 |     COPY . .
  18 | >>> RUN corepack enable pnpm && pnpm run deploy;
  19 |     
  20 |     # Stage 3: Production server
--------------------
failed to solve: process "/bin/sh -c corepack enable pnpm && pnpm run deploy;" did not complete successfully: exit code: 1

Also I read docs, github discussions, but didn't find good solution. Here is what I read:
https://payloadcms.com/docs/database/migrations
#10676
#4327
https://payloadcms.com/docs/production/deployment

package.json:

{
  "name": "lv",
  "version": "0.1.0",
  "private": true,
  "type": "module",
  "scripts": {
    "dev": "next dev",
    "build": "tsc && next build",
    "start": "next start",
    "deploy": "payload migrate && pnpm build"
  },
  "dependencies": {
    "@hookform/resolvers": "^5.2.2",
    "@payloadcms/db-postgres": "3.68.5",
    "@payloadcms/next": "3.68.5",
    "@payloadcms/richtext-lexical": "3.68.5",
    "@payloadcms/translations": "3.68.5",
    "@payloadcms/ui": "3.68.5",
    "next": "16.1.4",
    "payload": "3.68.5",
    "react": "19.2.3",
    "react-dom": "19.2.3",
  },
}

Dockerfile:

# syntax=docker.io/docker/dockerfile:1

FROM node:22.21.1-alpine3.22 AS base

# Stage 1: Install dependencies
FROM base AS deps
# Check https://github.com/nodejs/docker-node/tree/b4117f9333da4138b03a546ec926ef50a31506c3#nodealpine to understand why libc6-compat might be needed.
RUN apk add --no-cache libc6-compat
WORKDIR /app
COPY package.json pnpm-lock.yaml* ./
RUN corepack enable pnpm && pnpm i --frozen-lockfile;

# Stage 2: Build the application
FROM base AS builder
WORKDIR /app
COPY --from=deps /app/node_modules ./node_modules
COPY . .
RUN corepack enable pnpm && pnpm run deploy;

# Stage 3: Production server
FROM base AS runner
WORKDIR /app
ENV NODE_ENV=production
RUN addgroup --system --gid 1001 nodejs
RUN adduser --system --uid 1001 nextjs
COPY --from=builder /app/public ./public
# Automatically leverage output traces to reduce image size https://nextjs.org/docs/advanced-features/output-file-tracing
COPY --from=builder --chown=nextjs:nodejs /app/.next/standalone ./
COPY --from=builder --chown=nextjs:nodejs /app/.next/static ./.next/static

USER nextjs
EXPOSE 3000
ENV PORT=3000
# server.js is created by next build from the standalone output
# https://nextjs.org/docs/pages/api-reference/config/next-config-js/output
ENV HOSTNAME="0.0.0.0"
CMD ["node", "server.js"]

docker-compose.yml:

services:
  web:
    build: .
    restart: unless-stopped
    ports:
      - "127.0.0.1:3000:3000"
    environment:
      - NODE_ENV=production
      - POSTGRES_URL=${POSTGRES_URL}
      - PAYLOAD_SECRET=${PAYLOAD_SECRET}
    depends_on:
      - db
    networks:
      - my_network

  db:
    image: postgres:18.1-alpine3.23
    restart: unless-stopped
    shm_size: 128mb
    ports:
      - "5432:5432"
    environment:
      - POSTGRES_USER=${POSTGRES_USER}
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
      - POSTGRES_DB=${POSTGRES_DATABASE}
    volumes:
      - pgdata:/var/lib/postgresql
    networks:
      - my_network

volumes:
  pgdata:

networks:
  my_network:
    name: my_network
    driver: bridge

.env:
POSTGRES_USER=root
POSTGRES_PASSWORD=somepassword
POSTGRES_HOST=db:5432
POSTGRES_DATABASE=like-volley-db
POSTGRES_URL=postgres://$POSTGRES_USER:$POSTGRES_PASSWORD@$POSTGRES_HOST/$POSTGRES_DATABASE
PAYLOAD_SECRET=somesecret

[LuizEdgar]

I got the same, anyone able to help?

It works when I'm using a database outside the docker, but when it's a local docker database it fails like that.

[gb3335]

[evgeniyworkbel]

Here I wanna get help from real people who understand hot to work CI/CD, Docker, Nextjs, PayloadCMS. Your AI answer contained errors and it didin't work. Please remove it to not flood