FROM ghcr.io/postgresml/postgresml:2.7.12
USER root
# Set working directory
WORKDIR /app

# Expose necessary ports
EXPOSE 5432 8000

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

# Install necessary tools
RUN apt-get update && apt-get install -y sudo

# Create a non-root user
RUN useradd -m -u 1000 postgresml

# Set permissions
RUN chown -R postgresml:postgresml /var/lib/postgresql

# Set environment variables
ENV HOME=/home/postgresml

# Default command
CMD ["sudo", "-u", "postgresml", "psql", "-d", "postgresml"]