FROM postgres:17.2

ARG USER_ID
ARG GROUP_ID

RUN apt-get update && apt-get install -y sudo;

RUN addgroup --gid ${GROUP_ID} labkey
RUN adduser --gecos 'LabKey' --uid ${USER_ID} --gid ${GROUP_ID} --disabled-password labkey 
RUN echo 'labkey ALL=(ALL) NOPASSWD:ALL' >> /etc/sudoers
RUN usermod -G root,sudo labkey

RUN chown -R labkey:labkey /var/lib/postgresql \
   && chown -R labkey:labkey /var/run/postgresql

USER labkey

LABEL "name"="postgresqlX"