supabase-operator/postgres (sha256:f37c477d3449446e6f2954179ed468c9112458a5f815eac0e57818fbd0573b2a)

Published 2025-03-04 02:33:32 +00:00 by prskr in prskr/supabase-operator

Pull the image from the command line:

docker pull code.icb4dc0.de/prskr/supabase-operator/postgres@sha256:f37c477d3449446e6f2954179ed468c9112458a5f815eac0e57818fbd0573b2a

Digest

sha256:f37c477d3449446e6f2954179ed468c9112458a5f815eac0e57818fbd0573b2a

For more information on the Container registry, see the documentation.

A standard PostgreSQL 17.2 container image

# debian.sh --arch 'amd64' out/ 'bookworm' '@1736726400'

ARG PG_VERSION=17.2

ARG PG_MAJOR=17

ENV PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin

RUN |2 PG_VERSION=17.2 PG_MAJOR=17 /bin/sh -c apt-get update && apt-get install -y --no-install-recommends postgresql-common ca-certificates gnupg && /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh -y && apt-get install -y --no-install-recommends -o Dpkg::::="--force-confdef" -o Dpkg::::="--force-confold" postgresql-common && sed -ri 's/#(create_main_cluster) .*$/\1 = false/' /etc/postgresql-common/createcluster.conf && apt-get install -y --no-install-recommends -o Dpkg::::="--force-confdef" -o Dpkg::::="--force-confold" "postgresql-${PG_MAJOR}=${PG_VERSION}*" && apt-get purge -y --auto-remove -o APT::AutoRemove::RecommendsImportant=false && rm -rf /var/lib/apt/lists/* /var/cache/* /var/log/* # buildkit

RUN |2 PG_VERSION=17.2 PG_MAJOR=17 /bin/sh -c usermod -u 26 postgres # buildkit

USER 26

USER root

RUN |2 PG_VERSION=17.2 PG_MAJOR=17 /bin/sh -c apt-get update && apt-get install -y --no-install-recommends locales-all "postgresql-${PG_MAJOR}-pgaudit" "postgresql-${PG_MAJOR}-pgvector" "postgresql-${PG_MAJOR}-pg-failover-slots" && apt-get purge -y --auto-remove -o APT::AutoRemove::RecommendsImportant=false && rm -rf /var/lib/apt/lists/* /var/cache/* /var/log/* # buildkit

USER 26

ENV DEBIAN_FRONTEND=noninteractive

ARG POSTGRES_MAJOR=17

USER root

RUN |1 POSTGRES_MAJOR=17 /bin/sh -c apt-get update && apt-get install --yes --no-install-recommends libsodium23 postgresql-${POSTGRES_MAJOR}-cron postgresql-${POSTGRES_MAJOR}-http postgresql-${POSTGRES_MAJOR}-hypopg postgresql-${POSTGRES_MAJOR}-pgrouting postgresql-${POSTGRES_MAJOR}-pgtap postgresql-${POSTGRES_MAJOR}-plpgsql-check postgresql-${POSTGRES_MAJOR}-postgis-3 postgresql-${POSTGRES_MAJOR}-wal2json postgresql-${POSTGRES_MAJOR}-rum postgresql-${POSTGRES_MAJOR}-repack postgresql-${POSTGRES_MAJOR}-timescaledb && rm -rf /var/lib/apt/lists/* # buildkit

USER 26

ARG POSTGRES_MAJOR=17

COPY /usr/lib/postgresql/17/lib/bitcode /usr/lib/postgresql/17/lib/bitcode # buildkit

COPY /usr/share/postgresql/17/extension/pgjwt* /usr/share/postgresql/17/extension/ # buildkit

COPY /usr/lib/postgresql/17/lib/safeupdate.so /usr/lib/postgresql/17/lib/ # buildkit

COPY /usr/lib/postgresql/17/lib/pg_hashids.so /usr/lib/postgresql/17/lib/ # buildkit

COPY /usr/share/postgresql/17/extension/pg_hashids* /usr/share/postgresql/17/extension/ # buildkit

COPY /usr/lib/postgresql/17/lib/pg_net.so /usr/lib/postgresql/17/lib/ # buildkit

COPY /usr/share/postgresql/17/extension/pg_net* /usr/share/postgresql/17/extension/ # buildkit

COPY /usr/lib/postgresql/17/lib/pg_graphql.so /usr/lib/postgresql/17/lib/ # buildkit

COPY /usr/share/postgresql/17/extension/pg_graphql* /usr/share/postgresql/17/extension/ # buildkit

COPY /usr/lib/postgresql/17/lib/supabase_vault.so /usr/lib/postgresql/17/lib/ # buildkit

COPY /usr/share/postgresql/17/extension/supabase_vault* /usr/share/postgresql/17/extension/ # buildkit

COPY /usr/lib/postgresql/17/lib/pg_jsonschema.so /usr/lib/postgresql/17/lib/ # buildkit

COPY /usr/share/postgresql/17/extension/pg_jsonschema* /usr/share/postgresql/17/extension/ # buildkit

COPY /usr/lib/postgresql/17/lib/wrappers-*.so /usr/lib/postgresql/17/lib/ # buildkit

COPY /usr/share/postgresql/17/extension/wrappers* /usr/share/postgresql/17/extension/ # buildkit

COPY /usr/lib/postgresql/17/lib/pgsodium.so /usr/lib/postgresql/17/lib/ # buildkit

COPY /usr/share/postgresql/17/extension/pgsodium* /usr/share/postgresql/17/extension/ # buildkit

COPY /usr/lib/postgresql/17/lib/pg_tle.so /usr/lib/postgresql/17/lib/ # buildkit

COPY /usr/share/postgresql/17/extension/pg_tle* /usr/share/postgresql/17/extension/ # buildkit

COPY /usr/lib/postgresql/17/lib/plan_filter.so /usr/lib/postgresql/17/lib/ # buildkit

COPY /usr/share/postgresql/17/extension/index_advisor* /usr/share/postgresql/17/extension/ # buildkit

Key	Value
org.opencontainers.image.authors	The CloudNativePG Contributors
org.opencontainers.image.base.digest	sha256:f70dc8d6a8b6a06824c92471a1a258030836b26b043881358b967bf73de7c5ab
org.opencontainers.image.base.name	docker.io/library/debian:bookworm-slim
org.opencontainers.image.created	2025-02-10T08:05:47Z
org.opencontainers.image.description	A standard PostgreSQL 17.2 container image
org.opencontainers.image.documentation	https://github.com/cloudnative-pg/postgres-containers
org.opencontainers.image.licenses	Apache-2.0
org.opencontainers.image.revision	8078ba781117a32fe180255ae4bedca68c375b0e
org.opencontainers.image.source	https://github.com/cloudnative-pg/postgres-containers
org.opencontainers.image.title	CloudNativePG PostgreSQL 17.2 standard
org.opencontainers.image.url	https://github.com/cloudnative-pg/postgres-containers
org.opencontainers.image.vendor	The CloudNativePG Contributors
org.opencontainers.image.version	17.2