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