Unable to spin docker-compose with Prefect 2.8.4/older official docker-hub images with Postgres: I would love if someone can point out why this is failing. Here's the error (I had to trim due to character limitations) -

2023-03-06 20:19:39     value = await result
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/site-packages/asyncpg/connection.py", line 2092, in connect
2023-03-06 20:19:39     return await connect_utils._connect(
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py", line 895, in _connect
2023-03-06 20:19:39     raise last_error
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py", line 881, in _connect
2023-03-06 20:19:39     return await _connect_addr(
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py", line 773, in _connect_addr
2023-03-06 20:19:39     return await __connect_addr(params, timeout, True, *args)
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py", line 825, in __connect_addr
2023-03-06 20:19:39     tr, pr = await compat.wait_for(connector, timeout=timeout)
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/site-packages/asyncpg/compat.py", line 56, in wait_for
2023-03-06 20:19:39     return await asyncio.wait_for(fut, timeout)
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/asyncio/tasks.py", line 445, in wait_for
2023-03-06 20:19:39     return fut.result()
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py", line 684, in _create_ssl_connection
2023-03-06 20:19:39     tr, pr = await loop.create_connection(
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/asyncio/base_events.py", line 1036, in create_connection
2023-03-06 20:19:39     infos = await self._ensure_resolved(
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/asyncio/base_events.py", line 1418, in _ensure_resolved
2023-03-06 20:19:39     return await loop.getaddrinfo(host, port, family=family, type=type,
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/asyncio/base_events.py", line 863, in getaddrinfo
2023-03-06 20:19:39     return await self.run_in_executor(
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/concurrent/futures/thread.py", line 58, in run
2023-03-06 20:19:39     result = self.fn(*self.args, **self.kwargs)
2023-03-06 20:19:39   File "/usr/local/lib/python3.10/socket.py", line 955, in getaddrinfo
2023-03-06 20:19:39     for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
2023-03-06 20:19:39 socket.gaierror: [Errno -2] Name or service not known
2023-03-06 20:19:39 
2023-03-06 20:19:39 Application startup failed. Exiting.

Here's my docker-compose -

version: '3.8'

networks:
  prefect:
    name: prefect

services:
  # ------------------------------------------------------------- #
  #             PostgreSQL DB for Prefect DB                      #
  # ------------------------------------------------------------- #
  postgres:
    image: postgres:latest
    restart: always
    command:
      - postgres
      - -c
      - max_connections=150
    environment:
      - POSTGRES_USER=${POSTGRES_USER}
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
      - POSTGRES_DB=${POSTGRES_DB}
    healthcheck:
      interval: 10s
      retries: 60
      start_period: 2s
      test: pg_isready -q -d $${POSTGRES_DB} -U $${POSTGRES_USER} | grep "accepting connections" || exit 1
      timeout: 2s
    ports:
      - 5432:5432
    expose:
      - 5432
  # -------------------------------------- #
  #             Prefect Server              #
  # -------------------------------------- #
  prefect-server:
    image: prefecthq/prefect:2.8.4-python3.10
    command:
      - prefect
      - server
      - start
    ports:
      - 4200:4200
    expose:
      - 4200
    environment:
      PREFECT_API_DATABASE_CONNECTION_URL: postgresql+asyncpg://${POSTGRES_USER}:${POSTGRES_PASSWORD}@postgres:5432/${POSTGRES_DB}
    networks:
      - prefect
    restart: always
    depends_on:
      postgres:
        condition: service_started

Hi Amruth, please refrain from posting snippets in the message and instead opt to put them into a reply thread underneath your original comment

Thanks for the helpful tip @Tyler Wanner, will do it

thank you, it will allow your message to be more discoverable 🙂 along with all other messages

Makes sense, I am bad with Slack unfortunately 😞.

@Amruth VVKP Were you ever able to get past this? We're running into the same issue (not with Docker compose - using helm charts)

I've always been pulling newer versions of Prefect's Docker image, apart from v2.8.4 none of the other images ran into this failure. Try the latest one, perhaps 2.10.10