Kaballas/postgresql-hosting

1FROM postgres:172 3# Create user with UID 1000 (required by HF Spaces)4RUN useradd -m -u 1000 user5 6# Set environment variables7ENV HOME=/home/user \8    PATH=/home/user/.local/bin:$PATH \9    POSTGRES_PASSWORD=password \10    POSTGRES_USER=postgres \11    POSTGRES_DB=postgres \12    PGDATA=/home/user/pgdata13 14# Create data directory with correct permissions15RUN mkdir -p /home/user/pgdata && \16    chown -R user:user /home/user/pgdata17 18# Switch to user19USER user20 21WORKDIR $HOME/app22 23# Expose PostgreSQL port24EXPOSE 543225 26# Start PostgreSQL27CMD ["postgres"]28