hindsight-postgres (sha256:baff3c38b98c4ba8b1886f02886bbdf2f2f2bae58da9cb6a8d164001f0effc07)
Published 2026-10-28 22:40:25 +00:00 by jlxq0
Installation
docker pull forge.oddie.app/oddie-apps/hindsight-postgres@sha256:baff3c38b98c4ba8b1886f02886bbdf2f2f2bae58da9cb6a8d164001f0effc07sha256:baff3c38b98c4ba8b1886f02886bbdf2f2f2bae58da9cb6a8d164001f0effc07Image layers
| # debian.sh --arch 'amd64' out/ 'bookworm' '@1789689600' |
| RUN /bin/sh -c set -eux; groupadd -r postgres --gid=999; useradd -r -g postgres --uid=999 --home-dir=/var/lib/postgresql --shell=/bin/bash postgres; install --verbose --directory --owner postgres --group postgres --mode 1777 /var/lib/postgresql # buildkit |
| RUN /bin/sh -c set -ex; apt-get update; apt-get install -y --no-install-recommends gnupg less ; rm -rf /var/lib/apt/lists/* # buildkit |
| ENV GOSU_VERSION=1.19 |
| RUN /bin/sh -c set -eux; savedAptMark="$(apt-mark showmanual)"; apt-get update; apt-get install -y --no-install-recommends ca-certificates wget; rm -rf /var/lib/apt/lists/*; dpkgArch="$(dpkg --print-architecture | awk -F- '{ print $NF }')"; wget -O /usr/local/bin/gosu "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch"; wget -O /usr/local/bin/gosu.asc "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch.asc"; export GNUPGHOME="$(mktemp -d)"; gpg --batch --keyserver hkps://keys.openpgp.org --recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4; gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu; gpgconf --kill all; rm -rf "$GNUPGHOME" /usr/local/bin/gosu.asc; apt-mark auto '.*' > /dev/null; [ -z "$savedAptMark" ] || apt-mark manual $savedAptMark > /dev/null; apt-get purge -y --auto-remove -o APT::AutoRemove::RecommendsImportant=false; chmod +x /usr/local/bin/gosu; gosu --version; gosu nobody true # buildkit |
| RUN /bin/sh -c set -eux; if [ -f /etc/dpkg/dpkg.cfg.d/docker ]; then grep -q '/usr/share/locale' /etc/dpkg/dpkg.cfg.d/docker; sed -ri '/\/usr\/share\/locale/d' /etc/dpkg/dpkg.cfg.d/docker; ! grep -q '/usr/share/locale' /etc/dpkg/dpkg.cfg.d/docker; fi; apt-get update; apt-get install -y --no-install-recommends locales; rm -rf /var/lib/apt/lists/*; echo 'en_US.UTF-8 UTF-8' >> /etc/locale.gen; locale-gen; locale -a | grep 'en_US.utf8' # buildkit |
| ENV LANG=en_US.utf8 |
| RUN /bin/sh -c set -eux; apt-get update; apt-get install -y --no-install-recommends libnss-wrapper xz-utils zstd ; rm -rf /var/lib/apt/lists/* # buildkit |
| RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit |
| RUN /bin/sh -c set -ex; key='B97B0AFCAA1A47F044F244A07FCC7D46ACCC4CF8'; export GNUPGHOME="$(mktemp -d)"; mkdir -p /usr/local/share/keyrings/; gpg --batch --keyserver keyserver.ubuntu.com --recv-keys "$key"; gpg --batch --export --armor "$key" > /usr/local/share/keyrings/postgres.gpg.asc; gpgconf --kill all; rm -rf "$GNUPGHOME" # buildkit |
| ENV PG_MAJOR=17 |
| ENV PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin |
| ENV PG_VERSION=17.11-1.pgdg12+2 |
| RUN /bin/sh -c set -ex; export PYTHONDONTWRITEBYTECODE=1; dpkgArch="$(dpkg --print-architecture)"; aptRepo="[ signed-by=/usr/local/share/keyrings/postgres.gpg.asc ] http://apt.postgresql.org/pub/repos/apt bookworm-pgdg main $PG_MAJOR"; case "$dpkgArch" in amd64 | arm64 | ppc64el) echo "deb $aptRepo" > /etc/apt/sources.list.d/pgdg.list; apt-get update; ;; *) echo "deb-src $aptRepo" > /etc/apt/sources.list.d/pgdg.list; savedAptMark="$(apt-mark showmanual)"; tempDir="$(mktemp -d)"; cd "$tempDir"; apt-get update; apt-get install -y --no-install-recommends dpkg-dev; echo "deb [ trusted=yes ] file://$tempDir ./" > /etc/apt/sources.list.d/temp.list; _update_repo() { dpkg-scanpackages . > Packages; apt-get -o Acquire::GzipIndexes=false update; }; _update_repo; nproc="$(nproc)"; export DEB_BUILD_OPTIONS="nocheck parallel=$nproc"; apt-get build-dep -y postgresql-common-dev; apt-get source --compile postgresql-common-dev; _update_repo; apt-get build-dep -y "postgresql-$PG_MAJOR=$PG_VERSION"; apt-get source --compile "postgresql-$PG_MAJOR=$PG_VERSION"; apt-mark showmanual | xargs apt-mark auto > /dev/null; apt-mark manual $savedAptMark; ls -lAFh; _update_repo; grep '^Package: ' Packages; cd /; ;; esac; apt-get install -y --no-install-recommends postgresql-common; sed -ri 's/#(create_main_cluster) .*$/\1 = false/' /etc/postgresql-common/createcluster.conf; apt-get install -y --no-install-recommends "postgresql-$PG_MAJOR=$PG_VERSION" ; rm -rf /var/lib/apt/lists/*; if [ -n "$tempDir" ]; then apt-get purge -y --auto-remove; rm -rf "$tempDir" /etc/apt/sources.list.d/temp.list; fi; find /usr -name '*.pyc' -type f -exec bash -c 'for pyc; do dpkg -S "$pyc" &> /dev/null || rm -vf "$pyc"; done' -- '{}' +; postgres --version # buildkit |
| RUN /bin/sh -c set -eux; dpkg-divert --add --rename --divert "/usr/share/postgresql/postgresql.conf.sample.dpkg" "/usr/share/postgresql/$PG_MAJOR/postgresql.conf.sample"; cp -v /usr/share/postgresql/postgresql.conf.sample.dpkg /usr/share/postgresql/postgresql.conf.sample; ln -sv ../postgresql.conf.sample "/usr/share/postgresql/$PG_MAJOR/"; sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/share/postgresql/postgresql.conf.sample; grep -F "listen_addresses = '*'" /usr/share/postgresql/postgresql.conf.sample # buildkit |
| RUN /bin/sh -c install --verbose --directory --owner postgres --group postgres --mode 3777 /var/run/postgresql # buildkit |
| ENV PGDATA=/var/lib/postgresql/data |
| RUN /bin/sh -c install --verbose --directory --owner postgres --group postgres --mode 1777 "$PGDATA" # buildkit |
| VOLUME [/var/lib/postgresql/data] |
| COPY docker-entrypoint.sh docker-ensure-initdb.sh /usr/local/bin/ # buildkit |
| RUN /bin/sh -c ln -sT docker-ensure-initdb.sh /usr/local/bin/docker-enforce-initdb.sh # buildkit |
| ENTRYPOINT ["docker-entrypoint.sh"] |
| STOPSIGNAL SIGINT |
| EXPOSE map[5432/tcp:{}] |
| CMD ["postgres"] |
| ARG PG_MAJOR=17 |
| ADD https://github.com/pgvector/pgvector.git#v0.8.7 /tmp/pgvector # buildkit |
| RUN |1 PG_MAJOR=17 /bin/sh -c apt-get update && apt-mark hold locales && apt-get install -y --no-install-recommends build-essential postgresql-server-dev-$PG_MAJOR && cd /tmp/pgvector && make clean && make OPTFLAGS="" && make install && mkdir /usr/share/doc/pgvector && cp LICENSE README.md /usr/share/doc/pgvector && rm -r /tmp/pgvector && apt-get remove -y build-essential postgresql-server-dev-$PG_MAJOR && apt-get autoremove -y && apt-mark unhold locales && rm -rf /var/lib/apt/lists/* # buildkit |
| ARG VCS_REF=c11ca5cbceb506378bb29670558190c3103484d9 |
| LABEL org.opencontainers.image.source=https://forge.oddie.app/oddie-apps/infrastructure org.opencontainers.image.revision=c11ca5cbceb506378bb29670558190c3103484d9 org.opencontainers.image.version=0.8.7-pg17-juna.1 io.oddie.gosu.revision=29b939aa5bd4dc588af765b8248f6e39150d2565 |
| RUN |1 VCS_REF=c11ca5cbceb506378bb29670558190c3103484d9 /bin/sh -c test "${#VCS_REF}" -eq 40 && test -z "$(printf '%s' "$VCS_REF" | tr -d '0-9a-f')" # buildkit |
| COPY security-packages.txt /tmp/security-packages.txt # buildkit |
| RUN |1 VCS_REF=c11ca5cbceb506378bb29670558190c3103484d9 /bin/sh -c set -eu; dpkg-query -W -f='${binary:Package}\t${Version}\n' | sort > /tmp/packages-before; apt-get update; xargs -r apt-get install -y --no-install-recommends --only-upgrade < /tmp/security-packages.txt; while IFS='=' read -r package version; do test "$(dpkg-query -W -f='${Version}' "$package")" = "$version"; done < /tmp/security-packages.txt; dpkg-query -W -f='${binary:Package}\t${Version}\n' | sort > /tmp/packages-after; sed 's/=.*//' /tmp/security-packages.txt > /tmp/allowed-packages; comm -3 /tmp/packages-before /tmp/packages-after > /tmp/package-delta; awk 'NR==FNR {allowed[$1]=1;next} {name=$1;sub(/:[^:]*$/,"",name);if(!(name in allowed))bad=1} END{exit bad}' /tmp/allowed-packages /tmp/package-delta; cat /tmp/package-delta; rm -rf /var/lib/apt/lists/*; rm /tmp/packages-before /tmp/packages-after /tmp/allowed-packages /tmp/package-delta /tmp/security-packages.txt # buildkit |
| COPY /out/gosu /usr/local/bin/gosu # buildkit |
| ENV GOSU_VERSION=1.20 |
| COPY verify.sh /tmp/verify-hindsight-postgres.sh # buildkit |
| RUN |1 VCS_REF=c11ca5cbceb506378bb29670558190c3103484d9 /bin/sh -c sh /tmp/verify-hindsight-postgres.sh && rm /tmp/verify-hindsight-postgres.sh # buildkit |
Labels
| Key | Value |
|---|---|
| io.oddie.gosu.revision | 29b939aa5bd4dc588af765b8248f6e39150d2565 |
| org.opencontainers.image.revision | c11ca5cbceb506378bb29670558190c3103484d9 |
| org.opencontainers.image.source | https://forge.oddie.app/oddie-apps/infrastructure |
| org.opencontainers.image.version | 0.8.7-pg17-juna.1 |
Details
Versions (2)
View all