Namespace
supabase
Image / Tag
postgres:17.5.1.026-orioledb
Content Digest
sha256:dde025dbe000eb8d4eb2651566b62796c88c9419529447f5f92824c3c0bfc8b2
Details
Created

2025-09-16 22:11:53 UTC

Size

764 MB

Content Digest
Labels
  • org.opencontainers.image.ref.name
    ubuntu
  • org.opencontainers.image.version
    24.04

Environment
LANG

en_US.UTF-8

LANGUAGE

en_US:en

LC_ALL

en_US.UTF-8

LOCALE_ARCHIVE

/usr/lib/locale/locale-archive

PATH

/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/nix/var/nix/profiles/default/bin

PGDATA

/var/lib/postgresql/data

POSTGRES_DB

postgres

POSTGRES_HOST

/var/run/postgresql

POSTGRES_INITDB_ARGS

--allow-group-access --locale-provider=icu --encoding=UTF-8 --icu-locale=en_US.UTF-8

POSTGRES_USER

supabase_admin


Layers

[#000] sha256:953cdd4133718b72c5d0a78e754c1405c02510fdb5237265f7955863f1757f83 - 3.71% (28.3 MB)

[#001] sha256:72257014275113a561f0710735f7dc3ce7d637f3e85f64a352081b8972209ce7 - 11.62% (88.9 MB)

[#002] sha256:215f14b9ab735caba8fc8e22d51450fe0697a321bac896b3709ad80ce7667786 - 0.0% (1.35 KB)

[#003] sha256:eea1650463c88f071aed65bf6e5d38018d4e7ede394a667107b8c92755e1b4e5 - 0.0% (1.37 KB)

[#004] sha256:382304219ca793a8959c860ac4c659a3bee47586d50cbcd4680bcae3b4314759 - 10.09% (77.1 MB)

[#005] sha256:7e6b63ec61a159dcacd59e84c22d485ce1e9d9c7b1d5fa81922fce791cdf1d3c - 0.08% (653 KB)

[#006] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#007] sha256:02d45f661757900bf80a28a5827807dc045f0a3b148b66598dde7b1092007d58 - 52.15% (399 MB)

[#008] sha256:8b65a3aab0e7a5dda43ace428a4441c98343d8da13928c2525bf8bd79ee2cb74 - 0.27% (2.06 MB)

[#009] sha256:7f83a806e54eddf4c403fb8a3ebaea2224fc54f8ae92f68929abe0af6e946ca3 - 0.0% (250 Bytes)

[#010] sha256:ee2b75579728d27a65e585a67085384bfc6028995f2fd46bb02cea7fea018fef - 2.06% (15.7 MB)

[#011] sha256:d96011eeb6d131b2ed2003c722626ec3b2cc9ffe1d203056fe82d58b5f8d1cc9 - 0.0% (583 Bytes)

[#012] sha256:f1f93bb61353e9f50790c32f350813eea93e4e965c544645d110022af8920045 - 0.0% (563 Bytes)

[#013] sha256:53785ad87b62a23f102a184f7a44189e59672dd0cd23e563a92fd7ef39c5bdd9 - 0.0% (578 Bytes)

[#014] sha256:a524ecbba6454da612ec82cd34b77045783a1e77b545d57c352ee5775bf97bc9 - 0.0% (561 Bytes)

[#015] sha256:2a2ba2e9465d6edd4e5e001d424747273f36a65a96f06ef25d3f69fc8c68105b - 0.04% (310 KB)

[#016] sha256:2b96d43f669583c94c130a170bcb5230c13ccdb3f5a9ec422152425e1f5ff950 - 0.0% (1.3 KB)

[#017] sha256:cc140138a11914cd2f26e0566e21eb569b362fccac2c38306c7dfd4798a3ec51 - 0.0% (290 Bytes)

[#018] sha256:a07ef7e3ee7a3197de25a0d2faee5952351d903fe402e271337562a2fdb96602 - 1.23% (9.42 MB)

[#019] sha256:a90d4a7cfd2447d4efcaa40ea143a27f84fa5b9a754197a5e7c44724cd407f3d - 0.05% (415 KB)

[#020] sha256:696ef2f8d6dd3c294248bd6e7f13cf640c819e5cc0ff274c975f2f44fbea15d1 - 15.16% (116 MB)

[#021] sha256:de916fece533b5b9be1f16adf6f6763e7bc228bc219d540cae9763dca8a96c93 - 0.0% (2.11 KB)

[#022] sha256:59b2d3433a1a08da395662e7b38405bbc14734faee02c877a51dc8e480bccb69 - 0.12% (960 KB)

[#023] sha256:3ddd034728e49480b02a8b0c71306649dbdaf7224f96b46c3d386f24d02d1588 - 0.0% (790 Bytes)

[#024] sha256:791b1f69762b0bff57fed343b5598ea5cf098289d104b7d28b13cef4e5e7e47f - 0.13% (979 KB)

[#025] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#026] sha256:83058f1a91fb86a60f5183a8d7218e71eda38ce40baafe2f2dde36942aa3446b - 2.03% (15.5 MB)

[#027] sha256:9b6e2253b8952f67f4197da55b0fe7dc9927477cd2325d506f3aeacdf06b67ac - 0.0% (8.33 KB)

[#028] sha256:bbdf1333f67bb980b8285005ab9e82fa1898bfc3cfeb4ee8f1f4a1d446c5f670 - 0.0% (1.84 KB)

[#029] sha256:41b7fe7f13f91c7b62d55582ca575fe55b304cfc0dc55deea07549a618ecc993 - 0.0% (1014 Bytes)

[#030] sha256:757d2aa103b6e20ff30b72e1806b6e2aa07f21c69126eff3cd33942760dedd60 - 0.0% (278 Bytes)

[#031] sha256:4ff796a0ec5e085312efde4f016d0fd673171d26321764c3c0382f9fe02475f0 - 0.0% (1.36 KB)

[#032] sha256:fcad8a71478eb637dcbaf8f30939009b697726da3883943cd94408e413209fa5 - 0.0% (3.76 KB)

[#033] sha256:22b24c89115c93470bca6b8c50255d9a0dd8ea2372c0868ac53cd230263f445d - 0.0% (361 Bytes)

[#034] sha256:413ee23befc7a5213142b4f4864d96f4d786b25479cdbd4c54aebaa175092640 - 0.0% (335 Bytes)

[#035] sha256:6b8a64c4ecd7977231fca2465508b9d2ce4dcc06e6f597a12bdde3597d35ab48 - 0.0% (392 Bytes)

[#036] sha256:1d4cb11acc7e36ecd4c53294118f2ff14fae3de7214ab795d9d675087a7c8bb0 - 0.0% (396 Bytes)

[#037] sha256:904cf9811a5bffd66de6930e188e835b14733894591d7850d4b16a7f07e9f5f0 - 0.0% (641 Bytes)

[#038] sha256:5d727e4e0724e826645237405a4c3f9d68e1a1081fabe5d673e1f2fee62d698a - 0.0% (9.09 KB)

[#039] sha256:ca0401b7edbd077f1032ef8ba110790cd4bc592ee8b820450f20c71bf2668e34 - 0.0% (8.37 KB)

[#040] sha256:71f330dc1088626812225b22886dd4a32455740b8a81e97ea3e99d4fe77f18d8 - 0.0% (8.37 KB)

[#041] sha256:1403b60a1257605a1ce683aba8bcc110e7f31d0415a08bdc7c12b9f344a1608d - 0.0% (1.34 KB)

[#042] sha256:d1fcc1ebb51997cc5f6caaad5a2e10b748b805a9801754375d1a6eb2f30d0fc3 - 0.0% (8.38 KB)

[#043] sha256:2636045433ee38f04a605b19389fafca848d4a8669c2e01679c6222e69af3376 - 0.0% (8.38 KB)

[#044] sha256:fccc19122c345e6c2a69277618fa5e4f8229d181a1e7eb04cf4d06d9a333456c - 0.0% (13 KB)

[#045] sha256:92a6592931f7b1fbfc2b47e983ef8465efb02b9cafb2519dd8218233dab13d61 - 0.0% (510 Bytes)

[#046] sha256:ce0026773112f44db97a9e6058414bbf012554533e368abec012e43b86f01aed - 0.0% (274 Bytes)

[#047] sha256:a5e497bdc80c197c1232c380199fe50f5d43775bbbbbe873c284af923e4f13a1 - 0.0% (228 Bytes)

[#048] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#049] sha256:4156abd6a66801e75079d2c2ab0662692ad1dedeebeba9f497afb7fc642dd367 - 0.0% (5.24 KB)

[#050] sha256:a66916974ff0168bfdc84ad56ff16e8e788c544b93b4717e49a38847a7a935c4 - 0.0% (126 Bytes)

[#051] sha256:46693508f1ca84253b4e8e4cd0faa2b7e9cc6397b224f49f5be5b5e09fff135a - 1.13% (8.66 MB)

[#052] sha256:0cd02d932ee61e3d9b2186393973c1f8e9d5856a5be627179716b128614ce533 - 0.11% (846 KB)

[#053] sha256:1d64ceda1f39b48f3ce81418d9903d43cb217e0bddfa7af8d7a1de1a5655cae3 - 0.0% (312 Bytes)


History
2025-09-10 05:42:32 UTC

/bin/sh -c #(nop) ARG RELEASE

2025-09-10 05:42:32 UTC

/bin/sh -c #(nop) ARG LAUNCHPAD_BUILD_ARCH

2025-09-10 05:42:32 UTC

/bin/sh -c #(nop) LABEL org.opencontainers.image.ref.name=ubuntu

2025-09-10 05:42:32 UTC

/bin/sh -c #(nop) LABEL org.opencontainers.image.version=24.04

2025-09-10 05:42:34 UTC

/bin/sh -c #(nop) ADD file:dafefa97de6dc66a6734ec6f05e58125ce01225cccce3f50662330c252aad518 in /

2025-09-10 05:42:34 UTC

/bin/sh -c #(nop) CMD ["/bin/bash"]

2025-09-16 22:09:05 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt update -y && apt install -y curl gnupg lsb-release software-properties-common wget sudo tree && apt clean # buildkit

2025-09-16 22:09:05 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c adduser --system --home /var/lib/postgresql --no-create-home --shell /bin/bash --group --gecos "PostgreSQL administrator" postgres # buildkit

2025-09-16 22:09:05 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c adduser --system --no-create-home --shell /bin/bash --group wal-g # buildkit

2025-09-16 22:09:12 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c curl --proto '=https' --tlsv1.2 -sSf -L https://install.determinate.systems/nix | sh -s -- install linux --init none --no-confirm --extra-conf "substituters = https://cache.nixos.org https://nix-postgres-artifacts.s3.amazonaws.com" --extra-conf "trusted-public-keys = nix-postgres-artifacts:dGZlQOvKcNEjvT7QEAJbcV6b6uk7VF/hWMjhYleiaLI=% cache.nixos.org-1:6NCHdD59X431o0gWypbMrAURkbJ16ZPMQFGspcDShjY=" # buildkit

2025-09-16 22:09:12 UTC (buildkit.dockerfile.v0)

ENV PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/nix/var/nix/profiles/default/bin

2025-09-16 22:09:12 UTC (buildkit.dockerfile.v0)

COPY . /nixpg # buildkit

2025-09-16 22:09:12 UTC (buildkit.dockerfile.v0)

WORKDIR /nixpg

2025-09-16 22:09:51 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c nix profile install .#psql_orioledb-17/bin # buildkit

2025-09-16 22:10:12 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c nix store gc # buildkit

2025-09-16 22:10:12 UTC (buildkit.dockerfile.v0)

WORKDIR /

2025-09-16 22:10:12 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /usr/lib/postgresql/bin /usr/lib/postgresql/share/postgresql /usr/share/postgresql /var/lib/postgresql && chown -R postgres:postgres /usr/lib/postgresql && chown -R postgres:postgres /var/lib/postgresql && chown -R postgres:postgres /usr/share/postgresql # buildkit

2025-09-16 22:10:12 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/bin/* /usr/lib/postgresql/bin/ && ln -s /nix/var/nix/profiles/default/bin/* /usr/bin/ && chown -R postgres:postgres /usr/bin # buildkit

2025-09-16 22:10:12 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ # buildkit

2025-09-16 22:10:12 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ # buildkit

2025-09-16 22:10:12 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/ # buildkit

2025-09-16 22:10:12 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c chown -R postgres:postgres /usr/share/postgresql/ # buildkit

2025-09-16 22:10:13 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c tree /nix > /tmp/tree.txt && cat /tmp/tree.txt && cat /tmp/tree.txt >&2 # buildkit

2025-09-16 22:10:13 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql # buildkit

2025-09-16 22:10:13 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets # buildkit

2025-09-16 22:10:18 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends tzdata # buildkit

2025-09-16 22:10:18 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -fs /usr/share/zoneinfo/Etc/UTC /etc/localtime && dpkg-reconfigure --frontend noninteractive tzdata # buildkit

2025-09-16 22:10:29 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends build-essential checkinstall cmake # buildkit

2025-09-16 22:10:29 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2025-09-16 22:10:29 UTC (buildkit.dockerfile.v0)

ARG TARGETARCH

2025-09-16 22:10:32 UTC (buildkit.dockerfile.v0)

RUN |1 TARGETARCH=amd64 /bin/sh -c apt-get update && apt-get install -y --no-install-recommends gnupg ca-certificates && rm -rf /var/lib/apt/lists/* # buildkit

2025-09-16 22:10:32 UTC (buildkit.dockerfile.v0)

ARG GOSU_VERSION=1.16

2025-09-16 22:10:32 UTC (buildkit.dockerfile.v0)

ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4

2025-09-16 22:10:32 UTC (buildkit.dockerfile.v0)

ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64 /usr/local/bin/gosu # buildkit

2025-09-16 22:10:32 UTC (buildkit.dockerfile.v0)

ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64.asc /usr/local/bin/gosu.asc # buildkit

2025-09-16 22:10:34 UTC (buildkit.dockerfile.v0)

RUN |3 TARGETARCH=amd64 GOSU_VERSION=1.16 GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4 /bin/sh -c gpg --batch --keyserver hkps://keys.openpgp.org --recv-keys $GOSU_GPG_KEY && gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu && gpgconf --kill all && chmod +x /usr/local/bin/gosu # buildkit

2025-09-16 22:10:34 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c id postgres || (echo "postgres user does not exist" && exit 1) # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY /tmp/wal-g /usr/local/bin/ # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/supautils.conf.j2 /etc/postgresql-custom/supautils.conf # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_extension_custom_scripts /etc/postgresql-custom/extension-custom-scripts # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/custom_read_replica.conf.j2 /etc/postgresql-custom/read-replica.conf # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/custom_walg.conf.j2 /etc/postgresql-custom/wal-g.conf # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY ansible/files/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.sh # buildkit

2025-09-16 22:11:39 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c sed -i -e "s|#unix_socket_directories = '/tmp'|unix_socket_directories = '/var/run/postgresql'|g" -e "s|#session_preload_libraries = ''|session_preload_libraries = 'supautils'|g" -e "s|#include = '/etc/postgresql-custom/supautils.conf'|include = '/etc/postgresql-custom/supautils.conf'|g" -e "s|#include = '/etc/postgresql-custom/wal-g.conf'|include = '/etc/postgresql-custom/wal-g.conf'|g" /etc/postgresql/postgresql.conf && echo "cron.database_name = 'postgres'" >> /etc/postgresql/postgresql.conf && echo "pgsodium.getkey_script= '/usr/lib/postgresql/bin/pgsodium_getkey.sh'" >> /etc/postgresql/postgresql.conf && echo "vault.getkey_script= '/usr/lib/postgresql/bin/pgsodium_getkey.sh'" >> /etc/postgresql/postgresql.conf && echo 'auto_explain.log_min_duration = 10s' >> /etc/postgresql/postgresql.conf && usermod -aG postgres wal-g && mkdir -p /etc/postgresql-custom && chown postgres:postgres /etc/postgresql-custom # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c sed -i 's/ timescaledb,//g;' "/etc/postgresql/postgresql.conf" # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c sed -i 's/db_user_namespace = off/#db_user_namespace = off/g;' "/etc/postgresql/postgresql.conf" # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c sed -i 's/ timescaledb,//g; s/ plv8,//g; s/ postgis,//g; s/ pgrouting,//g' "/etc/postgresql-custom/supautils.conf" # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c sed -i 's/\(shared_preload_libraries.*\)'\''\(.*\)$/\1, orioledb'\''\2/' "/etc/postgresql/postgresql.conf" # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c echo "default_table_access_method = 'orioledb'" >> "/etc/postgresql/postgresql.conf" # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/init-scripts/00-schema.sql # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/migrations/00-extension.sql # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c echo "CREATE EXTENSION orioledb;" > /docker-entrypoint-initdb.d/init-scripts/00-pre-init.sql && chown postgres:postgres /docker-entrypoint-initdb.d/init-scripts/00-pre-init.sql # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

COPY /usr/local/bin/gosu /usr/local/bin/gosu # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

ADD https://github.com/docker-library/postgres/raw/889f9447cd2dfe21cccfbe9bb7945e3b037e02d8/17/bullseye/docker-entrypoint.sh /usr/local/bin/docker-entrypoint.sh # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /var/run/postgresql && chown postgres:postgres /var/run/postgresql # buildkit

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" "0s" '\n'}

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_HOST=/var/run/postgresql

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_USER=supabase_admin

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_DB=postgres

2025-09-16 22:11:40 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_INITDB_ARGS=--allow-group-access --locale-provider=icu --encoding=UTF-8 --icu-locale=en_US.UTF-8

2025-09-16 22:11:51 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends locales && rm -rf /var/lib/apt/lists/* && localedef -i en_US -c -f UTF-8 -A /usr/share/locale/locale.alias en_US.UTF-8 && localedef -i C -c -f UTF-8 -A /usr/share/locale/locale.alias C.UTF-8 # buildkit

2025-09-16 22:11:53 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c echo "C.UTF-8 UTF-8" > /etc/locale.gen && echo "en_US.UTF-8 UTF-8" >> /etc/locale.gen && locale-gen # buildkit

2025-09-16 22:11:53 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.UTF-8

2025-09-16 22:11:53 UTC (buildkit.dockerfile.v0)

ENV LANGUAGE=en_US:en

2025-09-16 22:11:53 UTC (buildkit.dockerfile.v0)

ENV LC_ALL=en_US.UTF-8

2025-09-16 22:11:53 UTC (buildkit.dockerfile.v0)

ENV LOCALE_ARCHIVE=/usr/lib/locale/locale-archive

2025-09-16 22:11:53 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /usr/share/postgresql/extension/ && ln -s /usr/lib/postgresql/bin/pgsodium_getkey.sh /usr/share/postgresql/extension/pgsodium_getkey && chmod +x /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit

2025-09-16 22:11:53 UTC (buildkit.dockerfile.v0)

CMD ["postgres" "-D" "/etc/postgresql"]

Details
Created

2025-09-16 22:22:03 UTC

Size

756 MB

Content Digest
Labels
  • org.opencontainers.image.ref.name
    ubuntu
  • org.opencontainers.image.version
    24.04

Environment
LANG

en_US.UTF-8

LANGUAGE

en_US:en

LC_ALL

en_US.UTF-8

LOCALE_ARCHIVE

/usr/lib/locale/locale-archive

PATH

/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/nix/var/nix/profiles/default/bin

PGDATA

/var/lib/postgresql/data

POSTGRES_DB

postgres

POSTGRES_HOST

/var/run/postgresql

POSTGRES_INITDB_ARGS

--allow-group-access --locale-provider=icu --encoding=UTF-8 --icu-locale=en_US.UTF-8

POSTGRES_USER

supabase_admin


Layers

[#000] sha256:59a5d47f84c39a2d62d1b5089e60ab67303111f17e1df01dbbcc598246282797 - 3.64% (27.5 MB)

[#001] sha256:8ef29ea8ada924d5416474754429521da7d585b568c562b1fbf71b6b46bda09b - 11.88% (89.8 MB)

[#002] sha256:e2cf498acfb5976cc9dc099484f98019d25b18a3d14a9a10f087164ea4f3708c - 0.0% (1.35 KB)

[#003] sha256:d8f1eef26bd0087a40b3b9449d2b2cdce4921718e5d15e8c6126dcc004da8a50 - 0.0% (1.37 KB)

[#004] sha256:2327eda38b87a3931933424ff480750a4dea556cb92ce61723d43ec000213f45 - 9.85% (74.5 MB)

[#005] sha256:41aaa86b79aa1af4c5b0bb594023fff9dc2a1ec65ce93fc0dec7e40293cfce12 - 0.08% (653 KB)

[#006] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#007] sha256:52f6f2dbfb24200fd7265fe6140b6c00e778955863e6164e2392a44b3d36bc9b - 52.14% (394 MB)

[#008] sha256:732d5bacd578c9ed173ba35d80919eab58e968098fd58ded8bebad544d15b190 - 0.27% (2.06 MB)

[#009] sha256:db9a11f83317aa3f90bb467dc23abc1cc63ece8054442067d2526d52d430be50 - 0.0% (253 Bytes)

[#010] sha256:c74eaa8bd60ac9d4783b300a87b5cdc5294d530c97efb8f62d3c1b5c182ac78c - 2.06% (15.5 MB)

[#011] sha256:7c5cc3b0cd5be1cc50bbae64a6db0938fc0305002305d588d05ceb2335b28703 - 0.0% (586 Bytes)

[#012] sha256:4191f164bf336795101014c0ff434c838a313478ec012d1a8186eb96b545370e - 0.0% (567 Bytes)

[#013] sha256:0355abac1c0b0dae9c7db434f98ac64e285ca018133e27c1ecc12ce0dce6d7e0 - 0.0% (583 Bytes)

[#014] sha256:8322394ae82043a78f0dcc42faa52dd996aa026936dd10d60885b3e901d1d205 - 0.0% (564 Bytes)

[#015] sha256:386023987dfccf1f781b367851c7828564ab500d6356582a081286d5424d8c94 - 0.04% (309 KB)

[#016] sha256:9e54e7d8c4c1b25394f6a712088b9e1a3bd55c21198edcf31f3d4b89e81c5d15 - 0.0% (1.3 KB)

[#017] sha256:b75752bc66f99d25c2fb6973ee400e05aff18959ee8b80dda7a3ffa97d866aa6 - 0.0% (292 Bytes)

[#018] sha256:83758a60722f42b69c0e026645b98a7747577ed5b74b94b89bd7e3d104d9ac2f - 2.14% (16.2 MB)

[#019] sha256:d63d58ddee7a6a97d92b7b319ab60944c36d6a584da2fd00d5423a629f2049a5 - 0.05% (415 KB)

[#020] sha256:405df70a262e982c347d233b95551fe41acfb1dfea198b4efbd5a3fc12fdf628 - 14.44% (109 MB)

[#021] sha256:765e3e8128019e5dfdd242f8095a2b585dba830705061bc4b38d85c718db7f26 - 0.0% (2.11 KB)

[#022] sha256:4257e06eccd2b7feac32bbfacdd7c3406c534afd9633c825db631cec19984659 - 0.12% (892 KB)

[#023] sha256:9eb1d88b721053b179927dd792c7061cf2ffe8074b9c556668e78d46155ab475 - 0.0% (790 Bytes)

[#024] sha256:a54da50caad3f666bfda326a194bfdf308ce1fe3e9b82b092e7fb1586118df0a - 0.12% (913 KB)

[#025] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#026] sha256:0f351d8d7804ff10873a6c794cd44fed3ca7173de83a542b8475a0b8844020bd - 1.91% (14.5 MB)

[#027] sha256:d801e4655a4f5581e62513e76648a6d306c3791e5dd0ba481e6d2a7d46e26a3f - 0.0% (8.33 KB)

[#028] sha256:5304e73d80bc494233c9c2d7dbe1044f6948f7dec3206573051de8ca33d0f214 - 0.0% (1.84 KB)

[#029] sha256:2c1f4f438bf074dff4a08fc5e1bd28f9d71a1a3dffd8b19fc20326d3ca710808 - 0.0% (1015 Bytes)

[#030] sha256:8b1878b4504865132909cfbf640be26780948616325f674d5334fa2f124d1395 - 0.0% (275 Bytes)

[#031] sha256:79201582606248bf2ebb7758aaf6bd9e0f3cbe0ebfc39eebba54a6e6216aa0f6 - 0.0% (1.36 KB)

[#032] sha256:68e6a626097dbade8f1a13b1d87b4b1d543cc5b60f48c821ee5ca3efef0986d4 - 0.0% (3.77 KB)

[#033] sha256:69efc94be8817c833d36d868f01cb5912f4225ff00225b8141011e13e8e5b490 - 0.0% (366 Bytes)

[#034] sha256:3983e75165a311353f29194fcaebb29b245069c01b43954eeecf22b834b295f7 - 0.0% (334 Bytes)

[#035] sha256:3250359829389e5bafd2d19d1eb90b196d110db545cda3374d33455c64e7ca08 - 0.0% (393 Bytes)

[#036] sha256:fc8cfcc4d79639e8881fb4d6b0be920b5bd1e21c2781b3a83966bcc57f9ad94d - 0.0% (397 Bytes)

[#037] sha256:e1a09a0ffa655edd034ce468e059bee48a84d59533c6895ce6f4fac3776dbbd8 - 0.0% (636 Bytes)

[#038] sha256:a984bb557d99895085a0b6ea758d1df6f4297cdce3988219cd297ff311994676 - 0.0% (9.09 KB)

[#039] sha256:f4d8cb4cffae0771b6e3f4786c89dccd7b9ea673a68c6937f72d6dfd6843fc86 - 0.0% (8.37 KB)

[#040] sha256:bdf331eb2f3e81b93ec6a6e8ec783406823b6c9cf684dbb5431069ae86fe2d14 - 0.0% (8.37 KB)

[#041] sha256:2ae292186cffd31195da7025b421c5d147812d19c3f76021d21c275823794e15 - 0.0% (1.33 KB)

[#042] sha256:83b84242ae65a1b270f9eb925c5bbc5bf50729f005161b50bfd36829d9afc897 - 0.0% (8.38 KB)

[#043] sha256:293ae1951cf30cc4490c391cadd50d7162fd46f977236a19a9c0c524eb77297e - 0.0% (8.39 KB)

[#044] sha256:0348ff14cdd64b8008f81212f1cc4caf7d7fb9569c7a98b20d8a81bd2bf1dcb0 - 0.0% (13 KB)

[#045] sha256:2461733912df24c68ba8ae1afb897cfbd7d7058e3f5d3f33a24f66243f154f8b - 0.0% (507 Bytes)

[#046] sha256:2cdf7f519b7858a723825a0a6f3db0e84490b115a39991364fb8ed382be4886d - 0.0% (271 Bytes)

[#047] sha256:1d93c4412bff0fa9fe853b5c29bc0180f5083eb12f8c8ebd55e4bc7abad2c12e - 0.0% (226 Bytes)

[#048] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)

[#049] sha256:9674f114b752862f8e1dc6262c34bf3cd8ad4471e6bbf1d9fc58ac197f811475 - 0.0% (5.24 KB)

[#050] sha256:ec7efbfbd9401182ecb941486d6768fc3d9cb782f30d98ea32f81703b29fe867 - 0.0% (124 Bytes)

[#051] sha256:7e20a7cd8f0946ce21acb6ac564a1b537e6d7caaf37cd1c042fd6b04149b5510 - 1.13% (8.57 MB)

[#052] sha256:3ca4c5bb2bb4e33341940d8124e79aaed2a26c70b7487bff669a363e2ecf0d91 - 0.11% (846 KB)

[#053] sha256:e6f7d8d1dd40f05422dcffde95832ba0fd1e26e2420239e21a026ed19b226271 - 0.0% (309 Bytes)


History
2025-09-10 05:45:34 UTC

/bin/sh -c #(nop) ARG RELEASE

2025-09-10 05:45:34 UTC

/bin/sh -c #(nop) ARG LAUNCHPAD_BUILD_ARCH

2025-09-10 05:45:34 UTC

/bin/sh -c #(nop) LABEL org.opencontainers.image.ref.name=ubuntu

2025-09-10 05:45:34 UTC

/bin/sh -c #(nop) LABEL org.opencontainers.image.version=24.04

2025-09-10 05:45:38 UTC

/bin/sh -c #(nop) ADD file:4e55519deacaaab35bcc389ec63f319a61c50e3f8f7d19a0df61fa1571c86c6a in /

2025-09-10 05:45:39 UTC

/bin/sh -c #(nop) CMD ["/bin/bash"]

2025-09-16 22:10:40 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt update -y && apt install -y curl gnupg lsb-release software-properties-common wget sudo tree && apt clean # buildkit

2025-09-16 22:10:40 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c adduser --system --home /var/lib/postgresql --no-create-home --shell /bin/bash --group --gecos "PostgreSQL administrator" postgres # buildkit

2025-09-16 22:10:40 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c adduser --system --no-create-home --shell /bin/bash --group wal-g # buildkit

2025-09-16 22:10:48 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c curl --proto '=https' --tlsv1.2 -sSf -L https://install.determinate.systems/nix | sh -s -- install linux --init none --no-confirm --extra-conf "substituters = https://cache.nixos.org https://nix-postgres-artifacts.s3.amazonaws.com" --extra-conf "trusted-public-keys = nix-postgres-artifacts:dGZlQOvKcNEjvT7QEAJbcV6b6uk7VF/hWMjhYleiaLI=% cache.nixos.org-1:6NCHdD59X431o0gWypbMrAURkbJ16ZPMQFGspcDShjY=" # buildkit

2025-09-16 22:10:49 UTC (buildkit.dockerfile.v0)

ENV PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/nix/var/nix/profiles/default/bin

2025-09-16 22:10:49 UTC (buildkit.dockerfile.v0)

COPY . /nixpg # buildkit

2025-09-16 22:10:49 UTC (buildkit.dockerfile.v0)

WORKDIR /nixpg

2025-09-16 22:11:24 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c nix profile install .#psql_orioledb-17/bin # buildkit

2025-09-16 22:13:49 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c nix store gc # buildkit

2025-09-16 22:13:49 UTC (buildkit.dockerfile.v0)

WORKDIR /

2025-09-16 22:13:50 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /usr/lib/postgresql/bin /usr/lib/postgresql/share/postgresql /usr/share/postgresql /var/lib/postgresql && chown -R postgres:postgres /usr/lib/postgresql && chown -R postgres:postgres /var/lib/postgresql && chown -R postgres:postgres /usr/share/postgresql # buildkit

2025-09-16 22:13:51 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/bin/* /usr/lib/postgresql/bin/ && ln -s /nix/var/nix/profiles/default/bin/* /usr/bin/ && chown -R postgres:postgres /usr/bin # buildkit

2025-09-16 22:13:51 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ # buildkit

2025-09-16 22:13:51 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ # buildkit

2025-09-16 22:13:52 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/ # buildkit

2025-09-16 22:13:52 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c chown -R postgres:postgres /usr/share/postgresql/ # buildkit

2025-09-16 22:13:52 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c tree /nix > /tmp/tree.txt && cat /tmp/tree.txt && cat /tmp/tree.txt >&2 # buildkit

2025-09-16 22:13:52 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql # buildkit

2025-09-16 22:13:53 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets # buildkit

2025-09-16 22:13:57 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends tzdata # buildkit

2025-09-16 22:13:57 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c ln -fs /usr/share/zoneinfo/Etc/UTC /etc/localtime && dpkg-reconfigure --frontend noninteractive tzdata # buildkit

2025-09-16 22:14:10 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends build-essential checkinstall cmake # buildkit

2025-09-16 22:14:10 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2025-09-16 22:14:10 UTC (buildkit.dockerfile.v0)

ARG TARGETARCH

2025-09-16 22:14:13 UTC (buildkit.dockerfile.v0)

RUN |1 TARGETARCH=arm64 /bin/sh -c apt-get update && apt-get install -y --no-install-recommends gnupg ca-certificates && rm -rf /var/lib/apt/lists/* # buildkit

2025-09-16 22:14:13 UTC (buildkit.dockerfile.v0)

ARG GOSU_VERSION=1.16

2025-09-16 22:14:13 UTC (buildkit.dockerfile.v0)

ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4

2025-09-16 22:14:13 UTC (buildkit.dockerfile.v0)

ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-arm64 /usr/local/bin/gosu # buildkit

2025-09-16 22:14:13 UTC (buildkit.dockerfile.v0)

ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-arm64.asc /usr/local/bin/gosu.asc # buildkit

2025-09-16 22:14:16 UTC (buildkit.dockerfile.v0)

RUN |3 TARGETARCH=arm64 GOSU_VERSION=1.16 GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4 /bin/sh -c gpg --batch --keyserver hkps://keys.openpgp.org --recv-keys $GOSU_GPG_KEY && gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu && gpgconf --kill all && chmod +x /usr/local/bin/gosu # buildkit

2025-09-16 22:14:16 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c id postgres || (echo "postgres user does not exist" && exit 1) # buildkit

2025-09-16 22:21:50 UTC (buildkit.dockerfile.v0)

COPY /tmp/wal-g /usr/local/bin/ # buildkit

2025-09-16 22:21:50 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit

2025-09-16 22:21:50 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit

2025-09-16 22:21:50 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit

2025-09-16 22:21:50 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit

2025-09-16 22:21:50 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/supautils.conf.j2 /etc/postgresql-custom/supautils.conf # buildkit

2025-09-16 22:21:50 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_extension_custom_scripts /etc/postgresql-custom/extension-custom-scripts # buildkit

2025-09-16 22:21:50 UTC (buildkit.dockerfile.v0)

COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit

2025-09-16 22:21:50 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/custom_read_replica.conf.j2 /etc/postgresql-custom/read-replica.conf # buildkit

2025-09-16 22:21:50 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/custom_walg.conf.j2 /etc/postgresql-custom/wal-g.conf # buildkit

2025-09-16 22:21:51 UTC (buildkit.dockerfile.v0)

COPY ansible/files/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit

2025-09-16 22:21:51 UTC (buildkit.dockerfile.v0)

COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.sh # buildkit

2025-09-16 22:21:51 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c sed -i -e "s|#unix_socket_directories = '/tmp'|unix_socket_directories = '/var/run/postgresql'|g" -e "s|#session_preload_libraries = ''|session_preload_libraries = 'supautils'|g" -e "s|#include = '/etc/postgresql-custom/supautils.conf'|include = '/etc/postgresql-custom/supautils.conf'|g" -e "s|#include = '/etc/postgresql-custom/wal-g.conf'|include = '/etc/postgresql-custom/wal-g.conf'|g" /etc/postgresql/postgresql.conf && echo "cron.database_name = 'postgres'" >> /etc/postgresql/postgresql.conf && echo "pgsodium.getkey_script= '/usr/lib/postgresql/bin/pgsodium_getkey.sh'" >> /etc/postgresql/postgresql.conf && echo "vault.getkey_script= '/usr/lib/postgresql/bin/pgsodium_getkey.sh'" >> /etc/postgresql/postgresql.conf && echo 'auto_explain.log_min_duration = 10s' >> /etc/postgresql/postgresql.conf && usermod -aG postgres wal-g && mkdir -p /etc/postgresql-custom && chown postgres:postgres /etc/postgresql-custom # buildkit

2025-09-16 22:21:51 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c sed -i 's/ timescaledb,//g;' "/etc/postgresql/postgresql.conf" # buildkit

2025-09-16 22:21:51 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c sed -i 's/db_user_namespace = off/#db_user_namespace = off/g;' "/etc/postgresql/postgresql.conf" # buildkit

2025-09-16 22:21:51 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c sed -i 's/ timescaledb,//g; s/ plv8,//g; s/ postgis,//g; s/ pgrouting,//g' "/etc/postgresql-custom/supautils.conf" # buildkit

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c sed -i 's/\(shared_preload_libraries.*\)'\''\(.*\)$/\1, orioledb'\''\2/' "/etc/postgresql/postgresql.conf" # buildkit

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c echo "default_table_access_method = 'orioledb'" >> "/etc/postgresql/postgresql.conf" # buildkit

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/init-scripts/00-schema.sql # buildkit

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/migrations/00-extension.sql # buildkit

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c echo "CREATE EXTENSION orioledb;" > /docker-entrypoint-initdb.d/init-scripts/00-pre-init.sql && chown postgres:postgres /docker-entrypoint-initdb.d/init-scripts/00-pre-init.sql # buildkit

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

COPY /usr/local/bin/gosu /usr/local/bin/gosu # buildkit

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

ADD https://github.com/docker-library/postgres/raw/889f9447cd2dfe21cccfbe9bb7945e3b037e02d8/17/bullseye/docker-entrypoint.sh /usr/local/bin/docker-entrypoint.sh # buildkit

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /var/run/postgresql && chown postgres:postgres /var/run/postgresql # buildkit

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" "0s" '\n'}

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_HOST=/var/run/postgresql

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_USER=supabase_admin

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_DB=postgres

2025-09-16 22:21:52 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_INITDB_ARGS=--allow-group-access --locale-provider=icu --encoding=UTF-8 --icu-locale=en_US.UTF-8

2025-09-16 22:22:01 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends locales && rm -rf /var/lib/apt/lists/* && localedef -i en_US -c -f UTF-8 -A /usr/share/locale/locale.alias en_US.UTF-8 && localedef -i C -c -f UTF-8 -A /usr/share/locale/locale.alias C.UTF-8 # buildkit

2025-09-16 22:22:03 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c echo "C.UTF-8 UTF-8" > /etc/locale.gen && echo "en_US.UTF-8 UTF-8" >> /etc/locale.gen && locale-gen # buildkit

2025-09-16 22:22:03 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.UTF-8

2025-09-16 22:22:03 UTC (buildkit.dockerfile.v0)

ENV LANGUAGE=en_US:en

2025-09-16 22:22:03 UTC (buildkit.dockerfile.v0)

ENV LC_ALL=en_US.UTF-8

2025-09-16 22:22:03 UTC (buildkit.dockerfile.v0)

ENV LOCALE_ARCHIVE=/usr/lib/locale/locale-archive

2025-09-16 22:22:03 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /usr/share/postgresql/extension/ && ln -s /usr/lib/postgresql/bin/pgsodium_getkey.sh /usr/share/postgresql/extension/pgsodium_getkey && chmod +x /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit

2025-09-16 22:22:03 UTC (buildkit.dockerfile.v0)

CMD ["postgres" "-D" "/etc/postgresql"]

Danger Zone
Delete Tag

Please be careful as this will not just delete the reference but also the actual content!

For example when you have latest and v1.2.3 both pointing to the same image
the deletion of latest will also permanently remove v1.2.3.

Delete