# Use the official PostgreSQL image from Docker Hub
FROM phidata/pgvector:16

# Set environment variables
ENV POSTGRES_DB=ai
ENV POSTGRES_USER=ai
ENV POSTGRES_PASSWORD=ai
ENV PGDATA=/var/lib/postgresql/data/pgdata

# Expose the PostgreSQL port
EXPOSE 7860

# Use a volume for PostgreSQL data
VOLUME ["/var/lib/postgresql/data"]

# The default command to run the PostgreSQL server
CMD ["postgres"]