Namespace
supabase
Image / Tagpostgres:15.14.1.012
Content Digestsha256:7ef77ba8590556c816b51ddf8f309870b45e2d8f5d9ee8e791d50efe8181df44
Details
2025-10-02 20:53:51 UTC
768 MB
Labels
-
org.opencontainers.image.ref.nameubuntu
-
org.opencontainers.image.version24.04
Environment
LANGen_US.UTF-8
LANGUAGEen_US:en
LC_ALLen_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_DBpostgres
POSTGRES_HOST/var/run/postgresql
POSTGRES_USERsupabase_admin
Layers
[#000] sha256:a1a21c96bc16121569dd937bcd1c745a5081629b3b08a664446602ded91e10a4 - 3.69% (28.3 MB)
[#001] sha256:b3c03889666f94842a214d19a5aac1f4bee6341b07821b6ac876bfa722e1ad11 - 11.94% (91.7 MB)
[#002] sha256:bf702048e81caeb54fa3a658794799a675bb929b13ad712443f0515aae6c840a - 0.0% (1.36 KB)
[#003] sha256:718039a6a1a4b9737aade3cd4115fe043235e5f30ceaf1a550e57c76d37d9c24 - 0.0% (1.37 KB)
[#004] sha256:72a76cd67e89e4e2fae97a5fe9130f28a09c5644ca4090dbd4ac54b2c274f18a - 10.04% (77.1 MB)
[#005] sha256:f81763ba5a05376b8adbf1347f77a4cdf55443d8bb2a4d58ad806695fca944d9 - 0.08% (668 KB)
[#006] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#007] sha256:a3e25ec2ebe0b60a20336508327079e082afb1f50ad5ddd1a3866af8dafcf99d - 51.94% (399 MB)
[#008] sha256:e444b15891ab29185969f8392bbd8f181050ce3150ad9f7df22b86f25766baa3 - 0.27% (2.08 MB)
[#009] sha256:e5a1755d999db2fa04c4351a4e562fdc2f5f98d46c4e5f3f386fc6f3d5d7869f - 0.0% (252 Bytes)
[#010] sha256:af16e670e6998438402652ef3719be5d70664bf0eb6fa4ba3bd24787e2e17e63 - 2.04% (15.7 MB)
[#011] sha256:c9fe233cc6d2fc56b34452f5b0b72b92f0485d90af9daacf994887102536662a - 0.0% (616 Bytes)
[#012] sha256:df7b19f78faa078f7c6a22f8cdff5f7ec40bd90d87d9dc64b4f25b6333fe9e0d - 0.0% (596 Bytes)
[#013] sha256:81d8e35db0429ec5226878c58d34c1168e492b494506550968245a470d8ccef0 - 0.0% (613 Bytes)
[#014] sha256:e6cb54fd6d7d084f53b49e014388b91e3022a9a1aadd8b034619025b68738867 - 0.0% (595 Bytes)
[#015] sha256:8c40e81ac314c7eba855978539f65ae9279b5c776d7fb5f6016e2ff24ff9b242 - 0.1% (803 KB)
[#016] sha256:93932c3f05d1862de2fd7fc9fbbd93fa9209b7627c837fe28bac16204beaabc5 - 0.0% (1.28 KB)
[#017] sha256:819f845875121eaaef6e2baee1bf832c705b8b670e79e8136abe77d01f06bf6e - 0.0% (289 Bytes)
[#018] sha256:87082088e2340de54ae75d58d5e7bc0a28be8d0415f1fd4feea1b3186c11990f - 1.23% (9.41 MB)
[#019] sha256:689470335f4f4b66754d5dd83617dd04202a70847fbca56882bfeb2ed13812a3 - 0.05% (415 KB)
[#020] sha256:babf9fc9d8e103c8a6307a295d48a1af6772f22fc14d4440a7a36b5ffb1c9741 - 15.09% (116 MB)
[#021] sha256:f90de0b581e488319f75824159987dd3670c977e2803d506ecc761a4a9dad765 - 0.0% (2.11 KB)
[#022] sha256:2839d91caf58ca9d097704a2d126cf6aebe48a5f9de1789fd6fc9b2789b3f0ab - 0.12% (960 KB)
[#023] sha256:0fdd0817eb2e963d0e801b66a29a5a4a9cc191ddd054004ed3ec630218d9d4c4 - 0.0% (791 Bytes)
[#024] sha256:926ca294282e0a4a35bd2880dec4ee8472ffad9796b745b42c9bd99928b0adf1 - 0.12% (979 KB)
[#025] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#026] sha256:7e7affd170affd911b1f0ae24b089fe9b2e6410c2e8f20551abb619cde71864e - 2.02% (15.5 MB)
[#027] sha256:26f92bef07e1c13a7322cae7670bfedd45562ad0583da626e82d2e26d8750522 - 0.0% (8.33 KB)
[#028] sha256:823ad445d2628223d284f847a5c5faa59dbbd2af76d4b9e83d362349eddaf30e - 0.0% (1.85 KB)
[#029] sha256:6dc65977aed1b32f9bfe3c04ebd7d4622313ee723b7a6a68e6583dd2c907b160 - 0.0% (1015 Bytes)
[#030] sha256:962dcc317351e70a0a74065f530fbb795ec1b9edf12ae74dd0a2f6180e3c8858 - 0.0% (276 Bytes)
[#031] sha256:9a1bea9ea13df9d825ff85d2de3af55f9b542ea8c2c777799f9104642a626cf9 - 0.0% (1.36 KB)
[#032] sha256:9a93eba78ca39d79c99757f0f914db6721998e4233492a9db6d38ecce696a994 - 0.0% (3.76 KB)
[#033] sha256:5bb67982bf7bb887c48214624941fac8d0cd77aac376e632e4443b827c4f842a - 0.0% (363 Bytes)
[#034] sha256:8f42f385934cbcb02117e23a29b32b0875df1cbf0ff4d8c2257e7c7af43717be - 0.0% (335 Bytes)
[#035] sha256:f73d2b664b531ea7f2ecf09339023f713669d388ae40dd4ac1f06bf5e0cc48a6 - 0.0% (393 Bytes)
[#036] sha256:77713dcc96cec57ce09ec1a063dde440a4100ab3cc7b09b2de4cb0867310e81f - 0.0% (398 Bytes)
[#037] sha256:33d0cf94c95e48ec0043ea4e8f035f52eccefdcf70d2680e7e93263ef852bcf9 - 0.0% (639 Bytes)
[#038] sha256:425aeaa93291acff941a233c39f12d60f8e264ba043dcbe3a44737f98ff45218 - 0.0% (9.09 KB)
[#039] sha256:2f6d36bc48f20d9af58a3da83a38272178a4c1460af62d1703a2e14110744a89 - 0.0% (13 KB)
[#040] sha256:bb2ff1c56614b96b18c9abd28df49b1cfdf4bb667839fa05ec4cd0d06226686a - 0.0% (509 Bytes)
[#041] sha256:8e99193b8ab73b014dbfa34f4fcc5d97a1fe17da0919df78ffbe7e2eea3f7c0e - 0.0% (273 Bytes)
[#042] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#043] sha256:022487e33f6fcfbcee17bdf0b7f6372d9af42239c2efb3246b1424c50e3579ae - 0.0% (5.24 KB)
[#044] sha256:32a8bdbc88ab88f5e592fed7cffcc39fd4ccd60fcf681250d8efa95b9ea6ce12 - 0.0% (126 Bytes)
[#045] sha256:eb5f44595d36fa9cc4ac850f2e3e7c1dad10f88a6ed38252573d86e629abc614 - 1.13% (8.66 MB)
[#046] sha256:f48bc25793529e460738bc4b59add44b9c47bb8d33e89986de759e943be309ee - 0.11% (846 KB)
[#047] sha256:8fdc83f9f4caf77c3709fd1c4844e0b84fd3a0c1c4b6c1aa0a7040cad602236c - 0.0% (311 Bytes)
History
/bin/sh -c #(nop) ARG RELEASE
2025-09-30 14:32:28 UTC/bin/sh -c #(nop) ARG LAUNCHPAD_BUILD_ARCH
2025-09-30 14:32:28 UTC/bin/sh -c #(nop) LABEL org.opencontainers.image.ref.name=ubuntu
2025-09-30 14:32:28 UTC/bin/sh -c #(nop) LABEL org.opencontainers.image.version=24.04
2025-09-30 14:32:30 UTC/bin/sh -c #(nop) ADD file:d9cb8116905a82675c3c2cbb4782e50ef8cacfc16be3654bc070281a3c8ce646 in /
2025-09-30 14:32:31 UTC/bin/sh -c #(nop) CMD ["/bin/bash"]
2025-10-02 20:51: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-10-02 20:51: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-10-02 20:51:16 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c adduser --system --no-create-home --shell /bin/bash --group wal-g # buildkit
2025-10-02 20:51:22 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-10-02 20:51:22 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-10-02 20:51:22 UTC (buildkit.dockerfile.v0)COPY . /nixpg # buildkit
2025-10-02 20:51:22 UTC (buildkit.dockerfile.v0)WORKDIR /nixpg
2025-10-02 20:52:07 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c nix profile install .#psql_15/bin # buildkit
2025-10-02 20:52:24 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c nix store gc # buildkit
2025-10-02 20:52:24 UTC (buildkit.dockerfile.v0)WORKDIR /
2025-10-02 20:52:24 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-10-02 20:52:24 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-10-02 20:52:24 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ # buildkit
2025-10-02 20:52:24 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ # buildkit
2025-10-02 20:52:24 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/ # buildkit
2025-10-02 20:52:24 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/share/postgresql/ # buildkit
2025-10-02 20:52:24 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-10-02 20:52:24 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql # buildkit
2025-10-02 20:52:24 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets # buildkit
2025-10-02 20:52:30 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends tzdata # buildkit
2025-10-02 20:52:30 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -fs /usr/share/zoneinfo/Etc/UTC /etc/localtime && dpkg-reconfigure --frontend noninteractive tzdata # buildkit
2025-10-02 20:52:42 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends build-essential checkinstall cmake # buildkit
2025-10-02 20:52:42 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2025-10-02 20:52:42 UTC (buildkit.dockerfile.v0)ARG TARGETARCH
2025-10-02 20:52:44 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-10-02 20:52:44 UTC (buildkit.dockerfile.v0)ARG GOSU_VERSION=1.16
2025-10-02 20:52:44 UTC (buildkit.dockerfile.v0)ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4
2025-10-02 20:52:44 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64 /usr/local/bin/gosu # buildkit
2025-10-02 20:52:44 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64.asc /usr/local/bin/gosu.asc # buildkit
2025-10-02 20:52:47 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-10-02 20:52:47 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c id postgres || (echo "postgres user does not exist" && exit 1) # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY /tmp/wal-g /usr/local/bin/ # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/supautils.conf.j2 /etc/postgresql-custom/supautils.conf # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_extension_custom_scripts /etc/postgresql-custom/extension-custom-scripts # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_read_replica.conf.j2 /etc/postgresql-custom/read-replica.conf # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_walg.conf.j2 /etc/postgresql-custom/wal-g.conf # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.sh # buildkit
2025-10-02 20:53: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-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/init-scripts/00-schema.sql # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/migrations/00-extension.sql # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)COPY /usr/local/bin/gosu /usr/local/bin/gosu # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)ADD https://github.com/docker-library/postgres/raw/889f9447cd2dfe21cccfbe9bb7945e3b037e02d8/15/bullseye/docker-entrypoint.sh /usr/local/bin/docker-entrypoint.sh # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /var/run/postgresql && chown postgres:postgres /var/run/postgresql # buildkit
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" "0s" '\n'}
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)ENV POSTGRES_HOST=/var/run/postgresql
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)ENV POSTGRES_USER=supabase_admin
2025-10-02 20:53:39 UTC (buildkit.dockerfile.v0)ENV POSTGRES_DB=postgres
2025-10-02 20:53:49 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-10-02 20:53:51 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-10-02 20:53:51 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.UTF-8
2025-10-02 20:53:51 UTC (buildkit.dockerfile.v0)ENV LANGUAGE=en_US:en
2025-10-02 20:53:51 UTC (buildkit.dockerfile.v0)ENV LC_ALL=en_US.UTF-8
2025-10-02 20:53:51 UTC (buildkit.dockerfile.v0)ENV LOCALE_ARCHIVE=/usr/lib/locale/locale-archive
2025-10-02 20:53:51 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-10-02 20:53:51 UTC (buildkit.dockerfile.v0)CMD ["postgres" "-D" "/etc/postgresql"]
Details
2025-10-02 20:52:47 UTC
752 MB
Labels
-
org.opencontainers.image.ref.nameubuntu
-
org.opencontainers.image.version24.04
Environment
LANGen_US.UTF-8
LANGUAGEen_US:en
LC_ALLen_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_DBpostgres
POSTGRES_HOST/var/run/postgresql
POSTGRES_USERsupabase_admin
Layers
[#000] sha256:7bdf644cff2e9be580c17c3db8d5fc564ad093513bf0fbebebc392c17fa925e5 - 3.66% (27.5 MB)
[#001] sha256:fe1b726184d3d0e37e7cafac4731f59da492bbfb99fa03f175dc564f2c2ad2ba - 12.36% (92.9 MB)
[#002] sha256:10a19f34c8726136b71aa4f83d36ea40d9cca45a437633f7a96f63ced5ec8611 - 0.0% (1.36 KB)
[#003] sha256:37d533e48ab00e0994c708fb9c2111aaced31bfc81e56f3b6ac18cd7d866e132 - 0.0% (1.38 KB)
[#004] sha256:a91bf01ae03097a03e65474499b52e3e13d48f83f96856c937d6ec1e697840f8 - 9.91% (74.5 MB)
[#005] sha256:593419f1c370fd2ac60eafc7b091f9849e63e730975f462247da27df65523255 - 0.09% (668 KB)
[#006] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#007] sha256:c4ff121e18ae90995bd831e46fe1812907fd0f13aa2a91bc7c9c4c7cbe2a2745 - 52.38% (394 MB)
[#008] sha256:39bf7964f59903c8e1bdb6674119e12d2f4ce3aca59d3f25ede9c01ae1f32d58 - 0.28% (2.08 MB)
[#009] sha256:f25ff2b23c42f985b48eacc664fea02482712da3d89f97e165bca63abc27c9b6 - 0.0% (252 Bytes)
[#010] sha256:0c8557572b0755d15db39bc7865dd3ca34036ebd44cc7743927a25ef64ef9c5d - 2.06% (15.5 MB)
[#011] sha256:4fca5bf763bd74c8b3f61f82f69d96736e39edd2aab7cd5673c12b7c1227cb74 - 0.0% (617 Bytes)
[#012] sha256:4a7437cf649bc9d8801a22cec89901b86b8c44ad65464111962279a83d2953e5 - 0.0% (602 Bytes)
[#013] sha256:bf4957af64ea27d713c1e95c874d09baa54ef8586a0db1ec834bb825b4bfb7a6 - 0.0% (612 Bytes)
[#014] sha256:9e2c3a797e3e383fbfc63ef1b5c1249eab280aec483d37085b7fa59886a4cb09 - 0.0% (600 Bytes)
[#015] sha256:94b3c5136e964585043ec903cd96defc5e665acc43d50884689deed6cf0a660c - 0.1% (803 KB)
[#016] sha256:96650bbc6dda5285b813cd6e8cf72f67ddf62a0be822bb20c590f6bc258ce726 - 0.0% (1.28 KB)
[#017] sha256:3d8bf4c14e470ab394ea4d0095aacc9a082290f18e889121da0efc12c7315bf1 - 0.0% (289 Bytes)
[#018] sha256:165ff4b5f155b38d778ed1e049c0d1fee8924100a74b1006a7c4de4d18a79ed1 - 1.18% (8.85 MB)
[#019] sha256:79f7bdf037666f7ff0583b0d2363847daa034444c73a8c1ab0a5f0a17a3a5661 - 0.05% (415 KB)
[#020] sha256:fc584f2d59b65f479f1f2cf98e3f92806e092a9480d326d2078c31c902f66a6e - 14.52% (109 MB)
[#021] sha256:c1e6ac911eef57bd85c4cfc49a384eaae928b7c4b75cf29d0a9bf7865c30391a - 0.0% (2.11 KB)
[#022] sha256:d6021ef6d7e0e69413003e7b0e26e77de72a9ba7ee55ce6b15cdd072f5f5289f - 0.12% (892 KB)
[#023] sha256:3f15aad448aeba105b0a0e28f87d685b0f3f2d9a393ec004d98068981f086b7c - 0.0% (791 Bytes)
[#024] sha256:3e35564e21a6e9a1008b67f7fb4e0e042a8c30c33e5b878ef1122b9453f8124b - 0.12% (913 KB)
[#025] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#026] sha256:826b252fcbe6bf645a14fe918af69467d5a3cd0bf17fa16cf9e54c0f89765b57 - 1.92% (14.5 MB)
[#027] sha256:bdc5bbbbd643e309a0de6ae23af086b7c41577194ec8321e933954c3e0c7d994 - 0.0% (8.33 KB)
[#028] sha256:f573d329d2fc6ad6969c7b8dbd94bd0e6050594c5fba21b9bc62a6e71e6e3a4d - 0.0% (1.85 KB)
[#029] sha256:8e8b1041461be6e752ac02825e29bc1bbde9ecf6319cd3d115790fe5847daaf2 - 0.0% (1015 Bytes)
[#030] sha256:9bd52a254476d260d46191dfaa0aff9e9036fea035f038fe5587238fe2782b03 - 0.0% (275 Bytes)
[#031] sha256:39d2ffa37fd4aca1c09c934db17ef638d6e3c61e498ecf211b5b87dcc918d7dc - 0.0% (1.36 KB)
[#032] sha256:51824382339bcdde80b212001d23d6c6aae2b5bd64bccae5958251f1fd44d1d6 - 0.0% (3.76 KB)
[#033] sha256:840063301139fe2da80df6a4b2d7105daf8c3af7840f5a280bf54ebc98a78de4 - 0.0% (366 Bytes)
[#034] sha256:78725a2990f52bcf0b479bb67cdc15a26c70f14d2194518b95bece59db056710 - 0.0% (335 Bytes)
[#035] sha256:cbb68bd9f25b7075e0bf74a7f653ce40852e8db646a688f6ef55fef7f78e219b - 0.0% (393 Bytes)
[#036] sha256:6d2803589423ebabe3371188a44036f3ff7cc454d72999d52cbb5a41aa1663c6 - 0.0% (397 Bytes)
[#037] sha256:e94769e3d106ad00c4d7b8c2606578d784a1b99c7d4ae17dc83918b624dc0eed - 0.0% (636 Bytes)
[#038] sha256:fa74c45728527c8fdd142683d3f9563c8dc85555c035d09e5511914d732a8b8b - 0.0% (9.09 KB)
[#039] sha256:01b59c230586049084995c46c1ab6067aba337fe0da0d432226d6708b301733c - 0.0% (13 KB)
[#040] sha256:bd07d5605efb27fedb2a95cbe0bcf61467f4f66424c9a8d7c88ddb111263fa28 - 0.0% (509 Bytes)
[#041] sha256:0bc5f9b4e292c3efe00fcd7c63d8527f38d9a47a94927b0ab744abe7ba40e007 - 0.0% (272 Bytes)
[#042] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#043] sha256:94f522843281cd15dae6216c63fea82d9a4ce5102af588fcdda287ee259f2e12 - 0.0% (5.24 KB)
[#044] sha256:caa4c75e929f58d31feca5836aeef625b9245c892f9f831c352b59850674783b - 0.0% (126 Bytes)
[#045] sha256:56d46187a62fa0f557e1f817fd7c4684d6cc6757369129ecc715a131c0c3d0bc - 1.14% (8.58 MB)
[#046] sha256:d36028e29b5e5dcf162b7e8d26c5cfa2b6e4381c9b32811322ab9cdeb1f375f3 - 0.11% (846 KB)
[#047] sha256:d8466dcd6d631edc629aef52fcc5af1f3660b67e10d18872d373b3e45d10aba6 - 0.0% (313 Bytes)
History
/bin/sh -c #(nop) ARG RELEASE
2025-09-30 14:36:10 UTC/bin/sh -c #(nop) ARG LAUNCHPAD_BUILD_ARCH
2025-09-30 14:36:11 UTC/bin/sh -c #(nop) LABEL org.opencontainers.image.ref.name=ubuntu
2025-09-30 14:36:11 UTC/bin/sh -c #(nop) LABEL org.opencontainers.image.version=24.04
2025-09-30 14:36:15 UTC/bin/sh -c #(nop) ADD file:2b1a3adb91c564e3fe655be94477504bbc81d767317b3181efd5cd6ae287b26f in /
2025-09-30 14:36:15 UTC/bin/sh -c #(nop) CMD ["/bin/bash"]
2025-10-02 20:50:55 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-10-02 20:50:55 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-10-02 20:50:56 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c adduser --system --no-create-home --shell /bin/bash --group wal-g # buildkit
2025-10-02 20:51:00 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-10-02 20:51:00 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-10-02 20:51:00 UTC (buildkit.dockerfile.v0)COPY . /nixpg # buildkit
2025-10-02 20:51:00 UTC (buildkit.dockerfile.v0)WORKDIR /nixpg
2025-10-02 20:51:29 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c nix profile install .#psql_15/bin # buildkit
2025-10-02 20:51:38 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c nix store gc # buildkit
2025-10-02 20:51:38 UTC (buildkit.dockerfile.v0)WORKDIR /
2025-10-02 20:51:38 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-10-02 20:51:38 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-10-02 20:51:38 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ # buildkit
2025-10-02 20:51:39 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ # buildkit
2025-10-02 20:51:39 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/ # buildkit
2025-10-02 20:51:39 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/share/postgresql/ # buildkit
2025-10-02 20:51:39 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-10-02 20:51:39 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql # buildkit
2025-10-02 20:51:39 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets # buildkit
2025-10-02 20:51:44 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends tzdata # buildkit
2025-10-02 20:51:44 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -fs /usr/share/zoneinfo/Etc/UTC /etc/localtime && dpkg-reconfigure --frontend noninteractive tzdata # buildkit
2025-10-02 20:51:58 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends build-essential checkinstall cmake # buildkit
2025-10-02 20:51:58 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2025-10-02 20:51:58 UTC (buildkit.dockerfile.v0)ARG TARGETARCH
2025-10-02 20:52:01 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-10-02 20:52:01 UTC (buildkit.dockerfile.v0)ARG GOSU_VERSION=1.16
2025-10-02 20:52:01 UTC (buildkit.dockerfile.v0)ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4
2025-10-02 20:52:02 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-arm64 /usr/local/bin/gosu # buildkit
2025-10-02 20:52:02 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-arm64.asc /usr/local/bin/gosu.asc # buildkit
2025-10-02 20:52:03 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-10-02 20:52:03 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c id postgres || (echo "postgres user does not exist" && exit 1) # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY /tmp/wal-g /usr/local/bin/ # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/supautils.conf.j2 /etc/postgresql-custom/supautils.conf # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_extension_custom_scripts /etc/postgresql-custom/extension-custom-scripts # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_read_replica.conf.j2 /etc/postgresql-custom/read-replica.conf # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_walg.conf.j2 /etc/postgresql-custom/wal-g.conf # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.sh # buildkit
2025-10-02 20:52:37 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-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/init-scripts/00-schema.sql # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/migrations/00-extension.sql # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)COPY /usr/local/bin/gosu /usr/local/bin/gosu # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)ADD https://github.com/docker-library/postgres/raw/889f9447cd2dfe21cccfbe9bb7945e3b037e02d8/15/bullseye/docker-entrypoint.sh /usr/local/bin/docker-entrypoint.sh # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /var/run/postgresql && chown postgres:postgres /var/run/postgresql # buildkit
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" "0s" '\n'}
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)ENV POSTGRES_HOST=/var/run/postgresql
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)ENV POSTGRES_USER=supabase_admin
2025-10-02 20:52:37 UTC (buildkit.dockerfile.v0)ENV POSTGRES_DB=postgres
2025-10-02 20:52:46 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-10-02 20:52:47 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-10-02 20:52:47 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.UTF-8
2025-10-02 20:52:47 UTC (buildkit.dockerfile.v0)ENV LANGUAGE=en_US:en
2025-10-02 20:52:47 UTC (buildkit.dockerfile.v0)ENV LC_ALL=en_US.UTF-8
2025-10-02 20:52:47 UTC (buildkit.dockerfile.v0)ENV LOCALE_ARCHIVE=/usr/lib/locale/locale-archive
2025-10-02 20:52:47 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-10-02 20:52:47 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.