Namespace
supabase
Image / Tagpostgres:15.8.1.046
Content Digestsha256:344d6f163d7d1adde9f278e0ab75519a613152baac076a88b879bc0933d6c8f8
Details
2025-02-27 21:56:08 UTC
632 MB
Labels
-
org.opencontainers.image.ref.nameubuntu
-
org.opencontainers.image.version20.04
Environment
LANGen_US.UTF-8
LANGUAGEen_US:en
LC_ALLen_US.UTF-8
LC_COLLATEC.UTF-8
LC_CTYPEC.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_DBpostgres
POSTGRES_HOST/var/run/postgresql
POSTGRES_USERsupabase_admin
Layers
[#000] sha256:d9802f032d6798e2086607424bfe88cb8ec1d6f116e11cd99592dcaf261e9cd2 - 4.15% (26.2 MB)
[#001] sha256:e9b7c9a4f8b3434e15646fe4313fe41a39335e0cc151c33c942593e0d59373a6 - 13.35% (84.4 MB)
[#002] sha256:dc62e89067f8b46dc15d6cea27921ccc067b6db93620417a9570a54753d45176 - 0.0% (1.53 KB)
[#003] sha256:5ddc1ba8a475c24d337f60c34b9229a0d11db6a9c505d16072c92cdc617da847 - 0.0% (1.55 KB)
[#004] sha256:06c4722661f871a5a0d3fe17e07a1df5192e242f41f4eabf91abb7561ead9783 - 11.0% (69.6 MB)
[#005] sha256:705f1880d12b498f75ec8c63cc652b67b689c5b5ab0ff47a66585af4601692e3 - 0.07% (454 KB)
[#006] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#007] sha256:1da1c90ba1b54e68fe7f267248bef8a635dc74c0186eb1a22811e3a2413304fb - 51.82% (328 MB)
[#008] sha256:b0937f28aa2d6b0f7a1c547ad08426d1fc65bbc28f55ba5030a8b2e9328dbc53 - 0.0% (255 Bytes)
[#009] sha256:a1cf50c1d954f274ed224c202dfe21ed3f7ff72f69dc38dc90c59563bf5240a6 - 2.53% (16 MB)
[#010] sha256:de3c4811b803ffe1b8846f87d2707a12d14828ba36d871a8596e0408bb146a49 - 0.0% (618 Bytes)
[#011] sha256:67f674a70f50e78c9f2e2bb6d078aa93de4f788af164ff802224fbd2bb180f1b - 0.0% (599 Bytes)
[#012] sha256:5b0573c75baa945fafb8314d0b790fe0d7789ed86201478ac8dbf027fb2029af - 0.0% (614 Bytes)
[#013] sha256:8269f1fc700bf6968662e8067a03a9d109d36758af796d60004a6320d08ae610 - 0.0% (597 Bytes)
[#014] sha256:f4b1a67f572a36ed07f35568e64bf1aba9b5f78fba3078701280b04201245266 - 0.12% (803 KB)
[#015] sha256:4da5beb5dc3df2c2ffcfc99827069e8814647971188aed9424890d97598ff824 - 0.0% (1.21 KB)
[#016] sha256:64755fba3edf4bdb1bc284016e6dbaeb4e937a126ead20ac2088bc462587965d - 0.0% (290 Bytes)
[#017] sha256:ac262ed00f79fdbc297f48dd0dea2acdc3cffb55aa3bfda18d8c6ca5bb9a3cb4 - 0.0% (1.17 KB)
[#018] sha256:431759c4d1ec632e18fb843ba0827939d30a7b76a140b1d996f6b1da96eed64e - 0.07% (430 KB)
[#019] sha256:a1f2a5c4a2e46d71edfcd2753d3578f94c9e16d37daace335013e3deb87c96f6 - 13.38% (84.6 MB)
[#020] sha256:d1d842cf9fe02e44a901787f0789e7be647a1843144938765af6fea54e07d20a - 0.0% (1.82 KB)
[#021] sha256:bcefa4ad7a46bc26c7a7ae054a6aabfee486e8c0417c74db32945e1dc1654e03 - 0.15% (960 KB)
[#022] sha256:fb82fc1c1abf7d33a9d5d20bff1abc172cdbf45c29d7b4a4f936acffa2efe28d - 0.0% (798 Bytes)
[#023] sha256:13ee20f969de0a1f7ef0a362205638bbc7966845ce78b05fce50afc0f7ec2bd2 - 0.15% (977 KB)
[#024] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#025] sha256:5dda581a3730cccc31dfb4f27dbd93a4a61ab8d48396c7a49182f9d1fef167e3 - 1.83% (11.6 MB)
[#026] sha256:6cca9aca050b26c10c6f88c1d55b2893191a88b8886046169169217edb868824 - 0.0% (8.32 KB)
[#027] sha256:d7580a0a28ad46d55ae7f935ea306319e10d3f1d94de64db6c43ba11e75b5275 - 0.0% (1.84 KB)
[#028] sha256:06cf4b4f0f8e522e6007f68f29ab342bcd5a873d5b98c3daf2233d1956bf3d3e - 0.0% (1014 Bytes)
[#029] sha256:133828e7ac24657e3d7b1a2b6e77c319bb48b2bae1754597a09f73ed7530bd01 - 0.0% (276 Bytes)
[#030] sha256:739df023e3a30009c99d0bebe2121e3a3141a90cf309266dcd0a728544c44f09 - 0.0% (1.32 KB)
[#031] sha256:8d0f03db20e9547190de2d831a6869e6600763dc3b1574582c3956875aec61f6 - 0.0% (3.58 KB)
[#032] sha256:a393d58cc15df913354b70d99037db06dee28818b53e62d5077ee164e20ea996 - 0.0% (362 Bytes)
[#033] sha256:a2b1a58a8b6f7ddbb4a89575fcbb0b5eb1b0a4175453110ea25b06a93ffc8db9 - 0.0% (334 Bytes)
[#034] sha256:8cc158f50a93932b5fcd3d1c00ff5e5cf44285f4a4fe0eb17de76bccbc79fafd - 0.0% (392 Bytes)
[#035] sha256:a8a35bfb1d43a94c401c024e6602e447ba3b79b4f6a52f82d731525ef5782371 - 0.0% (396 Bytes)
[#036] sha256:a2a80fa19b4ab92a628bd4475c372ab8efbf3bfd5922cb721bbe49b690ed1085 - 0.0% (637 Bytes)
[#037] sha256:874d941a06854b75c511f2219f0bf14f2a3990869654181b74e3805596f79090 - 0.0% (9.06 KB)
[#038] sha256:7645e42bbed207415b519e0c0f97db416578060ab91574d074f68989cdff19ea - 0.0% (11.9 KB)
[#039] sha256:c573cb17e2ac1c3df780d9989892b3a33b8dccb35f2fc1d5232855cded62e3dc - 0.0% (507 Bytes)
[#040] sha256:dc47cb2fe78c7fc44cc03ff6a28e7402caf5ffcf471c4bfa5ea9b8b974b783d3 - 0.0% (270 Bytes)
[#041] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#042] sha256:337ac6a8e9a9a2c8c97f6cec3ede006b43a05b4a0f8e1c9f58f5158e4c84f6a6 - 0.0% (4.81 KB)
[#043] sha256:557ce1a36f9c4f429c4fa50273b38b4ade707936f2c282c5ccf3e9b792859def - 0.0% (126 Bytes)
[#044] sha256:9f05074048d56fb98702a6ea9ab0559bd287fa575a9774a291cd0b789b19d4a1 - 1.12% (7.1 MB)
[#045] sha256:d0fd2d28184aafdf799b1ccf54aecf2e909b093130bfb2e3f924293919ea6d1d - 0.24% (1.5 MB)
History
/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-02-27 21:54:44 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-02-27 21:54:44 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-02-27 21:54:44 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c adduser --system --no-create-home --shell /bin/bash --group wal-g # buildkit
2025-02-27 21:54:50 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-02-27 21:54:50 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-02-27 21:54:50 UTC (buildkit.dockerfile.v0)COPY . /nixpg # buildkit
2025-02-27 21:54:50 UTC (buildkit.dockerfile.v0)WORKDIR /nixpg
2025-02-27 21:55:34 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c nix profile install .#psql_15/bin # buildkit
2025-02-27 21:55:34 UTC (buildkit.dockerfile.v0)WORKDIR /
2025-02-27 21:55:35 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-02-27 21:55:36 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-02-27 21:55:36 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ # buildkit
2025-02-27 21:55:36 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ # buildkit
2025-02-27 21:55:36 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/ # buildkit
2025-02-27 21:55:36 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/share/postgresql/ # buildkit
2025-02-27 21:55:36 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-02-27 21:55:36 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql # buildkit
2025-02-27 21:55:36 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets # buildkit
2025-02-27 21:55:39 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends tzdata # buildkit
2025-02-27 21:55:39 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -fs /usr/share/zoneinfo/Etc/UTC /etc/localtime && dpkg-reconfigure --frontend noninteractive tzdata # buildkit
2025-02-27 21:55:52 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends build-essential checkinstall cmake # buildkit
2025-02-27 21:55:52 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2025-02-27 21:55:52 UTC (buildkit.dockerfile.v0)ARG TARGETARCH
2025-02-27 21:55:55 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-02-27 21:55:55 UTC (buildkit.dockerfile.v0)ARG GOSU_VERSION=1.16
2025-02-27 21:55:55 UTC (buildkit.dockerfile.v0)ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4
2025-02-27 21:55:55 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64 /usr/local/bin/gosu # buildkit
2025-02-27 21:55:55 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64.asc /usr/local/bin/gosu.asc # buildkit
2025-02-27 21:55:57 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-02-27 21:55:57 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c id postgres || (echo "postgres user does not exist" && exit 1) # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY /tmp/wal-g /usr/local/bin/ # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/supautils.conf.j2 /etc/postgresql-custom/supautils.conf # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_extension_custom_scripts /etc/postgresql-custom/extension-custom-scripts # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_read_replica.conf.j2 /etc/postgresql-custom/read-replica.conf # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_walg.conf.j2 /etc/postgresql-custom/wal-g.conf # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.sh # buildkit
2025-02-27 21:55:57 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-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/init-scripts/00-schema.sql # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/migrations/00-extension.sql # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)COPY /usr/local/bin/gosu /usr/local/bin/gosu # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)ADD https://github.com/docker-library/postgres/raw/master/15/bullseye/docker-entrypoint.sh /usr/local/bin/ # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /var/run/postgresql && chown postgres:postgres /var/run/postgresql # buildkit
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" "0s" '\n'}
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)ENV POSTGRES_HOST=/var/run/postgresql
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)ENV POSTGRES_USER=supabase_admin
2025-02-27 21:55:57 UTC (buildkit.dockerfile.v0)ENV POSTGRES_DB=postgres
2025-02-27 21:56:07 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-02-27 21:56:08 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-02-27 21:56:08 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.UTF-8
2025-02-27 21:56:08 UTC (buildkit.dockerfile.v0)ENV LANGUAGE=en_US:en
2025-02-27 21:56:08 UTC (buildkit.dockerfile.v0)ENV LC_ALL=en_US.UTF-8
2025-02-27 21:56:08 UTC (buildkit.dockerfile.v0)ENV LC_CTYPE=C.UTF-8
2025-02-27 21:56:08 UTC (buildkit.dockerfile.v0)ENV LC_COLLATE=C.UTF-8
2025-02-27 21:56:08 UTC (buildkit.dockerfile.v0)ENV LOCALE_ARCHIVE=/usr/lib/locale/locale-archive
2025-02-27 21:56:08 UTC (buildkit.dockerfile.v0)CMD ["postgres" "-D" "/etc/postgresql"]
Details
2025-02-27 21:59:57 UTC
614 MB
Labels
-
org.opencontainers.image.ref.nameubuntu
-
org.opencontainers.image.version20.04
Environment
LANGen_US.UTF-8
LANGUAGEen_US:en
LC_ALLen_US.UTF-8
LC_COLLATEC.UTF-8
LC_CTYPEC.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_DBpostgres
POSTGRES_HOST/var/run/postgresql
POSTGRES_USERsupabase_admin
Layers
[#000] sha256:1b9f3c55f9d4aa5c52eb67a4cb7d0f4726ab85a413b50e3e3fe788befce3d297 - 4.03% (24.8 MB)
[#001] sha256:f0fdce88d8e026aa892b38f1c848fcc812bd07d09495ecede23df9f8f66e2000 - 11.75% (72.2 MB)
[#002] sha256:be2b4f67b2f20f3c2c86be680fe1ee8c7ca92bd18498327e07e379a62bfabac8 - 0.0% (1.53 KB)
[#003] sha256:e4ef469b45ff1131d52dd9b990d582df45f2995fc8e23b01648e1972b9532e63 - 0.0% (1.55 KB)
[#004] sha256:f13cad934a108515af414b0e63e25e0836f499c769682a1436b9c93b22e7fc32 - 11.02% (67.7 MB)
[#005] sha256:370d5c6b85ef1d8ccf5ef72f847aaefdbebc8d7112fe246ff52de4258d87749a - 0.07% (454 KB)
[#006] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#007] sha256:b49f8f6094c797612d2bbca29ba64420cd7ff30d49638713a9b23210a943d6b1 - 52.67% (323 MB)
[#008] sha256:e464f80b8a355ca853a987e7e062289da4b159ed106ec8f7cdc978ef07baa03f - 0.0% (259 Bytes)
[#009] sha256:baebf40968a0ca59bebb18aad42a53f4b1dea6ad52ceb38c825fb4d00cf5b4eb - 2.59% (15.9 MB)
[#010] sha256:6868b679f46701cb331c4b7c256a53a8d80ac32e91fcf8986c6e8ee66c7c78ca - 0.0% (621 Bytes)
[#011] sha256:6655be885f89e4ee9d098cc2a2c78004fb67048737180168fa0f5f5b7ee2a0fc - 0.0% (603 Bytes)
[#012] sha256:c99b4a99c6747ac55c70e1507c3cd10c17b929a1f689d0fb104c79922c3268ec - 0.0% (618 Bytes)
[#013] sha256:06f96aa647f3b9363e7db67a2babe65911eb18796fecea8dc329cc9530956cfa - 0.0% (600 Bytes)
[#014] sha256:3fa690204ff1019ec3ec5fbac0415af65f1cc3cbed5742a31fb93159e29f3103 - 0.13% (803 KB)
[#015] sha256:72661acbeb575bf8502e61a42afc21b385f827a2722810aeb2c6ba107a01b6c6 - 0.0% (1.22 KB)
[#016] sha256:0e64791bac727ff0ea0636ac98357251a9d59582a6b82dad603514591b3d60ee - 0.0% (295 Bytes)
[#017] sha256:73e6a7486979dd219ce82faafb26a8cb7dc4befd8cc5960df59f09ad483238a1 - 1.65% (10.1 MB)
[#018] sha256:58190030edbec2fe514f6ebd1eb27db57218c1ae34dca722c29ee74e1033d716 - 0.07% (430 KB)
[#019] sha256:b3e9c7286db69f981b585ef10df65123e44a584042667fdf215e6002c7d0d191 - 12.45% (76.5 MB)
[#020] sha256:92596de59327479c57f6d4fef2a9522deb9949d864f15cacc5a6e0c0d828e2e1 - 0.0% (1.82 KB)
[#021] sha256:80ff58df12e92eba39ef92cc18124dc1b18d6d2b0f9e53b514ad595125f41e54 - 0.14% (892 KB)
[#022] sha256:6cd3679f18d821c1dcf4bead296ad1124d036429b598f2f171e751833ae16288 - 0.0% (801 Bytes)
[#023] sha256:8aeec52c4cb23a9f82c31efa1b8024a56cfb77d261f85d28dc12f9f2bdcdc021 - 0.14% (909 KB)
[#024] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#025] sha256:3db8ae028c02be6a3674a38d63dd8940475922fbbdf598b77ffe47895db449c3 - 1.88% (11.6 MB)
[#026] sha256:b99b38859ce042e86770c002e15093ab7ae486e8118c23256b9c06945824e917 - 0.0% (8.33 KB)
[#027] sha256:946bee956b05a2fbf7331ffaaf5e17c212abde50982e95d0318bcd519bcbc8ee - 0.0% (1.85 KB)
[#028] sha256:52daa51c8e80441e797e7fa66e595669bc582a67c420630b09528dadfd079384 - 0.0% (1018 Bytes)
[#029] sha256:637ef991f9f898f9832ddc263ac4c096496d4c74fb704cc44371e5c0ec9b64e0 - 0.0% (279 Bytes)
[#030] sha256:2a8a8aa4df9f2922ac9e009368c3bbab7177900b30d0c0dd2d9f280ffa444c23 - 0.0% (1.33 KB)
[#031] sha256:46023f57fdaae102846018c8d90c1906847288ee9da29527396b0c19455c72cc - 0.0% (3.58 KB)
[#032] sha256:9a10759c069965341245b29b751d5ec3bbb332004944b1468a342106430b3222 - 0.0% (369 Bytes)
[#033] sha256:89d443c3e185a07d7dd38d863aa7a4db78ca244c0d9e182326abd7edf3f0aafb - 0.0% (336 Bytes)
[#034] sha256:7cef4f37d9aec356dedb5b06d7358f2e1251c4af6f66f545a264f90559ad1f8a - 0.0% (396 Bytes)
[#035] sha256:2a1198900ae715da2d920b6d4b8f9cc3a0f655276e081719ce3b8beb88b5d1a0 - 0.0% (399 Bytes)
[#036] sha256:039739afb4ea99b02f04eb066346f2b51f54e72ffd51de603ff257526d0e588f - 0.0% (637 Bytes)
[#037] sha256:a944cb2083ca60cadff7bf2dcd7e6660c94a473f3f6deb2d032d2623159ca675 - 0.0% (9.06 KB)
[#038] sha256:a4251c46941a03a7bf43d637f2fb2619e64bac904808a3696bbfca558b28662d - 0.0% (11.9 KB)
[#039] sha256:70ce3b5984c7b9bf452355c2deebbc0148f42cbaf3cfec4b4c7b18f062521fac - 0.0% (511 Bytes)
[#040] sha256:d452e768c742ddbb5a0c6552c4ad358b231ad04af236ace27ad130d7d284cb98 - 0.0% (273 Bytes)
[#041] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#042] sha256:1c7779916219778ba62e98cd93907677391b57e4a7f6e8f5c6de469b1ae2ea58 - 0.0% (4.82 KB)
[#043] sha256:6492cb218f0c5ce7f3000fe0e67cb1fd73266793244366b1c8fea09d93940d8e - 0.0% (127 Bytes)
[#044] sha256:2a322a750a9abb708f4904a53db91d6d1635e34fe2a0c1affd6d29544ffc41f7 - 1.16% (7.1 MB)
[#045] sha256:afce482617371879616cf653eafa117b48891214d0719284da2a2e4a970ed4a0 - 0.24% (1.5 MB)
History
/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-02-26 06:41:08 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-02-26 06:41:08 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-02-26 06:41:09 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c adduser --system --no-create-home --shell /bin/bash --group wal-g # buildkit
2025-02-26 06:41:14 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-02-27 21:57:44 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-02-27 21:57:44 UTC (buildkit.dockerfile.v0)COPY . /nixpg # buildkit
2025-02-27 21:57:44 UTC (buildkit.dockerfile.v0)WORKDIR /nixpg
2025-02-27 21:58:54 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c nix profile install .#psql_15/bin # buildkit
2025-02-27 21:58:54 UTC (buildkit.dockerfile.v0)WORKDIR /
2025-02-27 21:58:55 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-02-27 21:58:55 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-02-27 21:58:55 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ # buildkit
2025-02-27 21:58:55 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ # buildkit
2025-02-27 21:58:55 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/ # buildkit
2025-02-27 21:58:55 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/share/postgresql/ # buildkit
2025-02-27 21:58:56 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-02-27 21:58:56 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql # buildkit
2025-02-27 21:58:56 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets # buildkit
2025-02-27 21:59:01 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends tzdata # buildkit
2025-02-27 21:59:11 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -fs /usr/share/zoneinfo/Etc/UTC /etc/localtime && dpkg-reconfigure --frontend noninteractive tzdata # buildkit
2025-02-27 21:59: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-02-27 21:59:40 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2025-02-27 21:59:40 UTC (buildkit.dockerfile.v0)ARG TARGETARCH
2025-02-27 21:59:43 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-02-27 21:59:43 UTC (buildkit.dockerfile.v0)ARG GOSU_VERSION=1.16
2025-02-27 21:59:43 UTC (buildkit.dockerfile.v0)ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4
2025-02-27 21:59:43 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-arm64 /usr/local/bin/gosu # buildkit
2025-02-27 21:59:43 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-arm64.asc /usr/local/bin/gosu.asc # buildkit
2025-02-27 21:59:44 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-02-27 21:59:44 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c id postgres || (echo "postgres user does not exist" && exit 1) # buildkit
2025-02-27 21:59:44 UTC (buildkit.dockerfile.v0)COPY /tmp/wal-g /usr/local/bin/ # buildkit
2025-02-27 21:59:44 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit
2025-02-27 21:59:44 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit
2025-02-27 21:59:44 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit
2025-02-27 21:59:44 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit
2025-02-27 21:59:44 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/supautils.conf.j2 /etc/postgresql-custom/supautils.conf # buildkit
2025-02-27 21:59:44 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_extension_custom_scripts /etc/postgresql-custom/extension-custom-scripts # buildkit
2025-02-27 21:59:44 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_read_replica.conf.j2 /etc/postgresql-custom/read-replica.conf # buildkit
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_walg.conf.j2 /etc/postgresql-custom/wal-g.conf # buildkit
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.sh # buildkit
2025-02-27 21:59:45 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-02-27 21:59:45 UTC (buildkit.dockerfile.v0)COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/init-scripts/00-schema.sql # buildkit
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/migrations/00-extension.sql # buildkit
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)COPY /usr/local/bin/gosu /usr/local/bin/gosu # buildkit
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)ADD https://github.com/docker-library/postgres/raw/master/15/bullseye/docker-entrypoint.sh /usr/local/bin/ # buildkit
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /var/run/postgresql && chown postgres:postgres /var/run/postgresql # buildkit
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" "0s" '\n'}
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)ENV POSTGRES_HOST=/var/run/postgresql
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)ENV POSTGRES_USER=supabase_admin
2025-02-27 21:59:45 UTC (buildkit.dockerfile.v0)ENV POSTGRES_DB=postgres
2025-02-27 21:59:54 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-02-27 21:59:57 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-02-27 21:59:57 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.UTF-8
2025-02-27 21:59:57 UTC (buildkit.dockerfile.v0)ENV LANGUAGE=en_US:en
2025-02-27 21:59:57 UTC (buildkit.dockerfile.v0)ENV LC_ALL=en_US.UTF-8
2025-02-27 21:59:57 UTC (buildkit.dockerfile.v0)ENV LC_CTYPE=C.UTF-8
2025-02-27 21:59:57 UTC (buildkit.dockerfile.v0)ENV LC_COLLATE=C.UTF-8
2025-02-27 21:59:57 UTC (buildkit.dockerfile.v0)ENV LOCALE_ARCHIVE=/usr/lib/locale/locale-archive
2025-02-27 21:59:57 UTC (buildkit.dockerfile.v0)CMD ["postgres" "-D" "/etc/postgresql"]
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.