ASP.NET Core 7.1连接Docker容器内PostgreSQL报错求助

1. 修复Docker Compose网络配置 #

你的server服务未加入db-network网络，导致两个容器无法互相访问。修改docker-compose.yml，为server添加网络配置：

version: '3.8'

services:
  server:
    build: ./Test
    ports:
      - "8000:80"
    depends_on:
      - db
    networks:  # 新增网络配置
      - db-network
  
  db:
    container_name: db
    image: postgres:latest
    environment:
      - POSTGRES_USER=user
      - POSTGRES_PASSWORD=pass
      - POSTGRES_DB=data
    volumes:
      - pgdata:/var/lib/postgresql/data
    ports:
      - "1234:5432"
    networks:
      - db-network
  
networks:
  db-network:
    driver: bridge

volumes:
  pgdata:

2. 添加数据库就绪等待机制 #

depends_on仅保证容器启动顺序，不代表PostgreSQL服务已完全初始化完成。可以通过两种方式解决：

方式一：给PostgreSQL配置健康检查 #

修改db服务，添加健康检查逻辑，让server等待数据库就绪后再启动：

db:
  container_name: db
  image: postgres:latest
  environment:
    - POSTGRES_USER=user
    - POSTGRES_PASSWORD=pass
    - POSTGRES_DB=data
  volumes:
    - pgdata:/var/lib/postgresql/data
  ports:
    - "1234:5432"
  networks:
    - db-network
  healthcheck:  # 新增健康检查
    test: ["CMD-SHELL", "pg_isready -U user -d data"]
    interval: 5s
    timeout: 5s
    retries: 5

同时更新server的depends_on配置：

server:
  build: ./Test
  ports:
    - "8000:80"
  depends_on:
    db:
      condition: service_healthy  # 等待数据库健康检查通过
  networks:
    - db-network

方式二：在ASP.NET中添加连接重试 #

在Program.cs配置DbContext时，添加连接失败重试策略（需先安装Microsoft.EntityFrameworkCore.Relational包）：

builder.Services.AddDbContext<YourDbContext>(options =>
    options.UseNpgsql(builder.Configuration.GetConnectionString("Data"),
        sqlOptions => sqlOptions.EnableRetryOnFailure(
            maxRetryCount: 5,
            maxRetryDelay: TimeSpan.FromSeconds(10),
            errorCodesToAdd: null)));

3. 验证基础配置细节 #

• 确认appsettings.json中的连接字符串参数（用户名、密码、数据库名）与Docker Compose中POSTGRES_*环境变量完全一致
• 容器间通信使用PostgreSQL容器内部端口5432，而非宿主机映射的1234，你的连接字符串配置这部分是正确的
• 检查启动命令拼写：你输入的docke-compose.yml存在笔误，正确命令应为docker-compose -f docker-compose.yml up --build

4. 确认应用镜像构建正确性 #

确保Test目录下的Dockerfile能正确构建ASP.NET Core 7.1应用，示例Dockerfile如下：

FROM mcr.microsoft.com/dotnet/aspnet:7.0 AS base
WORKDIR /app
EXPOSE 80

FROM mcr.microsoft.com/dotnet/sdk:7.0 AS build
WORKDIR /src
COPY ["Test.csproj", "./"]
RUN dotnet restore "./Test.csproj"
COPY . .
WORKDIR "/src/."
RUN dotnet build "Test.csproj" -c Release -o /app/build

FROM build AS publish
RUN dotnet publish "Test.csproj" -c Release -o /app/publish /p:UseAppHost=false

FROM base AS final
WORKDIR /app
COPY --from=publish /app/publish .
ENTRYPOINT ["dotnet", "Test.dll"]

完成以上修改后重新启动容器，问题即可解决。

内容的提问来源于stack exchange，提问作者Isaac Cooke