output-etl-db.dockerfile

FROM ghcr.io/cloudnative-pg/postgresql:17.6-system-bookworm AS packager

USER root

RUN apt-get -y update

RUN apt-get install -y \
  git make gcc postgresql-server-dev-17

RUN apt-get -y install \
  postgresql-server-dev-17 \
  postgresql-17-dirtyread \
  postgresql-17-extra-window-functions \
  postgresql-17-first-last-agg \
  postgresql-17-hypopg \
  postgresql-17-partman \
  postgresql-17-plproxy \
  postgresql-17-decoderbufs \
  postgresql-17-pllua \
  postgresql-17-roaringbitmap \
  postgresql-17-powa \
  postgresql-17-pg-qualstats \
  postgresql-17-pg-stat-kcache \
  postgresql-17-pg-wait-sampling \
  postgresql-17-pg-track-settings \
  postgresql-17-pgfaceting \
  pgbouncer \
  skytools3-ticker

# Install pg_orphaned
RUN git clone https://github.com/bdrouvot/pg_orphaned.git && \
  cd pg_orphaned && \
  make && \
  make install

# Install pg_auth_mon
RUN apt-get install -y libkrb5-dev libssl-dev

RUN git clone https://github.com/RafiaSabih/pg_auth_mon && \
  cd pg_auth_mon && \
  make install

# Install bg_mon
RUN apt-get install -y libevent-dev libbrotli-dev

RUN git clone https://github.com/CyberDem0n/bg_mon && \
  cd bg_mon && \
  USE_PGXS=1 make && \
  USE_PGXS=1 make install

# Install set_user
RUN git clone https://github.com/pgaudit/set_user && \
  cd set_user && \
  USE_PGXS=1 make && \
  USE_PGXS=1 make install

# Install pgextwlist
RUN git clone https://github.com/dimitri/pgextwlist && \
  cd pgextwlist && \
  make && \
  make install && \
  cp ./pgextwlist.so /usr/lib/postgresql/17/lib/plugins

# Install the Citus extension.
RUN apt-get -y install curl
RUN curl https://install.citusdata.com/community/deb.sh | bash && \
  apt-get -y install postgresql-17-citus-13.0 --no-install-recommends

CMD sleep infinity