FROM postgres:17

RUN apt-get update && apt-get install -y \
    postgresql-17-postgis-3 \
    postgresql-17-postgis-3-scripts \
    postgresql-17-pgvector \
    && rm -rf /var/lib/apt/lists/*

EXPOSE 5432