Static Page Generation on Build With Postgres Dependency in Docker

[tariwiencke]

Summary

How to get data from postgres on build time to generate static pages? It works just fine with standalone export WITHOUT docker. When using a Dockerfile to create the image it breaks: Error: P1001: Can't reach database server at postgres:5432.

Additional information

docker-compose.yml

services:
    db:
        image: postgres
        restart: always
        environment:
            POSTGRES_PASSWORD: xx
            POSTGRES_USER: xx
        ports:
            - 5432:5432

    next-app:
        container_name: next-app
        build:
            context: .
            dockerfile: Dockerfile
            args:
                POSTGRES_URL: ${POSTGRES_URL}
        env_file:
            - .env
        restart: always
        ports:
            - 3000:3000

    minio:
        image: minio/minio
        environment:
            MINIO_ACCESS_KEY: xx
            MINIO_SECRET_KEY: xx
        ports:
            - 9000:9000
            - 9090:9090
        volumes:
            - minio-data:/data
            - minio-config:/root/.minio
        command: server /data --console-address ":9090"

volumes:
    minio-data:
    minio-config:

Dockerfile

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

FROM node:18-alpine AS base
RUN apk add --no-cache openssl
# Step 1. Rebuild the source code only when needed
FROM base AS builder

WORKDIR /app

# Install dependencies based on the preferred package manager
COPY package.json yarn.lock* package-lock.json* pnpm-lock.yaml* .npmrc* ./
# Omit --production flag for TypeScript devDependencies
RUN \
  if [ -f yarn.lock ]; then yarn --frozen-lockfile; \
  elif [ -f package-lock.json ]; then npm ci --legacy-peer-deps; \
  elif [ -f pnpm-lock.yaml ]; then corepack enable pnpm && pnpm i; \
  # Allow install without lockfile, so example works even without Node.js installed locally
  else echo "Warning: Lockfile not found. It is recommended to commit lockfiles to version control." && yarn install; \
  fi

COPY src ./src
COPY public ./public
COPY next.config.ts .
COPY tsconfig.json .
COPY prisma ./prisma

# Environment variables must be present at build time
# https://github.com/vercel/next.js/discussions/14030

ARG POSTGRES_URL
ENV POSTGRES_URL=${POSTGRES_URL}

# Next.js collects completely anonymous telemetry data about general usage. Learn more here: https://nextjs.org/telemetry
# Uncomment the following line to disable telemetry at build time
# ENV NEXT_TELEMETRY_DISABLED 1

RUN npx prisma generate
# Build Next.js based on the preferred package manager
RUN \
  if [ -f yarn.lock ]; then yarn build; \
  elif [ -f package-lock.json ]; then npm run build; \
  elif [ -f pnpm-lock.yaml ]; then pnpm build; \
  else npm run build; \
  fi

# Note: It is not necessary to add an intermediate step that does a full copy of `node_modules` here

# Step 2. Production image, copy all the files and run next
FROM base AS runner

WORKDIR /app

# Don't run production as root
RUN addgroup --system --gid 1001 nodejs
RUN adduser --system --uid 1001 nextjs
USER 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

# Environment variables must be redefined at run time

# Uncomment the following line to disable telemetry at run time
# ENV NEXT_TELEMETRY_DISABLED 1

# Note: Don't expose ports here, Compose will handle that for us

CMD ["node", "server.js"]

### Example

_No response_