How to connect an ASP.NET backend to a postgres database inside a docker container

Question

I have been trying to connect my webapi built in ASP.NET Core 7.1 to a postgresql database. It is inside a docker container. However, every time I run docker-compose -f docke-compose.yml up, I get the following error:

 Unhandled exception. System.Net.Sockets.SocketException (00000001, 11): Resource temporarily unavailable

I assume this means that something has gone wrong with the database connection but I don't know how to fix it. Here is my docker-compose.yml

version: '3.8'

services:
  server:
    build: ./Test
    ports:
      - "8000:80"
    depends_on:
      - db
  
  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:

And here is my appsettings.json from the backend

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "ConnectionStrings": {
    "Data": "Host=db;Port=5432;Database=data;User ID=user;Password=pass"
  },
  "AllowedHosts": "*"
}

I have tried changing the connection strings, password and user id but I keep getting the same error.

Guru Stron · Accepted Answer · 2023-01-28 11:24:52Z

2

Either remove network from docker-compose.yml (so default is used) or add db-network to server:

services:
  server:
    build: ./Test
    ports:
      - "8000:80"
    depends_on:
      - db
    networks:
      - db-network

edited Jan 28, 2023 at 11:24

answered Jan 28, 2023 at 9:40

Guru Stron

151k11 gold badges186 silver badges233 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Isaac Cooke Over a year ago

That still gives the same error. I have also tried clearing all the cache but its still the same.

Guru Stron Over a year ago

@IsaacCooke try removing network specification or add network to the service.

Isaac Cooke Over a year ago

How would I do that? I tried removing the network fields in docker-compose.yml but I still had the same error.

Collectives™ on Stack Overflow

How to connect an ASP.NET backend to a postgres database inside a docker container

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related