Dockerfile

#syntax=docker/dockerfile:1.10

ARG CLOUDNATIVEPG_VERSION

FROM ghcr.io/cloudnative-pg/postgresql:$CLOUDNATIVEPG_VERSION
USER root

ARG POSTGRES_VERSION
ARG TIMESCALE_VERSION
ARG TIMESCALE_TOOLKIT_VERSION
RUN <<EOT
  set -eux

  # Install dependencies
  apt-get update
  apt-get install -y --no-install-recommends curl

  # Add Timescale apt repo
  . /etc/os-release 2>/dev/null
  echo "deb https://packagecloud.io/timescale/timescaledb/debian/ $VERSION_CODENAME main" >/etc/apt/sources.list.d/timescaledb.list
  curl -Lsf https://packagecloud.io/timescale/timescaledb/gpgkey | gpg --dearmor >/etc/apt/trusted.gpg.d/timescale.gpg

  # Install Timescale
  # Since 2.23.1, Timescale's debian packages append a -<pgMaj><pgMin> suffix
  # (e.g. 2.26.3~debian11-1613). Resolve the published version from the repo
  # so we match either the plain form or the newest matching suffixed form.
  apt-get update
  ts_ver=$(apt-cache madison "timescaledb-2-postgresql-$POSTGRES_VERSION" \
    | awk -v v="$TIMESCALE_VERSION~debian$VERSION_ID" '$3==v || index($3, v"-")==1 {print $3; exit}')
  [ -n "$ts_ver" ] || { echo "no timescaledb-2-postgresql-$POSTGRES_VERSION=$TIMESCALE_VERSION~debian$VERSION_ID* in apt" >&2; exit 1; }
  apt-get install -y --no-install-recommends "timescaledb-2-postgresql-$POSTGRES_VERSION=$ts_ver"

  # Install Timescale Toolkit
  apt-get update
  apt-get install -y --no-install-recommends "timescaledb-toolkit-postgresql-$POSTGRES_VERSION=1:$TIMESCALE_TOOLKIT_VERSION~debian$VERSION_ID"

  # Cleanup
  apt-get purge -y curl
  rm /etc/apt/sources.list.d/timescaledb.list /etc/apt/trusted.gpg.d/timescale.gpg
  rm -rf /var/cache/apt/*
EOT

USER 26