Upgrade to Timescale 2.0

[haf]

Timescale 2.0 was released 13 days ago https://github.com/timescale/timescaledb/releases/tag/2.0.0 — it works well on top of ordinary pgsql from my testing, but has some differences in how it manages policies and compression. I think this version should be the default in the spilo image.

• [ ] Upgrade notes https://docs.timescale.com/latest/update-timescaledb/update-tsdb-2
• [ ] You'll need cmake 3.11 or higher. Current release is 3.19 https://graspingtech.com/upgrade-cmake/
  • [ ] Alternatively use Ubuntu 20.04 LTS that ships cmake version 3.16.3
  • [ ] Release notes https://docs.timescale.com/latest/release-notes
• [ ] Consider upgrading PostGIS at the same time https://github.com/zalando/spilo/issues/529
• [ ] You need to remain on pg 12 until https://github.com/timescale/timescaledb/pull/2498 is merged

CMake quickfix:

 # install modern cmake
RUN curl -o cmake.tar.gz -LO https://github.com/Kitware/CMake/releases/download/v${CMAKE_VERSION}/cmake-${CMAKE_VERSION}-Linux-x86_64.tar.gz \
        && tar -zxf cmake.tar.gz \
        && mv cmake-${CMAKE_VERSION}-Linux-x86_64/bin/ /usr/local/bin

Works well because /usr/local/bin is normally empty and the binary is compiled for the "normal" x86_64 arch already.

[haf]

ARG PGVERSION=12
ARG TIMESCALEDB=2.0.0
ARG TIMESCALEDB_LEGACY=2.0.0
ARG DEMO=false
ARG COMPRESS=false

FROM ubuntu:18.04 as builder-false

ARG DEMO
ARG ADDITIONAL_LOCALES=

RUN export DEBIAN_FRONTEND=noninteractive \
    && echo 'APT::Install-Recommends "0";\nAPT::Install-Suggests "0";' > /etc/apt/apt.conf.d/01norecommend \
    && apt-get update \
    && apt-get install -y curl ca-certificates less locales jq vim-tiny gnupg1 cron runit dumb-init libcap2-bin rsync \
    && ln -s chpst /usr/bin/envdir \
    # Make it possible to use the following utilities without root
    && setcap 'cap_sys_nice+ep' /usr/bin/chrt \
    && setcap 'cap_sys_nice+ep' /usr/bin/renice \
    && chmod u+s /usr/sbin/cron \
\
    && if [ "$DEMO" != "true" ]; then \
        # Required for wal-e
        apt-get install -y pv lzop \
        # install etcdctl
        && ETCDVERSION=2.3.8 \
        && curl -L https://github.com/coreos/etcd/releases/download/v${ETCDVERSION}/etcd-v${ETCDVERSION}-linux-amd64.tar.gz \
                | tar xz -C /bin --strip=1 --wildcards --no-anchored etcdctl etcd; \
    fi \
\
    # Prepare find expression for ADDITIONAL_LOCALES
    && for loc in $ADDITIONAL_LOCALES; do \
        ADDITIONAL_LOCALE_FIND_EXPR="${ADDITIONAL_LOCALE_FIND_EXPR} ! -name ${loc}"; \
    done \
    # Cleanup all locales but en_US.UTF-8 and optionally specified in ADDITIONAL_LOCALES arg
    && find /usr/share/i18n/charmaps/ -type f ! -name UTF-8.gz -delete \
    && find /usr/share/i18n/locales/ -type f ! -name en_US ! -name en_GB ${ADDITIONAL_LOCALE_FIND_EXPR} ! -name i18n* ! -name iso14651_t1 ! -name iso14651_t1_common ! -name 'translit_*' -delete \
    && echo 'en_US.UTF-8 UTF-8' > /usr/share/i18n/SUPPORTED \
\
    # Make sure we have a en_US.UTF-8 locale available
    && localedef -i en_US -c -f UTF-8 -A /usr/share/locale/locale.alias en_US.UTF-8 \
\
    # Make sure we have all additional locales available
    && for loc in $ADDITIONAL_LOCALES; do \
        echo "${loc}.UTF-8 UTF-8" >> /usr/share/i18n/SUPPORTED; \
        localedef -i ${loc} -c -f UTF-8 -A /usr/share/locale/locale.alias ${loc}.UTF-8; \
    done \
\
    # Add PGDG repositories
    && DISTRIB_CODENAME=$(sed -n 's/DISTRIB_CODENAME=//p' /etc/lsb-release) \
    && for t in deb deb-src; do \
        echo "$t http://apt.postgresql.org/pub/repos/apt/ ${DISTRIB_CODENAME}-pgdg main" >> /etc/apt/sources.list.d/pgdg.list; \
    done \
    && curl -s -o - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add - \
\
    # Clean up
    && apt-get purge -y libcap2-bin \
    && apt-get autoremove -y \
    && apt-get clean \
    && rm -rf /var/lib/apt/lists/* \
            /var/cache/debconf/* \
            /usr/share/doc \
            /usr/share/man \
            /usr/share/locale/?? \
            /usr/share/locale/??_?? \
    && find /var/log -type f -exec truncate --size 0 {} \;

COPY dependencies/debs dependencies/src /builddeps/

ARG PGVERSION
ARG TIMESCALEDB
ARG TIMESCALEDB_LEGACY
ARG TIMESCALEDB_APACHE_ONLY=true
ARG DEMO
ARG COMPRESS
ARG PGOLDVERSIONS="11"
ARG WITH_PERL=false

ARG DEB_PG_SUPPORTED_VERSIONS="$PGOLDVERSIONS $PGVERSION"

# Install PostgreSQL, extensions and contribs
ENV POSTGIS_VERSION=3.1 \
    BG_MON_COMMIT=8a21dc39c9fdb20cbd37327d8e0f531755f5dd80 \
    PG_AUTH_MON_COMMIT=a0c086ad9865c9a0f468f12d09b77353acd2de28 \
    PG_MON_COMMIT=12bdfa8d93294fb596c9066bc7e6f73bfead35da \
    DECODERBUFS=v1.2.1.Final \
    SET_USER=REL2_0_0 \
    PLPROFILER=REL4_1 \
    PAM_OAUTH2=v1.0.1 \
    PLANTUNER_COMMIT=800d81bc85da64ff3ef66e12aed1d4e1e54fc006 \
    PG_PERMISSIONS_COMMIT=314b9359e3d77c0b2ef7dbbde97fa4be80e31925 \
    CMAKE_VERSION=3.19.2

RUN export DEBIAN_FRONTEND=noninteractive \
    && set -ex \
    && sed -i 's/^#\s*\(deb.*universe\)$/\1/g' /etc/apt/sources.list \
    && apt-get update \
    && cd /builddeps \
\
    && BUILD_PACKAGES="devscripts equivs build-essential fakeroot debhelper git gcc libc6-dev make libevent-dev libbrotli-dev libssl-dev libkrb5-dev" \
    && if [ "$DEMO" = "true" ]; then \
        export DEB_PG_SUPPORTED_VERSIONS="$PGVERSION" \
        && WITH_PERL=false \
        && rm -f *.deb \
        && apt-get install -y $BUILD_PACKAGES; \
    else \
        BUILD_PACKAGES="$BUILD_PACKAGES pgxnclient zlib1g-dev libprotobuf-c-dev libpam0g-dev libcurl4-openssl-dev libicu-dev python libc-ares-dev pandoc pkg-config" \
# debezium-decoderbufs: libprotobuf-c-dev
# pgbouncer: libc-ares-dev pandoc pkg-config
        && apt-get install -y $BUILD_PACKAGES libprotobuf-c1 libcurl4 \
\
        # install modern cmake
        && curl -o cmake.tar.gz -LO https://github.com/Kitware/CMake/releases/download/v${CMAKE_VERSION}/cmake-${CMAKE_VERSION}.tar.gz \
        && tar -zxf cmake.tar.gz \
        && (cd cmake-${CMAKE_VERSION} && ./bootstrap && make && make install) \
\
        # install pam_oauth2.so
        && git clone -b $PAM_OAUTH2 --recurse-submodules https://github.com/CyberDem0n/pam-oauth2.git \
        && make -C pam-oauth2 install \
\
        # prepare 3rd sources
        && git clone -b $DECODERBUFS https://github.com/debezium/postgres-decoderbufs.git \
        && git clone -b $PLPROFILER https://github.com/bigsql/plprofiler.git \
        && tar -xzf plantuner-${PLANTUNER_COMMIT}.tar.gz \
        && curl -sL https://github.com/RafiaSabih/pg_mon/archive/$PG_MON_COMMIT.tar.gz | tar xz \
\
        && for p in python3-keyring python3-docutils ieee-data; do \
            version=$(apt-cache show $p | sed -n 's/^Version: //p' | sort -rV | head -n 1) \
            && echo "Section: misc\nPriority: optional\nStandards-Version: 3.9.8\nPackage: $p\nVersion: $version\nDescription: $p" > $p \
            && equivs-build $p; \
        done; \
    fi \
\
    && if [ "$WITH_PERL" != "true" ]; then \
        version=$(apt-cache show perl | sed -n 's/^Version: //p' | sort -rV | head -n 1) \
        && echo "Section: misc\nPriority: optional\nStandards-Version: 3.9.8\nPackage: perl\nSection:perl\nMulti-Arch: allowed\nReplaces: perl-base\nVersion: $version\nDescription: perl" > perl \
        && equivs-build perl; \
    fi \
\
    && if [ "$WITH_PERL" != "true" ] || [ "$DEMO" != "true" ]; then dpkg -i *.deb || apt-get -y -f install; fi \
\
    && curl -sL https://github.com/CyberDem0n/bg_mon/archive/$BG_MON_COMMIT.tar.gz | tar xz \
    && curl -sL https://github.com/CyberDem0n/pg_auth_mon/archive/$PG_AUTH_MON_COMMIT.tar.gz | tar xz \
    && curl -sL https://github.com/cybertec-postgresql/pg_permission/archive/$PG_PERMISSIONS_COMMIT.tar.gz | tar xz \
    && git clone -b $SET_USER https://github.com/pgaudit/set_user.git \
    && git clone -b $TIMESCALEDB_LEGACY https://github.com/timescale/timescaledb.git \
\
    && apt-get install -y postgresql-common libevent-2.1 libevent-pthreads-2.1 sysstat brotli libbrotli1 python3.6 python3-psycopg2 \
\
    # forbid creation of a main cluster when package is installed
    && sed -ri 's/#(create_main_cluster) .*$/\1 = false/' /etc/postgresql-common/createcluster.conf \
\
    && for version in $DEB_PG_SUPPORTED_VERSIONS; do \
            sed -i "s/ main.*$/ main $version/g" /etc/apt/sources.list.d/pgdg.list \
            && apt-get update \
\
            && if [ "$DEMO" != "true" ]; then \
                EXTRAS="postgresql-pltcl-${version} \
                        postgresql-${version}-hypopg \
                        postgresql-${version}-pgaudit \
                        postgresql-${version}-pg-checksums \
                        postgresql-${version}-pgl-ddl-deploy \
                        postgresql-${version}-pglogical \
                        postgresql-${version}-pglogical-ticker \
                        postgresql-${version}-pldebugger \
                        postgresql-${version}-pllua \
                        postgresql-${version}-plpgsql-check \
                        postgresql-${version}-plproxy \
                        postgresql-${version}-postgis-${POSTGIS_VERSION%.1} \
                        postgresql-${version}-postgis-${POSTGIS_VERSION%.1}-scripts \
                        postgresql-${version}-repack \
                        postgresql-${version}-wal2json" \
                && if [ "$WITH_PERL" = "true" ]; then \
                    EXTRAS="$EXTRAS postgresql-plperl-${version}"; \
                fi \
                && if [ ${version%.*} -lt 11 ]; then \
                    EXTRAS="$EXTRAS postgresql-${version}-amcheck"; \
                fi; \
            fi \
\
            # Install PostgreSQL binaries, contrib, plproxy and multiple pl's
            && apt-get install --allow-downgrades -y postgresql-contrib-${version} \
                    postgresql-plpython3-${version} postgresql-server-dev-${version} \
                    postgresql-${version}-cron postgresql-${version}-pgq3 \
                    postgresql-${version}-pg-stat-kcache $EXTRAS \
\
            # Install 3rd party stuff, also see https://github.com/timescale/timescaledb/issues/2770
            && if [ "$version" != "9.5" ] && [ "$version" != "13" ]; then \
                cd /builddeps/timescaledb \
                && if [ "$version" = "11" ]; then git checkout $TIMESCALEDB; fi \
                && BUILD_FORCE_REMOVE=true ./bootstrap -DREGRESS_CHECKS=OFF \
                    -DPG_CONFIG=/usr/lib/postgresql/$version/bin/pg_config \
                    -DAPACHE_ONLY=$TIMESCALEDB_APACHE_ONLY -DSEND_TELEMETRY_DEFAULT=NO \
                    -DWARNINGS_AS_ERRORS=OFF \
                && make -C build install \
                && strip /usr/lib/postgresql/$version/lib/timescaledb*.so \
                && cd /builddeps; \
            fi \
\
            && if [ "$DEMO" != "true" ]; then \
                if [ ${version%.*} -lt 11 ]; then \
                    for extension in quantile trimmed_aggregates; do \
                        pgxn install $extension \
                        && strip /usr/lib/postgresql/$version/lib/$extension.so; \
                    done; \
                fi \
\
                && EXTRA_EXTENSIONS="plantuner-${PLANTUNER_COMMIT} plprofiler postgres-decoderbufs" \
                && if [ ${version%.*} -ge 10 ]; then \
                     EXTRA_EXTENSIONS="$EXTRA_EXTENSIONS pg_mon-${PG_MON_COMMIT}"; \
                fi; \
            else \
                EXTRA_EXTENSIONS=""; \
            fi \
\
            && for n in bg_mon-${BG_MON_COMMIT} pg_auth_mon-${PG_AUTH_MON_COMMIT} set_user pg_permission-${PG_PERMISSIONS_COMMIT} $EXTRA_EXTENSIONS; do \
                make -C $n USE_PGXS=1 clean install-strip; \
            done; \
    done \
\
    && apt-get install -y skytools3-ticker \
\
    && sed -i "s/ main.*$/ main/g" /etc/apt/sources.list.d/pgdg.list \
    && apt-get update \
    && apt-get install -y postgresql postgresql-server-dev-all libpq-dev \
    && for version in $DEB_PG_SUPPORTED_VERSIONS; do \
        apt-get install -y postgresql-server-dev-${version}; \
    done \
\
    && if [ "$DEMO" != "true" ]; then \
        for version in $DEB_PG_SUPPORTED_VERSIONS; do \
            # due to dependency issues partman has to be installed separately
            apt-get install -y postgresql-${version}-partman \
            # create postgis symlinks to make it possible to perform update
            && ln -s postgis-${POSTGIS_VERSION%.1}.so \
                /usr/lib/postgresql/${version}/lib/postgis-2.5.so; \
        done \
        # patch, build and install pgbouncer
        && apt-get source pgbouncer \
        && cd $(ls -d pgbouncer-*) \
        # Increase password size
        && sed -i 's/\(MAX_PASSWORD\t\).*/\11024/' include/bouncer.h \
        && sed -i 's/\(SEND_wrap(\)512\(, pktbuf_write_PasswordMessage, res, sk, psw)\)/\11024\2/' include/pktbuf.h \
        && DEB_BUILD_OPTIONS=nocheck debuild -b -uc -us \
        && cd .. \
        && dpkg -i pgbouncer_*.deb; \
    fi \
\
    # build and install missing packages
    && for pkg in pgextwlist; do \
        apt-get source postgresql-$PGVERSION-${pkg} \
        && cd $(ls -d *${pkg%?}*-*/) \
        && if [ "$pkg" = "pgextwlist" ]; then \
            sed -i '/postgresql-all/d' debian/control.in \
            # make it possible to use it from shared_preload_libraries
            && perl -ne 'print unless /PG_TRY/ .. /PG_CATCH/' pgextwlist.c > pgextwlist.c.f \
            && egrep -v '(PG_END_TRY|EmitWarningsOnPlaceholders)' pgextwlist.c.f > pgextwlist.c; \
        fi \
        && pg_buildext updatecontrol \
        && DEB_BUILD_OPTIONS=nocheck debuild -b -uc -us \
        && cd .. \
        && for version in $DEB_PG_SUPPORTED_VERSIONS; do \
            for deb in postgresql-${version}-${pkg}_*.deb; do \
                if [ -f $deb ]; then dpkg -i $deb; fi; \
            done; \
        done; \
    done \
\
    # Remove unnecessary packages
    && apt-get purge -y ${BUILD_PACKAGES} postgresql postgresql-server-dev-* libpq-dev=* libmagic1 bsdmainutils \
    && apt-get autoremove -y \
    && apt-get clean \
    && dpkg -l | grep '^rc' | awk '{print $2}' | xargs apt-get purge -y \
\
    # Try to minimize size by creating symlinks instead of duplicate files
    && if [ "$DEMO" != "true" ]; then \
        cd /usr/lib/postgresql/$PGVERSION/bin \
        && for u in clusterdb pg_archivecleanup pg_basebackup pg_isready pg_recvlogical pg_test_fsync pg_test_timing pgbench psql reindexdb vacuumdb vacuumlo *.py; do \
            for v in /usr/lib/postgresql/*; do \
                if [ "$v" != "/usr/lib/postgresql/$PGVERSION" ] && [ -f "$v/bin/$u" ]; then \
                    rm $v/bin/$u \
                    && ln -s ../../$PGVERSION/bin/$u $v/bin/$u; \
                fi; \
            done; \
        done \
\
        && PGVERSION=12 \
        && cd /usr/share/postgresql/$PGVERSION/contrib/postgis-$POSTGIS_VERSION \
        && for f in *.sql *.pl; do \
            for v in /usr/share/postgresql/*; do \
                if [ "$v" != "/usr/share/postgresql/$PGVERSION" ] && diff $v/contrib/postgis-$POSTGIS_VERSION/$f $f > /dev/null; then \
                    rm $v/contrib/postgis-$POSTGIS_VERSION/$f \
                    && ln -s ../../../$PGVERSION/contrib/postgis-$POSTGIS_VERSION/$f $v/contrib/postgis-$POSTGIS_VERSION/$f; \
                fi; \
            done; \
        done \
\
        && if [ -d /usr/share/postgresql/9.5/contrib/postgis-$POSTGIS_VERSION ]; then \
            cd /usr/share/postgresql/9.5/contrib/postgis-$POSTGIS_VERSION \
            && for f in *.sql *.pl; do \
                if [ -L $f ]; then continue; fi \
                && for v in /usr/share/postgresql/*; do \
                    if [ "$v" != "/usr/share/postgresql/9.5" ] && [ -f $v/contrib/postgis-$POSTGIS_VERSION/$f ] \
                            && [ ! -L $v/contrib/postgis-$POSTGIS_VERSION/$f ] \
                            && diff $v/contrib/postgis-$POSTGIS_VERSION/$f $f > /dev/null; then \
                        rm $v/contrib/postgis-$POSTGIS_VERSION/$f \
                        && ln -s ../../../9.5/contrib/postgis-$POSTGIS_VERSION/$f \
                                $v/contrib/postgis-$POSTGIS_VERSION/$f; \
                    fi; \
                done; \
            done; \
        fi \
\
        && cd /usr/share/postgresql/$PGVERSION/extension \
        && for orig in $(ls -1 *.sql | grep -v -- '--'); do \
            for f in ${orig%.sql}--*.sql; do \
                if diff $orig $f > /dev/null; then \
                    rm $f \
                    && ln -s $orig $f; \
                fi; \
            done; \
        done \
\
        && for e in pgq plproxy address_standardizer address_standardizer_data_us; do \
            orig=$(ls -1 $e--*--*.sql 2> /dev/null | head -n1) \
            && if [ "x$orig" != "x" ]; then \
                for f in $e--*--*.sql; do \
                    if [ "$f" != "$orig" ] && diff $f $orig > /dev/null; then \
                        rm $f \
                        && ln -s $orig $f; \
                    fi; \
                done; \
            fi; \
        done \
\
        && for f in *.sql *.control; do \
            for v in /usr/share/postgresql/*; do \
                if [ "$v" != "/usr/share/postgresql/$PGVERSION" ] \
                        && [ -f $v/extension/$f ] \
                        && [ ! -L $v/extension/$f ] \
                        && diff $v/extension/$f $f > /dev/null; then \
                    rm $v/extension/$f \
                    && ln -s ../../$PGVERSION/extension/$f $v/extension/$f; \
                fi; \
            done; \
        done \
\
        && if [ -d /usr/share/postgresql/9.5/extension ]; then \
            cd /usr/share/postgresql/9.5/extension \
            && for f in *.sql *.control; do \
                if [ -L $f ]; then continue; fi \
                && for v in /usr/share/postgresql/*; do \
                    if [ "$v" != "/usr/share/postgresql/9.5" ] && [ -f $v/extension/$f ] \
                            && [ ! -L $v/extension/$f ] \
                            && diff $v/extension/$f $f > /dev/null; then \
                        rm $v/extension/$f \
                        && ln -s ../../9.5/extension/$f $v/extension/$f; \
                   fi; \
                done; \
            done; \
        fi \
\
        && cd /usr/share/postgresql/$PGVERSION/contrib \
        && for f in *.sql *.html; do \
            for v in /usr/share/postgresql/*; do \
                if [ "$v" != "/usr/share/postgresql/$PGVERSION" ] && diff $v/contrib/$f $f > /dev/null; then \
                    rm $v/contrib/$f \
                    && ln -s ../../$PGVERSION/contrib/$f $v/contrib/$f; \
                fi; \
            done; \
        done; \
    fi \
\
    # Clean up
    && rm -rf /var/lib/apt/lists/* \
            /var/cache/debconf/* \
            /builddeps \
            /usr/share/doc \
            /usr/share/man \
            /usr/share/info \
            /usr/share/locale/?? \
            /usr/share/locale/??_?? \
            /usr/share/postgresql/*/man \
            /etc/pgbouncer/* \
            /usr/lib/postgresql/*/bin/createdb \
            /usr/lib/postgresql/*/bin/createlang \
            /usr/lib/postgresql/*/bin/createuser \
            /usr/lib/postgresql/*/bin/dropdb \
            /usr/lib/postgresql/*/bin/droplang \
            /usr/lib/postgresql/*/bin/dropuser \
            /usr/lib/postgresql/*/bin/pg_standby \
            /usr/lib/postgresql/*/bin/pltcl_* \
    && find /var/log -type f -exec truncate --size 0 {} \;

# Install patroni, wal-e and wal-g
ENV PATRONIVERSION=2.0.0
ENV WALE_VERSION=1.1.1
ENV WALG_VERSION=v0.2.15
RUN export DEBIAN_FRONTEND=noninteractive \
    && set -ex \
    && BUILD_PACKAGES="python3-pip python3-wheel python3-dev git patchutils binutils" \
    && apt-get update \
\
    # install most of the patroni dependencies from ubuntu packages
    && apt-cache depends patroni \
            | sed -n -e 's/.* Depends: \(python3-.\+\)$/\1/p' \
            | grep -Ev '^python3-(sphinx|etcd|consul|kazoo|kubernetes)' \
            | xargs apt-get install -y ${BUILD_PACKAGES} \
                        python3-pystache python3-requests \
\
    && pip3 install setuptools \
\
    && if [ "$DEMO" != "true" ]; then \
        EXTRAS=",etcd,consul,zookeeper,aws" \
        && curl -sL https://github.com/wal-g/wal-g/releases/download/$WALG_VERSION/wal-g.linux-amd64.tar.gz \
                | tar -C /usr/local/bin -xz \
        && strip /usr/local/bin/wal-g \
        && apt-get install -y python3-etcd python3-consul python3-kazoo python3-meld3 \
                        python3-boto python3-gevent python3-greenlet python3-cachetools \
                        python3-rsa python3-pyasn1-modules python3-swiftclient \
\
        && find /usr/share/python-babel-localedata/locale-data -type f ! -name 'en_US*.dat' -delete \
\
        && pip3 install filechunkio wal-e[aws,google,swift]==$WALE_VERSION \
                'git+https://github.com/zalando/pg_view.git@master#egg=pg-view' \
\
        # Don't monkey patch thread, it causing performance issues with S3
        # https://github.com/wal-e/wal-e/commit/485d834a18c9b0d97115d95f89e16bdc564e9a18#commitcomment-34529978
        && sed -i 's/^ *gevent.monkey.patch_thread/#&/' \
                    /usr/local/lib/python3.6/dist-packages/wal_e/cmd.py \
        # https://github.com/wal-e/wal-e/issues/318
        && sed -i 's/^\(    for i in range(0,\) num_retries):.*/\1 100):/g' \
                    /usr/lib/python3/dist-packages/boto/utils.py; \
    fi \
    && pip3 install "git+https://github.com/zalando/patroni.git@2.0/bugfixes#egg=patroni[kubernetes$EXTRAS]" \
\
    && for d in /usr/local/lib/python3.6 /usr/lib/python3; do \
        cd $d/dist-packages \
        && find . -type d -name tests | xargs rm -fr \
        && find . -type f -name 'test_*.py*' -delete; \
    done \
    && find . -type f -name 'unittest_*.py*' -delete \
    && find . -type f -name '*_test.py' -delete \
    && find . -type f -name '*_test.cpython*.pyc' -delete \
\
    # Clean up
    && apt-get purge -y ${BUILD_PACKAGES} \
    && apt-get autoremove -y \
    && apt-get clean \
    && rm -rf /var/lib/apt/lists/* \
            /var/cache/debconf/* \
            /root/.cache \
            /usr/share/doc \
            /usr/share/man \
            /usr/share/locale/?? \
            /usr/share/locale/??_?? \
            /usr/share/info \
    && find /var/log -type f -exec truncate --size 0 {} \;

RUN set -ex \
    && if [ "$COMPRESS" = "true" ]; then \
        apt-get update \
        && apt-get install -y busybox xz-utils \
        && apt-get clean \
        && rm -rf /var/lib/apt/lists/* /var/cache/debconf/* /usr/share/doc /usr/share/man /etc/rc?.d /etc/systemd \
        && ln -snf busybox /bin/sh \
        && files="/bin/sh" \
        && libs="$(ldd $files | awk '{print $3;}' | grep '^/' | sort -u) /lib/x86_64-linux-gnu/ld-linux-x86-64.so.* /lib/x86_64-linux-gnu/libnsl.so.* /lib/x86_64-linux-gnu/libnss_compat.so.*" \
        && (echo /var/run /var/spool $files $libs | tr ' ' '\n' && realpath $files $libs) | sort -u | sed 's/^\///' > /exclude \
        && find /etc/alternatives -xtype l -delete \
        && save_dirs="usr lib var bin sbin etc/ssl etc/init.d etc/alternatives etc/apt" \
        && XZ_OPT=-e9v tar -X /exclude -cpJf a.tar.xz $save_dirs \
        && rm -fr /usr/local/lib/python* \
        && /bin/busybox sh -c "(find $save_dirs -not -type d && cat /exclude /exclude && echo exclude) | sort | uniq -u | xargs /bin/busybox rm" \
        && /bin/busybox --install -s \
        && /bin/busybox sh -c "find $save_dirs -type d -depth -exec rmdir -p {} \; 2> /dev/null"; \
    fi

FROM scratch as builder-true
COPY --from=builder-false / /

FROM builder-${COMPRESS}

LABEL maintainer="Alexander Kukushkin <alexander.kukushkin@zalando.de>"

ARG PGVERSION
ARG TIMESCALEDB
ARG TIMESCALEDB_LEGACY
ARG DEMO
ARG COMPRESS

EXPOSE 5432 8008 8080

ENV LC_ALL=en_US.utf-8 \
    PATH=$PATH:/usr/lib/postgresql/$PGVERSION/bin \
    PGHOME=/home/postgres \
    RW_DIR=/run \
    TIMESCALEDB=$TIMESCALEDB \
    TIMESCALEDB_LEGACY=$TIMESCALEDB_LEGACY \
    DEMO=$DEMO

ENV WALE_ENV_DIR=$RW_DIR/etc/wal-e.d/env \
    LOG_ENV_DIR=$RW_DIR/etc/log.d/env \
    PGROOT=$PGHOME/pgdata/pgroot

ENV PGDATA=$PGROOT/data \
    PGLOG=$PGROOT/pg_log

WORKDIR $PGHOME

COPY motd /etc/
COPY runit /etc/service/
COPY pgq_ticker.ini $PGHOME/

RUN sed -i "s|/var/lib/postgresql.*|$PGHOME:/bin/bash|" /etc/passwd \
        && chown -R postgres:postgres $PGHOME $RW_DIR \
        && rm -fr /var/spool/cron /var/tmp \
        && mkdir -p /var/spool \
        && ln -s $RW_DIR/cron /var/spool/cron \
        && ln -s $RW_DIR/tmp /var/tmp \
        && ln -snf $RW_DIR/service /etc/service \
        && ln -s $RW_DIR/pam.d-postgresql /etc/pam.d/postgresql \
        && ln -s $RW_DIR/postgres.yml $PGHOME/postgres.yml \
        && ln -s $RW_DIR/.bash_history /root/.bash_history \
        && ln -s $RW_DIR/postgresql/.bash_history $PGHOME/.bash_history \
        && ln -s $RW_DIR/postgresql/.psql_history $PGHOME/.psql_history \
        && ln -s $RW_DIR/etc $PGHOME/etc \
        && for d in $PGHOME /root; do \
            d=$d/.config/patroni \
            && mkdir -p $d \
            && ln -s $PGHOME/postgres.yml $d/patronictl.yaml; \
        done \
        && sed -i 's/set compatible/set nocompatible/' /etc/vim/vimrc.tiny \
        && echo "PATH=\"$PATH\"" > /etc/environment \
        && for e in TERM=linux LC_ALL=C.UTF-8 LANG=C.UTF-8 EDITOR=editor; \
            do echo "export $e" >> /etc/bash.bashrc; \
        done \
        && ln -s /etc/skel/.bashrc $PGHOME/.bashrc \
        && echo "source /etc/motd" >> /root/.bashrc \
        # Allow users in the root group to access the following files and dirs
        && if [ "$COMPRESS" != "true" ]; then \
           chmod 664 /etc/passwd \
           && chgrp -R 0 $PGHOME $RW_DIR \
           && chmod -R g=u $PGHOME $RW_DIR \
           && usermod -a -G root postgres; \
        fi

COPY scripts bootstrap major_upgrade /scripts/
COPY launch.sh /

CMD ["/bin/sh", "/launch.sh", "init"]

Since TimescaleDB doesn't support pgsql 13, the Dockerfile above uses v12 instead.

[CyberDem0n]

Closed in https://github.com/zalando/spilo/pull/535