使用NextJS+Prisma连接AWS RDS Postgres时无法访问数据库服务器

技术栈 #

• NextJS
• Prisma
• PostgreSQL（AWS RDS）
• Docker

问题描述 #

手动可正常连接AWS RDS Postgres数据库，但代码执行时出现无法访问数据库服务器的错误。已通过环境变量DATABASE_URL配置连接地址，格式为postgresql://USER:PASSWORD@HOST:5432。

Prisma Schema配置 #

generator client {
  provider = "prisma-client-js" 
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

完整错误日志 #

next-1   | Failed to sync db: getaddrinfo EAI_AGAIN postgresdb
next-1   | prisma:error 
next-1   | Invalid `prisma.user.findUnique()` invocation:
next-1   | 
next-1   | 
next-1   | Can't reach database server at `postgres`:`5432`
next-1   | 
next-1   | Please make sure your database server is running at `postgres`:`5432`.
next-1   | ERR Error: 
next-1   | Invalid `prisma.user.findUnique()` invocation:
next-1   | 
next-1   | 
next-1   | Can't reach database server at `postgres`:`5432`
next-1   | 
next-1   | Please make sure your database server is running at `postgres`:`5432`.
next-1   |     at RequestHandler.handleRequestError (/app/node_modules/@prisma/client/runtime/index.js:31955:13)
next-1   |     at RequestHandler.handleAndLogRequestError (/app/node_modules/@prisma/client/runtime/index.js:31913:12)
next-1   |     at /app/node_modules/@prisma/client/runtime/index.js:32458:25
next-1   |     at async PrismaClient._executeRequest (/app/node_modules/@prisma/client/runtime/index.js:33022:22)
next-1   |     at async PrismaClient._request (/app/node_modules/@prisma/client/runtime/index.js:32994:16)
next-1   |     at async Object.createUser (/app/.next/server/pages/api/graphql.js:1:15549)
next-1   |     at async Object.signup (/app/.next/server/pages/api/graphql.js:1:2170)
next-1   |     at async file:///app/node_modules/@envelop/core/esm/orchestrator.js:373:27
next-1   |     at async YogaServer.getResultForParams (file:///app/node_modules/graphql-yoga/esm/server.js:270:26)
next-1   |     at async YogaServer.getResponse (file:///app/node_modules/graphql-yoga/esm/server.js:336:23) {
next-1   |   path: [ 'signup' ],
next-1   |   locations: [ { line: 8, column: 5 } ],
next-1   |   extensions: [Object: null prototype] {}
next-1   | }

已尝试的DATABASE_URL格式（均无效） #

DATABASE_URL="postgresql://USER:PASSWORD@HOST:5432/postgres"

DATABASE_URL="postgresql://USER:PASSWORD@HOST:5432/postgres?connect_timeout=300"

DATABASE_URL="postgresql://USER:PASSWORD@HOST:5432/postgres?schema=public"

从错误日志可见，代码实际在尝试连接postgres:5432而非配置的AWS RDS地址，核心问题是环境变量未正确传递到Docker容器内，或容器内变量被覆盖。

1. 修正Docker环境变量配置 #

• 若用docker run启动容器，需通过-e DATABASE_URL="你的AWS RDS完整连接地址"参数明确传递变量，主机地址填RDS的端点（如xxx.rds.amazonaws.com），而非postgres。
• 若用docker-compose.yml，在服务的environment字段中配置变量：

  services:
    next:
      build: .
      environment:
        - DATABASE_URL=postgresql://USER:PASSWORD@<RDS端点>:5432/postgres?schema=public
      ports:
        - "3000:3000"
  

2. 验证容器内环境变量 #

进入运行中的NextJS容器，执行echo $DATABASE_URL，确认输出为正确的AWS RDS地址。若输出错误，重新检查变量传递配置。

3. 检查网络与安全组 #

• AWS RDS安全组需允许容器所在IP（本地公网IP或VPC内网IP）访问5432端口。
• 本地环境可通过telnet <RDS端点> 5432测试端口连通性，确保网络无阻断。

4. 重新生成Prisma Client #

修改环境变量后，进入容器执行npx prisma generate，确保Prisma Client加载最新配置。

内容的提问来源于stack exchange，提问作者Gabriel Velozo