Namespace
supabase
Image / Tagpostgres:15.6.1.130_amd64
Content Digestsha256:1108eac96671825e0adf2fa867f33b353069bd1ebaaea1092b47fb607fa2fa26
Details
2024-10-07 07:08:53 UTC
718 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:3823320faa42774534fd7eee0bd245af8cec6a720ad722144d40efa229291d8f - 3.66% (26.2 MB)
[#001] sha256:bbd6ad7479c389450e6cd8eac8db7baae01e74e6ccaa44744a849f8e794aa7bc - 11.59% (83.2 MB)
[#002] sha256:2a7ec49f81bee9fc0791c0260d8837a84480fe30b0ce11396ac70e366f865a60 - 0.0% (1.53 KB)
[#003] sha256:ecc0e0382b8462feac1a3df082266e9631b563b17008375d51be713a16b7b386 - 0.0% (1.55 KB)
[#004] sha256:efd18db05731c923901d6d9b770383dff90e74d3fde7de893a97120ed2d401d9 - 9.61% (69 MB)
[#005] sha256:10307b45fd3dfe5cf687e52c966b0cab36c23631e9f9be4251ebfd37cb548ed7 - 0.05% (388 KB)
[#006] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#007] sha256:6d387b39383fe5c484b13ec4a62287486af8ff14bea2f0112572a127d9918376 - 56.91% (408 MB)
[#008] sha256:97479f6778d7a3fe77935ebd284b409b1a86f498619ef33654f46da3b1a8cb6d - 0.0% (225 Bytes)
[#009] sha256:a9756bd1c4b2e68a09a2eda0f236d83f20b6c7033ead5ba1742c8f623c210ceb - 2.23% (16 MB)
[#010] sha256:54bbed44d03a885741312a5ebf312b212be0b86735c5db1ec4c8b040143f0642 - 0.0% (590 Bytes)
[#011] sha256:6dc46db6289af6818252081d4cde97316ca199defd610fcc832c16e362b035d4 - 0.0% (570 Bytes)
[#012] sha256:aa3ac89738568f405aeae510030644de19850f09e69a133e0a81191f1c0bd743 - 0.0% (585 Bytes)
[#013] sha256:cfb7d615a1e737d06db6c42832558eb70d2a66815d4af3a8cce28ec3dec21c3f - 0.0% (567 Bytes)
[#014] sha256:51566624287fdf6d2db9fbd1e4105398fd8d2d53d4bc6bf1be2335b5d55b879c - 0.11% (803 KB)
[#015] sha256:6200acd6ddf9a1bd78ed4959b8ca9de495f3c430064bac5e827d2ef968d0b240 - 0.0% (1.22 KB)
[#016] sha256:8a2147cfa645e16df55cb23cd287dde6c7f5e2a4099432686f268014c876f762 - 0.0% (291 Bytes)
[#017] sha256:f97c6568d8533e23bae8117eab5a452ece9c9955c62a481f1e6c4ff8663f6bb1 - 1.65% (11.9 MB)
[#018] sha256:2f077d45ee5f60660f711ce6468335d489a4190117959d7e75d4d3beb8325aaf - 0.06% (432 KB)
[#019] sha256:22cfd06de044b9f586c9d357b85cb4ba8090757b4565284f7ed2670924470726 - 11.05% (79.3 MB)
[#020] sha256:6c268f3b1a36a49fa6eb06e3bfbb8cbb9b4960706549357c4e210641c132e96f - 0.0% (1.82 KB)
[#021] sha256:e44c427cd287cb8c07b28e1411edd789397ce7665081780ac7df129bc607abe9 - 0.13% (960 KB)
[#022] sha256:51ad0a8c3c60fb3ecba78e487a6f191dc7c476abb392b1df967ce0c44c379b44 - 0.0% (803 Bytes)
[#023] sha256:a755a619b12376c583dbeeb7c65c9604a95e7aba12a125a37ee2b909f64bfa54 - 0.13% (977 KB)
[#024] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#025] sha256:a5da13dae6ebf8a9f357931c36da4ee73f832e31bf8488f0bcdb3014f2aeddf1 - 1.61% (11.6 MB)
[#026] sha256:a3f5a4397b6ac26c33548eb439262321f94536f84550695b9fd234669e32809c - 0.0% (8.33 KB)
[#027] sha256:70297b7e60f1f29203abdc60be43c480e319476d7ce8394c63747c67908aa224 - 0.0% (1.84 KB)
[#028] sha256:7f48ffbf7f6621863e92c7866692e6a4f6eb7df12ef8c11e8f8ecbf8a89def9c - 0.0% (1017 Bytes)
[#029] sha256:04ebdb6a0b2f4f925349a988aee9050a8d6cdb3a0607064df4a2740da7c34ca1 - 0.0% (277 Bytes)
[#030] sha256:812af8eff1f9658bb3aff0ff954f96a9d32c1818496470a69bd54a41969dfae1 - 0.0% (1.28 KB)
[#031] sha256:783e625f8b3925a604c2fdafa8440aaf4bffa4c64db52457eafbefeadb3d9429 - 0.0% (1.9 KB)
[#032] sha256:2b0f3dec7d68c2f172ed11edbb6fc5ede2b581cfd29eff93d0f07fd28f781ce8 - 0.0% (366 Bytes)
[#033] sha256:1bcf77e9e4728c0ca520ffd9b2f4adb72dcbf729a0d68738efd0edd86617459b - 0.0% (334 Bytes)
[#034] sha256:d56c78ca5d8aa08e1dd754f3a6174d0dbaeb5aebf288d35a765fc7fb19fe7d48 - 0.0% (393 Bytes)
[#035] sha256:0142cc446f42c8523a0de322be78d067aa059d67fbf6d8e95129c68f9e02278a - 0.0% (397 Bytes)
[#036] sha256:e30218265e7b905f87c68e52ffacbbec7cc2929fe2bb069a676760529c2fa0bc - 0.0% (637 Bytes)
[#037] sha256:7764628618a28d12d1dd02a049345db8251fe76566aef1ee9abd50b4fc4538e1 - 0.0% (9.06 KB)
[#038] sha256:062abf4af06ee936801ad3c268aac8bb5cca1cf2f7911ec7eb91bc6c04d401b8 - 0.0% (9.95 KB)
[#039] sha256:3db8ac7698c948c4723e3b0dfdd4f4b393849468820690af5d0e07e39e13c6a2 - 0.0% (508 Bytes)
[#040] sha256:a348d5b128ba22976fc87c1f4cc739db0e0e38ddfbd956d46b3713d6a7763e16 - 0.0% (271 Bytes)
[#041] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#042] sha256:d9c812c2865c91d5d375019f57e66072d4d120ef04c11dd01571d573a7ea0846 - 0.0% (4.76 KB)
[#043] sha256:e6928a5d1ef47986cf51741b9a3bd68c3bbb8b0db48fb1635b3463e20e0780ba - 0.0% (128 Bytes)
[#044] sha256:1f707cfa873228416913225512bc105b842949374c046bbb32d473c4796dcb2d - 0.99% (7.1 MB)
[#045] sha256:956077788c34e7f6e311223d26d4204e855641673e8ca0f64411969a1f67b4dd - 0.21% (1.5 MB)
History
/bin/sh -c #(nop) ARG RELEASE
2024-09-18 04:18:32 UTC/bin/sh -c #(nop) ARG LAUNCHPAD_BUILD_ARCH
2024-09-18 04:18:32 UTC/bin/sh -c #(nop) LABEL org.opencontainers.image.ref.name=ubuntu
2024-09-18 04:18:32 UTC/bin/sh -c #(nop) LABEL org.opencontainers.image.version=20.04
2024-09-18 04:18:34 UTC/bin/sh -c #(nop) ADD file:6a209aa51ba684c0a39769619c42058ca99311b87563c7b079319a8bb91bec1f in /
2024-09-18 04:18:34 UTC/bin/sh -c #(nop) CMD ["/bin/bash"]
2024-10-02 10:38:19 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
2024-10-02 10:38:19 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
2024-10-02 10:38:20 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c adduser --system --no-create-home --shell /bin/bash --group wal-g # buildkit
2024-10-02 10:38:25 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
2024-10-07 07:07:47 UTC (buildkit.dockerfile.v0)ENV PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/nix/var/nix/profiles/default/bin
2024-10-07 07:07:47 UTC (buildkit.dockerfile.v0)COPY . /nixpg # buildkit
2024-10-07 07:07:47 UTC (buildkit.dockerfile.v0)WORKDIR /nixpg
2024-10-07 07:08:25 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c nix profile install .#psql_15/bin # buildkit
2024-10-07 07:08:25 UTC (buildkit.dockerfile.v0)WORKDIR /
2024-10-07 07:08:26 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /usr/lib/postgresql/bin /usr/lib/postgresql/share/postgresql /usr/share/postgresql && chown -R postgres:postgres /usr/lib/postgresql && chown -R postgres:postgres /usr/share/postgresql # buildkit
2024-10-07 07:08:27 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
2024-10-07 07:08:27 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ # buildkit
2024-10-07 07:08:27 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ # buildkit
2024-10-07 07:08:27 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/ # buildkit
2024-10-07 07:08:27 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/share/postgresql/ # buildkit
2024-10-07 07:08:27 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
2024-10-07 07:08:27 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql # buildkit
2024-10-07 07:08:27 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets # buildkit
2024-10-07 07:08:30 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends tzdata # buildkit
2024-10-07 07:08:30 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -fs /usr/share/zoneinfo/Etc/UTC /etc/localtime && dpkg-reconfigure --frontend noninteractive tzdata # buildkit
2024-10-07 07:08:42 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends build-essential checkinstall cmake # buildkit
2024-10-07 07:08:42 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2024-10-07 07:08:42 UTC (buildkit.dockerfile.v0)ARG TARGETARCH
2024-10-07 07:08: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
2024-10-07 07:08:44 UTC (buildkit.dockerfile.v0)ARG GOSU_VERSION=1.16
2024-10-07 07:08:44 UTC (buildkit.dockerfile.v0)ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4
2024-10-07 07:08:44 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64 /usr/local/bin/gosu # buildkit
2024-10-07 07:08:44 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64.asc /usr/local/bin/gosu.asc # buildkit
2024-10-07 07:08:45 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
2024-10-07 07:08:45 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c id postgres || (echo "postgres user does not exist" && exit 1) # buildkit
2024-10-07 07:08:45 UTC (buildkit.dockerfile.v0)COPY /tmp/wal-g /usr/local/bin/ # buildkit
2024-10-07 07:08:45 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit
2024-10-07 07:08:45 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit
2024-10-07 07:08:45 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit
2024-10-07 07:08:45 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/supautils.conf.j2 /etc/postgresql-custom/supautils.conf # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_extension_custom_scripts /etc/postgresql-custom/extension-custom-scripts # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_read_replica.conf.j2 /etc/postgresql-custom/read-replica.conf # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_walg.conf.j2 /etc/postgresql-custom/wal-g.conf # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.sh # buildkit
2024-10-07 07:08: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
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/init-scripts/00-schema.sql # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/migrations/00-extension.sql # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)COPY /usr/local/bin/gosu /usr/local/bin/gosu # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)ADD https://github.com/docker-library/postgres/raw/master/15/bullseye/docker-entrypoint.sh /usr/local/bin/ # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /var/run/postgresql && chown postgres:postgres /var/run/postgresql # buildkit
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" "0s" '\n'}
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)ENV POSTGRES_HOST=/var/run/postgresql
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)ENV POSTGRES_USER=supabase_admin
2024-10-07 07:08:46 UTC (buildkit.dockerfile.v0)ENV POSTGRES_DB=postgres
2024-10-07 07:08:52 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
2024-10-07 07:08:53 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c echo "C.UTF-8 UTF-8" > /etc/locale.gen && echo "en_US.UTF-8 UTF-8" >> /etc/locale.gen && locale-gen # buildkit
2024-10-07 07:08:53 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.UTF-8
2024-10-07 07:08:53 UTC (buildkit.dockerfile.v0)ENV LANGUAGE=en_US:en
2024-10-07 07:08:53 UTC (buildkit.dockerfile.v0)ENV LC_ALL=en_US.UTF-8
2024-10-07 07:08:53 UTC (buildkit.dockerfile.v0)ENV LC_CTYPE=C.UTF-8
2024-10-07 07:08:53 UTC (buildkit.dockerfile.v0)ENV LC_COLLATE=C.UTF-8
2024-10-07 07:08:53 UTC (buildkit.dockerfile.v0)ENV LOCALE_ARCHIVE=/usr/lib/locale/locale-archive
2024-10-07 07:08:53 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.