Namespace
supabase
Image / Tag
postgres:15.8.1.049-rc-1
Content Digest
sha256:8d2b9a3c508910881a289490c49c9c8b1e30e0213c7f7f89fba23e2ebc37f6d4
Details
Created

2025-03-12 11:22:54 UTC

Size

634 MB

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

Environment
LANG

en_US.UTF-8

LANGUAGE

en_US:en

LC_ALL

en_US.UTF-8

LC_COLLATE

C.UTF-8

LC_CTYPE

C.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_USER

supabase_admin


Layers

[#000] sha256:d9802f032d6798e2086607424bfe88cb8ec1d6f116e11cd99592dcaf261e9cd2 - 4.14% (26.2 MB)

[#001] sha256:d15f3e096291f7a8a05e4ffabc4f17f0192b1496affae055136c5c1bc8b949e6 - 13.33% (84.6 MB)

[#002] sha256:cedd005d50f5202fd8c3766e6d5b7620012983032cb8741f62ab2b6f2a13e84e - 0.0% (1.53 KB)

[#003] sha256:2737d896dc4aef38b1ca7cf386810b1d573c19ed94cc19e224868511e73c5d76 - 0.0% (1.55 KB)

[#004] sha256:e90904d0f238cf51c3d48576e1ea8f715c8b7f7a74cac43a243152f9f20c7e2a - 11.02% (69.9 MB)

[#005] sha256:8340a967d3059550242a32c9d3deb15b76e74e1d04db5b6d8ec131d6b80e66dd - 0.07% (454 KB)

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

[#007] sha256:6ac75428e413bfbeedbfc938e886aefee481dabdc2c5dd668b640f11edd86ed6 - 51.65% (328 MB)

[#008] sha256:2b2c3b77c67b2fa391a1f0482610fbd1e551f2abf09000dfb8a10d3eb9c2ec0b - 0.26% (1.62 MB)

[#009] sha256:04284666caae168822f71090f1ac04072f7f5584d4e966fe0b1c5a50d41fffdf - 0.0% (255 Bytes)

[#010] sha256:344b8357f31a3a52457e5b1ba99f81034b5173dcd3dd24f960e3ffd04a27cb0f - 2.53% (16 MB)

[#011] sha256:93d10630b71c8a0806939d72584f194c25f9b1d3434c111faa3eaa634915dfd5 - 0.0% (615 Bytes)

[#012] sha256:227950fe6d86b8f18f11ab20e442ea7594d102f1a2bc6bf88b6d337d4f804c82 - 0.0% (595 Bytes)

[#013] sha256:fb8fc752e8ad7168559d566f2f4efca443d2edbbb66ff4689581bc4301dbbb09 - 0.0% (611 Bytes)

[#014] sha256:42b924c7f1557b6c08df0460888d1b58178b6d23dce59089a08146c91bda4a3d - 0.0% (593 Bytes)

[#015] sha256:0894a9ba2cb875f48dabc05d598bb8de620583a4ecad1ba2cf554bc45a2d2a55 - 0.12% (803 KB)

[#016] sha256:22f5624c7d275d3e0e0d0468ab2eff4e1fe2873da15fa2c211c023f64a74b3d2 - 0.0% (1.21 KB)

[#017] sha256:18299086bd304c3340df623e646f712807dd994d6ac520a7561df4f93a2a6c09 - 0.0% (288 Bytes)

[#018] sha256:bd44225c13bc0a6f64f516ec8d7c91e7553c48e426057d6a686ebbdaa14ef218 - 0.0% (1.17 KB)

[#019] sha256:1280f65bdb9414f1d100efeb6aeb46499742daa2a6f2658784daa46d6b7b0e2f - 0.07% (430 KB)

[#020] sha256:f2552525c90c5d2396bdf7a53ce6f4d3f494ace03d3916b0960a042fb7cbb6f2 - 13.34% (84.6 MB)

[#021] sha256:2ae17678aafb297669cac7f51903f0f6d3239cb7209e422233faa42da600ca0b - 0.0% (1.82 KB)

[#022] sha256:9b1685e47af5d05fb2d1594a35d21f286a55554306887d7d7f58378c7d57ffb7 - 0.15% (960 KB)

[#023] sha256:6dfbbf2d0f76169c0d5530a559fdad7be70aee8531bb57f1ea5cb0b515f1f25e - 0.0% (796 Bytes)

[#024] sha256:d15518f30886a052d88255a467381391ab9c6e9413c5dbc55921dc8b059eba41 - 0.15% (977 KB)

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

[#026] sha256:f5200be0a7b78ae0e34d35693e60155ad59bed75f27a24c6fa66e710bc4e4f33 - 1.82% (11.6 MB)

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

[#028] sha256:635675c31577d1e0411d0e7a0ea84794a085a67ab6c9055ee1882d7387055222 - 0.0% (1.85 KB)

[#029] sha256:8260162cfedde967b4a5d172a0914b8d5da208d059e920ccf0e057e0257b0e86 - 0.0% (1017 Bytes)

[#030] sha256:58513b8e6f7d8b4e3d93a7d8230f3c145fdf722c609031bfa8a243fbf8667efd - 0.0% (277 Bytes)

[#031] sha256:f9b4d4a6fdfd484a384755abb1a8c0b24921ee59e2bed6870499f8516e7492f6 - 0.0% (1.32 KB)

[#032] sha256:82b7b364f8c56ceafe95ce9214f07f3cc853c8ae77a08442cb0515d20921fcf9 - 0.0% (3.58 KB)

[#033] sha256:47a7234f52fd94ea65a3b7bb78ec7607f9ee772aa3643946252e43cb965ac932 - 0.0% (363 Bytes)

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

[#035] sha256:82b43b763a9fe06eb405a50f3f1d237267ed2d9e342b42ca42fb0c349595367e - 0.0% (393 Bytes)

[#036] sha256:9673e52badafc9aa393acc18458a8b500bf73227c580f06a45fa57ce3f51f073 - 0.0% (398 Bytes)

[#037] sha256:b0847178720149525aa8e49bbc845f88d7e5b784066bc9268e9663d9a8ba668f - 0.0% (637 Bytes)

[#038] sha256:a57cf345d1b95e058954602fb4bd7a21ff340b8097e2b41635e4525790ea9d98 - 0.0% (9.06 KB)

[#039] sha256:a6fb512b363a67be8303ed6db81a2713a3c6228d433c3c3ddd2385e80ce8ffd1 - 0.0% (11.9 KB)

[#040] sha256:176879308df1a5e3668d8646c738842ed8049b0697294eed58168073b12338a8 - 0.0% (510 Bytes)

[#041] sha256:08290ca69f5721b56de6897d2cdd289a5534445518252a48487174cdc5b01686 - 0.0% (272 Bytes)

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

[#043] sha256:1e77dfa7984a5f5efd5137ecbfc7c313671c42b083aeaa81c19edb310c68896e - 0.0% (4.81 KB)

[#044] sha256:85999bb7841c8354b39dde5e7ed7ea13410a07330d64a001a1f517339b354f14 - 0.0% (127 Bytes)

[#045] sha256:b2a2104be8e16bdcc03887495911beac56947722fd9a0e106b5c2dafc94cba1d - 1.12% (7.1 MB)

[#046] sha256:f142897f81a25bb77241d42fda344e53bd4621b0e53ab3d583bc90a333441e35 - 0.24% (1.5 MB)


History
2024-10-11 03:38:25 UTC

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

2024-10-11 03:38:25 UTC

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

2024-10-11 03:38:25 UTC

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

2024-10-11 03:38:25 UTC

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

2024-10-11 03:38:27 UTC

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

2024-10-11 03:38:27 UTC

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

2025-03-12 11:21:32 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:21:33 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-03-12 11:21:33 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:21:38 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-03-12 11:21:38 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-03-12 11:21:38 UTC (buildkit.dockerfile.v0)

COPY . /nixpg # buildkit

2025-03-12 11:21:38 UTC (buildkit.dockerfile.v0)

WORKDIR /nixpg

2025-03-12 11:22:15 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:25 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:25 UTC (buildkit.dockerfile.v0)

WORKDIR /

2025-03-12 11:22:25 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-03-12 11:22:25 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-03-12 11:22:25 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:25 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:25 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:25 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:25 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /usr/lib/postgresql/share/postgresql/contrib && find /nix/var/nix/profiles/default/share/postgresql/contrib/ -mindepth 1 -type d -exec sh -c 'for dir do ln -s "$dir" "/usr/lib/postgresql/share/postgresql/contrib/$(basename "$dir")"; done' sh {} + && chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/contrib/ # buildkit

2025-03-12 11:22:25 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:25 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:28 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:28 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:40 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:40 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2025-03-12 11:22:40 UTC (buildkit.dockerfile.v0)

ARG TARGETARCH

2025-03-12 11:22:43 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-03-12 11:22:43 UTC (buildkit.dockerfile.v0)

ARG GOSU_VERSION=1.16

2025-03-12 11:22:43 UTC (buildkit.dockerfile.v0)

ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4

2025-03-12 11:22:43 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:43 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 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-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 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 '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-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_HOST=/var/run/postgresql

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_USER=supabase_admin

2025-03-12 11:22:46 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_DB=postgres

2025-03-12 11:22:53 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-03-12 11:22:54 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-03-12 11:22:54 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.UTF-8

2025-03-12 11:22:54 UTC (buildkit.dockerfile.v0)

ENV LANGUAGE=en_US:en

2025-03-12 11:22:54 UTC (buildkit.dockerfile.v0)

ENV LC_ALL=en_US.UTF-8

2025-03-12 11:22:54 UTC (buildkit.dockerfile.v0)

ENV LC_CTYPE=C.UTF-8

2025-03-12 11:22:54 UTC (buildkit.dockerfile.v0)

ENV LC_COLLATE=C.UTF-8

2025-03-12 11:22:54 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:22:54 UTC (buildkit.dockerfile.v0)

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

Details
Created

2025-03-12 11:30:29 UTC

Size

606 MB

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

Environment
LANG

en_US.UTF-8

LANGUAGE

en_US:en

LC_ALL

en_US.UTF-8

LC_COLLATE

C.UTF-8

LC_CTYPE

C.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_USER

supabase_admin


Layers

[#000] sha256:1b9f3c55f9d4aa5c52eb67a4cb7d0f4726ab85a413b50e3e3fe788befce3d297 - 4.09% (24.8 MB)

[#001] sha256:473c2b69c7613ac6b36c56a317ba0f12cef4b48815ae0aa67ff7f0ba83651d18 - 11.92% (72.2 MB)

[#002] sha256:5b479f70c6ac0a990f8be18af659c8a5000ce9c86858bef0e2a3df602e134f15 - 0.0% (1.53 KB)

[#003] sha256:baa84f00411a807e65653c94fd51f08ed89532c3b84d31c6a7da067a40efbc0e - 0.0% (1.55 KB)

[#004] sha256:4546ed31b4f38643f2719fac25121fdce13409b355fe86edc5525afff7bf0c7a - 11.2% (67.8 MB)

[#005] sha256:7986b585260de4baf47828857768c5c0c6e9bfd90765b201ecba6c3d5ddb8984 - 0.07% (454 KB)

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

[#007] sha256:3d0aa6186d26e5a66a0dd995756918e9ebfd1bcce8163623b7868d3e9603cfd6 - 53.38% (323 MB)

[#008] sha256:9b1ff2520cadfd3ad0993a6e2e57a92058e912dd683d6c0baac2f7c37a5d9f26 - 0.27% (1.62 MB)

[#009] sha256:73b8e6b97bf10c10fba7498cb9f264e545c01917ad0d296ee1f50f8d0ea46017 - 0.0% (256 Bytes)

[#010] sha256:c9a56e3295cddb7cc96f236be5334e1ce6b4d63ee64b7679dabf45a15ba43eb3 - 2.62% (15.9 MB)

[#011] sha256:caa3905e0059c643593a43bc8eae4ca511d30bd39a398126228a10e6866ce2f5 - 0.0% (619 Bytes)

[#012] sha256:23a064229b8bd123cb219265de034bb008d97b3d72bf7f62a43fb1cf2da02e78 - 0.0% (601 Bytes)

[#013] sha256:a2f2b5761afbb4819fb15858b6af8b103b47d42adf07a88290b62d6b4186e348 - 0.0% (615 Bytes)

[#014] sha256:e9b6ad7a808230a06ab8c76fdf2055267692aca7d0fe50ed8df7313149463452 - 0.0% (599 Bytes)

[#015] sha256:11b9d1dd9003e2de4083127665badc93bd978ffa23aa1b5825b11388c066556b - 0.13% (803 KB)

[#016] sha256:34e72809bd0e188212d42a4aac6b4e2b1622d3c4b830748f63726a73a911c9d7 - 0.0% (1.21 KB)

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

[#018] sha256:e19c7b02bfa75f30591b6854bcc9e90adcab8cad27e5bc9b663fe81f8bae06da - 0.0% (1.17 KB)

[#019] sha256:24c11fb63a945677ba94afebdf28092505e3d803ead70bf7a0b2cbb0894a65d8 - 0.07% (430 KB)

[#020] sha256:8f921208bbb0f28e85a808b3dbf59bba751be87d926c19f9d3fe75d19f88e245 - 12.62% (76.5 MB)

[#021] sha256:929b201382f8676ef1cc3c694dde95552bfba9c2131babd09dfa56ec1cc5b3fd - 0.0% (1.82 KB)

[#022] sha256:6cb97655264641972a0335df09d8fb4cd86327844025dc1c2bce2dd5654b4d9d - 0.14% (892 KB)

[#023] sha256:4c7dcc72ac33e95ccb5326a18d419a8d67161c84f1daf3cfb7743667b7048b54 - 0.0% (798 Bytes)

[#024] sha256:152d6d2ee5ba3ebbb74c716ca16d6bb87e1ca18820d81489b42194f645a72563 - 0.15% (909 KB)

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

[#026] sha256:588ac4345f9718990fdd738440e278f6c9bbd7ac8d17b0944770fdcc72211c9f - 1.91% (11.6 MB)

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

[#028] sha256:8736ed3f00c688d56909b0444fa5fbd088ed398935671188e4aa91f27f042f0a - 0.0% (1.85 KB)

[#029] sha256:0819b36c79189ca26f7e0bd43d5dfc97492d1e77ca361ab8573a2aa3a0abf90d - 0.0% (1016 Bytes)

[#030] sha256:7e0c21518aa10c90e8eb3d40e8224d99623f5e9fe81c310634b67f4a0fe36390 - 0.0% (277 Bytes)

[#031] sha256:56fc62d124a0e8526c0bf2c4b047c8438caf1706f9b98bfb98266566f2a9d888 - 0.0% (1.32 KB)

[#032] sha256:eb4dd7d2bf1c5782d4e6d2433074ad69c8f5fc588594aa46f5f1df2a8cb5e44d - 0.0% (3.58 KB)

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

[#034] sha256:7070e25054b623be57cd2efcad871ba0eb73627a402c0a8f0337cc7b700261f0 - 0.0% (335 Bytes)

[#035] sha256:57af50f0584bfd5d79c8f48db4414e60663b9da0af80f1eaa072f15e22d6cd4c - 0.0% (394 Bytes)

[#036] sha256:54e769640c47fe3835336cbbf8a5930c47b4d2401e30b2e163697277421ba249 - 0.0% (398 Bytes)

[#037] sha256:5cced8bd287144b9257931ece24405db064ac148eb960cfe70cd7952354459d0 - 0.0% (638 Bytes)

[#038] sha256:8b366b18b9b440c294451f182fec4c948d1abd6f682a12fc8a23a0614a2ca9b5 - 0.0% (9.06 KB)

[#039] sha256:5f3f55faa14772f1e808efdf347ff76625f5d8336835a97bdf401b9f5b3a0ddb - 0.0% (11.9 KB)

[#040] sha256:2c5d9bdbe4a001d16c5dcac024a246703b044651db092860a813ea9295d859f7 - 0.0% (510 Bytes)

[#041] sha256:1d507ec2689f2916cfe358c3733fce1f1930b6022c220a5b097119821af811a0 - 0.0% (273 Bytes)

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

[#043] sha256:f51173c225b3c6169d8c6c2eef47d74ffdb16d35cfe9d677379113dfcc1ac047 - 0.0% (4.82 KB)

[#044] sha256:067754ee0a85316a63d2e29130cae4386033b2d89c679deeee28ad282a19d029 - 0.0% (127 Bytes)

[#045] sha256:67d9788e113a4319296a1b079f5b065ebe76b49289d3b77523ab8ac6cf630054 - 1.17% (7.1 MB)

[#046] sha256:2cdd22a335e4d44dff099b3fd1c912b5919999e1badf11c5fb8c93abacb35bcc - 0.25% (1.5 MB)


History
2024-10-11 03:39:45 UTC

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

2024-10-11 03:39:45 UTC

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

2024-10-11 03:39:45 UTC

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

2024-10-11 03:39:45 UTC

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

2024-10-11 03:39:47 UTC

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

2024-10-11 03:39:47 UTC

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

2025-03-12 11:28:16 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:28:16 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-03-12 11:28:16 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:28:21 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-03-12 11:28:21 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-03-12 11:28:21 UTC (buildkit.dockerfile.v0)

COPY . /nixpg # buildkit

2025-03-12 11:28:21 UTC (buildkit.dockerfile.v0)

WORKDIR /nixpg

2025-03-12 11:29:07 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:29:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:29:12 UTC (buildkit.dockerfile.v0)

WORKDIR /

2025-03-12 11:29: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-03-12 11:29:13 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-03-12 11:29:13 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:29:13 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:29:13 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:29:13 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:29:13 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /usr/lib/postgresql/share/postgresql/contrib && find /nix/var/nix/profiles/default/share/postgresql/contrib/ -mindepth 1 -type d -exec sh -c 'for dir do ln -s "$dir" "/usr/lib/postgresql/share/postgresql/contrib/$(basename "$dir")"; done' sh {} + && chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/contrib/ # buildkit

2025-03-12 11:29:13 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:29:14 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:29:37 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:29:37 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:07 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:07 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2025-03-12 11:30:07 UTC (buildkit.dockerfile.v0)

ARG TARGETARCH

2025-03-12 11:30:10 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-03-12 11:30:10 UTC (buildkit.dockerfile.v0)

ARG GOSU_VERSION=1.16

2025-03-12 11:30:10 UTC (buildkit.dockerfile.v0)

ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4

2025-03-12 11:30:10 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:10 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 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-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 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 '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-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_HOST=/var/run/postgresql

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_USER=supabase_admin

2025-03-12 11:30:12 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_DB=postgres

2025-03-12 11:30:26 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-03-12 11:30:29 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-03-12 11:30:29 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.UTF-8

2025-03-12 11:30:29 UTC (buildkit.dockerfile.v0)

ENV LANGUAGE=en_US:en

2025-03-12 11:30:29 UTC (buildkit.dockerfile.v0)

ENV LC_ALL=en_US.UTF-8

2025-03-12 11:30:29 UTC (buildkit.dockerfile.v0)

ENV LC_CTYPE=C.UTF-8

2025-03-12 11:30:29 UTC (buildkit.dockerfile.v0)

ENV LC_COLLATE=C.UTF-8

2025-03-12 11:30:29 UTC (buildkit.dockerfile.v0)

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

2025-03-12 11:30:29 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