core-docker/psql (sha256:cb1788cb7673f54176c3dfcf2779f3726581b0892049203557ef29fe4d44e2f1)

Published 2026-09-20 05:37:36 +00:00 by kjones in CoRE/Core-Docker

Installation

docker pull forge.core-dc1-talos-prod.dc1.yxl.writemy.codes/core/core-docker/psql@sha256:cb1788cb7673f54176c3dfcf2779f3726581b0892049203557ef29fe4d44e2f1
sha256:cb1788cb7673f54176c3dfcf2779f3726581b0892049203557ef29fe4d44e2f1

About this package

PostgreSQL image based on Spilo with PostgreSQL 16, 17, and 18 pgvector and VectorChord packages.

Image layers

ARG RELEASE
ARG LAUNCHPAD_BUILD_ARCH
LABEL org.opencontainers.image.ref.name=ubuntu
LABEL org.opencontainers.image.version=22.04
ADD file:b499000226bd9a7c562ffa8eeb86e2d170f2a563310db6c2d79562ab53e5cb6e in /
CMD ["/bin/bash"]
ARG DEMO=false
ARG ADDITIONAL_LOCALES=
COPY build_scripts/prepare.sh build_scripts/locales.sh /builddeps/ # buildkit
RUN |2 DEMO=false ADDITIONAL_LOCALES= /bin/sh -c bash /builddeps/prepare.sh # buildkit
COPY /usr/lib/locale/locale-archive /usr/lib/locale/locale-archive.18 # buildkit
COPY cron_unprivileged.c /builddeps/ # buildkit
COPY build_scripts/base.sh /builddeps/ # buildkit
COPY /builddeps/*.deb /builddeps/ # buildkit
ARG PGVERSION=18
ARG TIMESCALEDB_APACHE_ONLY=true
ARG TIMESCALEDB_TOOLKIT=true
ARG COMPRESS=false
ARG PGOLDVERSIONS=14 15 16 17
ARG WITH_PERL=false
ARG DEB_PG_SUPPORTED_VERSIONS=14 15 16 17 18
ENV POSTGIS_VERSION=3.6 BG_MON_COMMIT=a73c6bcd10dfdf9feaf5eabab7eb6b12d167680d PG_AUTH_MON_COMMIT=fe099eef7662cbc85b0b79191f47f52f1e96b779 PG_MON_COMMIT=13c12eeb946dc2c5537139ce75432fa62b06f0eb SET_USER=REL4_1_0 PLPROFILER=REL4_2_5 PG_PROFILE=4.10 PAM_OAUTH2=v1.0.1 PG_PERMISSIONS_COMMIT=f4b7c18676fa64236a1c8e28d34a35764e4a70e2
WORKDIR /builddeps
RUN |9 DEMO=false ADDITIONAL_LOCALES= PGVERSION=18 TIMESCALEDB_APACHE_ONLY=true TIMESCALEDB_TOOLKIT=true COMPRESS=false PGOLDVERSIONS=14 15 16 17 WITH_PERL=false DEB_PG_SUPPORTED_VERSIONS=14 15 16 17 18 /bin/sh -c bash base.sh # buildkit
COPY /builddeps/wal-g /usr/local/bin/ # buildkit
COPY build_scripts/patroni.sh build_scripts/compress_build.sh /builddeps/ # buildkit
ENV PATRONIVERSION=4.1.0
WORKDIR /
RUN |9 DEMO=false ADDITIONAL_LOCALES= PGVERSION=18 TIMESCALEDB_APACHE_ONLY=true TIMESCALEDB_TOOLKIT=true COMPRESS=false PGOLDVERSIONS=14 15 16 17 WITH_PERL=false DEB_PG_SUPPORTED_VERSIONS=14 15 16 17 18 /bin/sh -c bash /builddeps/patroni.sh # buildkit
RUN |9 DEMO=false ADDITIONAL_LOCALES= PGVERSION=18 TIMESCALEDB_APACHE_ONLY=true TIMESCALEDB_TOOLKIT=true COMPRESS=false PGOLDVERSIONS=14 15 16 17 WITH_PERL=false DEB_PG_SUPPORTED_VERSIONS=14 15 16 17 18 /bin/sh -c if [ "$COMPRESS" = "true" ]; then bash /builddeps/compress_build.sh; fi # buildkit
LABEL maintainer=Team ACID @ Zalando <team-acid@zalando.de>
ARG PGVERSION=18
ARG DEMO=false
ARG COMPRESS=false
EXPOSE [5432/tcp 8008/tcp 8080/tcp]
ENV LC_ALL=en_US.utf-8 PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/18/bin PGHOME=/home/postgres RW_DIR=/run DEMO=false
ENV WALG_ENV_DIR=/run/etc/wal-e.d/env LOG_ENV_DIR=/run/etc/log.d/env PGROOT=/home/postgres/pgdata/pgroot
ENV PGDATA=/home/postgres/pgdata/pgroot/data PGLOG=/home/postgres/pgdata/pgroot/pg_log
ENV USE_OLD_LOCALES=false
WORKDIR /home/postgres
COPY motd /etc/ # buildkit
COPY runit /etc/service/ # buildkit
COPY pgq_ticker.ini /home/postgres/ # buildkit
COPY build_scripts/post_build.sh /builddeps/ # buildkit
RUN |9 DEMO=false ADDITIONAL_LOCALES= PGVERSION=18 TIMESCALEDB_APACHE_ONLY=true TIMESCALEDB_TOOLKIT=true COMPRESS=false PGOLDVERSIONS=14 15 16 17 WITH_PERL=false DEB_PG_SUPPORTED_VERSIONS=14 15 16 17 18 /bin/sh -c sh /builddeps/post_build.sh && rm -rf /builddeps/ # buildkit
COPY scripts bootstrap major_upgrade /scripts/ # buildkit
COPY launch.sh / # buildkit
CMD ["/bin/sh" "/launch.sh" "init"]
ARG POSTGRES_MAJORS=16 17 18
ARG VCHORD_VERSION=1.1.1
USER root
RUN |2 POSTGRES_MAJORS=16 17 18 VCHORD_VERSION=1.1.1 /bin/sh -c apt-get update && apt-get install -y --no-install-recommends ca-certificates wget && for major in ${POSTGRES_MAJORS}; do apt-get install -y --no-install-recommends postgresql-${major}-pgvector; wget -O /tmp/postgresql-${major}-vchord.deb https://github.com/tensorchord/VectorChord/releases/download/${VCHORD_VERSION}/postgresql-${major}-vchord_${VCHORD_VERSION}-1_amd64.deb; done && apt-get install -y /tmp/postgresql-*-vchord.deb && rm -f /tmp/postgresql-*-vchord.deb && apt-get clean && rm -rf /var/lib/apt/lists/* # buildkit
USER postgres

Labels

Key Value
maintainer Team ACID @ Zalando <team-acid@zalando.de>
org.opencontainers.image.created 2026-09-20T05:37:25.734Z
org.opencontainers.image.description PostgreSQL image based on Spilo with PostgreSQL 16, 17, and 18 pgvector and VectorChord packages.
org.opencontainers.image.documentation https://forge.core-dc1-talos-prod.dc1.yxl.writemy.codes/CoRE/Core-Docker/src/branch/main/Images/PSQL/README.md
org.opencontainers.image.licenses
org.opencontainers.image.ref.name ubuntu
org.opencontainers.image.revision c1735122637baa4683e4b49f36e14c73462b9e58
org.opencontainers.image.source https://forge.core-dc1-talos-prod.dc1.yxl.writemy.codes/CoRE/Core-Docker
org.opencontainers.image.title PostgreSQL with vector extensions
org.opencontainers.image.url https://forge.core-dc1-talos-prod.dc1.yxl.writemy.codes/CoRE/Core-Docker
org.opencontainers.image.version core
Details
Container
2026-09-20 05:37:36 +00:00
0
OCI / Docker
linux/amd64
557 MiB
Versions (1) View all
core 2026-09-20