Namespace
supabase
Image / Tagpostgres:15.6.1.146_amd64
Content Digestsha256:b6284e7f2fbe81bd9a053024c1ad7fa63fa38e3d3ea030eb28a65ddfa30e69ee
Details
2024-12-09 21:57:59 UTC
728 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 - 3.6% (26.2 MB)
[#001] sha256:062aefc6e27342552e209e6dfaddd89c835daefe4543bd9be1bce450ac49fa5e - 11.48% (83.6 MB)
[#002] sha256:627236c3f3c5849d994a4a176b5516ddd9a6e8c5488b8446bc8fdf1cc163b0fd - 0.0% (1.53 KB)
[#003] sha256:25174304ddacfae916b87992b24860e98e93e6cdf5e7b25294205b6daa331303 - 0.0% (1.55 KB)
[#004] sha256:4ae2767200a1238e88ec5dca27dde7c6c4b31f21849a594efb6b6e39242997bc - 9.49% (69.1 MB)
[#005] sha256:4c358f589fc4a7d510d0bf29b27d39c213318cb8a2ed818d3679eed98ef4d6ae - 0.05% (391 KB)
[#006] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#007] sha256:7ba3fe8102cd763157cea51dc804681c207e446f3cb85a7b793f8e42a90dfa52 - 56.24% (410 MB)
[#008] sha256:68686428d5f882e95812ef4515a741a0547a645ba252821f15f7470bd59ef5e0 - 0.0% (222 Bytes)
[#009] sha256:21e4097231655e9d4b709989c41a08456c6a380dba79a1ff893613cfdbcb707f - 2.2% (16 MB)
[#010] sha256:9355e0faef68c542528a1336df272787b812e821dfb4afca5fa25bcb8e11feb3 - 0.0% (587 Bytes)
[#011] sha256:75b86d5ed18e79dfa68a0b6a5c08227302319108d54a9818350a8c4c96e8df10 - 0.0% (569 Bytes)
[#012] sha256:fac67699552494caa4a1168164ae40180f94c8446dbc9b17350e21dd49f47c96 - 0.0% (583 Bytes)
[#013] sha256:cf4e475d4257c0510d5b2924ca04ea47afcfd2a5476259dcecdee60e665f5450 - 0.0% (566 Bytes)
[#014] sha256:0f90d0839bcc289fdee6e529aacba190c5c44a671c849e5afe76d80b13e426ce - 0.11% (803 KB)
[#015] sha256:89e7840bc51e408e3ce2cd98ac54b9b1e0724ae9253e8cbf02b5b7c6e8e6c42f - 0.0% (1.21 KB)
[#016] sha256:7b83a9ebcdd67244100b86fa5dccd30858bc197105033b1264b2fc3e3b771c8e - 0.0% (294 Bytes)
[#017] sha256:625edf85724c84beb3bd142d1e87b109e06eead8de1f88610355d2b889cbcd3d - 2.85% (20.8 MB)
[#018] sha256:4d7ab0bd149769ba352df0a584fdc51cb3611e5e7240f8d4dcb24c84c77b6736 - 0.06% (432 KB)
[#019] sha256:ceb224e69ec7b5f0e1869032e6bde6bfc9ec8102ef6225b4673e65e0f7b6b5fc - 10.89% (79.3 MB)
[#020] sha256:6fef75739afb81eaf78dfe8d49807c7b80c9d83697d8b9d7e568b5be0452df4a - 0.0% (1.82 KB)
[#021] sha256:d2977e72920cf13d4753bef1200a1baadae8516bb04d0f5b5b4a290ab433649e - 0.13% (960 KB)
[#022] sha256:8b95d407df95a39b7a1234c4d115a9487ab9685d37e1382b7c68aa07987df0e3 - 0.0% (802 Bytes)
[#023] sha256:40dd23c8e96c2fb839a0644e837ed38ab98400cc4a039ff6f6a0c80e553489e7 - 0.13% (977 KB)
[#024] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#025] sha256:10dd9b5d641d3b1c2873d1f38f47f8f9106b4ee372a090497807d84a6a5752b8 - 1.59% (11.6 MB)
[#026] sha256:1bf4194712506a838f30533dd04c59355a1a4cc48f0ec57ecd4d3186944453f8 - 0.0% (8.33 KB)
[#027] sha256:d17697f0891e8e14c98b1b66797537cf3f891322e8913b3268e5c779e0fd5b49 - 0.0% (1.85 KB)
[#028] sha256:f923878bb2972ebc3c134eca94c2cb2cd7ea95f2a1f14753524665a47cc9c04e - 0.0% (1017 Bytes)
[#029] sha256:719f7cc11f68b4531acf827cc477e3190cf7af1408e3863c964f0d824275b66a - 0.0% (277 Bytes)
[#030] sha256:b1560752dd24fef112350370a07bc64b6f1c07b449e6857e4201e96953fef47f - 0.0% (1.33 KB)
[#031] sha256:a5eb5ef4ae8330d829e5c761a5e3700fc3080e25e74800a3b163ae3743fd400c - 0.0% (2.14 KB)
[#032] sha256:4f4812f7a4cee15dacd6de32f9551cf333bdbf5cbb8a80c69de3591e9d27715e - 0.0% (365 Bytes)
[#033] sha256:d0708bae43eb0533008f74f126f1a937a60fadc716ca54a7247c596aafb66680 - 0.0% (336 Bytes)
[#034] sha256:89208a97632f0a48d534975aace58a6d39fb42eb616da79585e519ba3d64ee34 - 0.0% (394 Bytes)
[#035] sha256:366b6e033e2844bcc10644430fa99d96f71a3e50a7193e2deac807b0d7eae88f - 0.0% (398 Bytes)
[#036] sha256:3697f3cb1fe3b143405ed023738e2db99036c285d11236b35869fdb5b5c241c1 - 0.0% (639 Bytes)
[#037] sha256:11c4f36841321a6b60e3f7b2da6af2586e9c17e8fa138c0068ebfd783c94bdc8 - 0.0% (9.06 KB)
[#038] sha256:7b7d171c58befa266ec407fb6b4eb80c8f6cf23fe41fee038cc82543d2c7c52c - 0.0% (9.96 KB)
[#039] sha256:2d8c9e11971d9612026f79f791c6f64c5047b3f9c45ca9779e3846b01bf620c6 - 0.0% (509 Bytes)
[#040] sha256:8bbcbcffc0e3911ee3173d2f80c90cda8ba70fc289dee0ba43ad75b0db02d5dc - 0.0% (273 Bytes)
[#041] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#042] sha256:a455721000f6d5e68785418c1b46f1b573c2e48c57a3cc1b3613e8f78960bafa - 0.0% (4.76 KB)
[#043] sha256:229f70004e7cd174592be9fe31fe4da512c7c311587c1f8bc2ff73ca83da5d6a - 0.0% (128 Bytes)
[#044] sha256:0cb9a201b2d3f34652dee576f8bbbe7a54554638d22423696415c2f19e0d49c5 - 0.97% (7.1 MB)
[#045] sha256:dbedc08a00c89e2f883975fc2a765212f17a3bfbb1e4f7e2ada4128d5ad770c0 - 0.21% (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"]
2024-12-06 03:50:37 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-12-06 03:50:38 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-12-06 03:50:38 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c adduser --system --no-create-home --shell /bin/bash --group wal-g # buildkit
2024-12-06 03:50:52 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-12-09 21:57: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
2024-12-09 21:57:00 UTC (buildkit.dockerfile.v0)COPY . /nixpg # buildkit
2024-12-09 21:57:00 UTC (buildkit.dockerfile.v0)WORKDIR /nixpg
2024-12-09 21:57:32 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c nix profile install .#psql_15/bin # buildkit
2024-12-09 21:57:32 UTC (buildkit.dockerfile.v0)WORKDIR /
2024-12-09 21:57:32 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-12-09 21:57:33 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-12-09 21:57:33 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ # buildkit
2024-12-09 21:57:33 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ # buildkit
2024-12-09 21:57:33 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/ # buildkit
2024-12-09 21:57:33 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/share/postgresql/ # buildkit
2024-12-09 21:57:33 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-12-09 21:57:33 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql # buildkit
2024-12-09 21:57:33 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets # buildkit
2024-12-09 21:57:36 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends tzdata # buildkit
2024-12-09 21:57:36 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -fs /usr/share/zoneinfo/Etc/UTC /etc/localtime && dpkg-reconfigure --frontend noninteractive tzdata # buildkit
2024-12-09 21:57:47 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends build-essential checkinstall cmake # buildkit
2024-12-09 21:57:47 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2024-12-09 21:57:47 UTC (buildkit.dockerfile.v0)ARG TARGETARCH
2024-12-09 21:57:49 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-12-09 21:57:49 UTC (buildkit.dockerfile.v0)ARG GOSU_VERSION=1.16
2024-12-09 21:57:49 UTC (buildkit.dockerfile.v0)ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4
2024-12-09 21:57:49 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64 /usr/local/bin/gosu # buildkit
2024-12-09 21:57:49 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-amd64.asc /usr/local/bin/gosu.asc # buildkit
2024-12-09 21:57:50 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-12-09 21:57:50 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c id postgres || (echo "postgres user does not exist" && exit 1) # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY /tmp/wal-g /usr/local/bin/ # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/supautils.conf.j2 /etc/postgresql-custom/supautils.conf # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_extension_custom_scripts /etc/postgresql-custom/extension-custom-scripts # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_read_replica.conf.j2 /etc/postgresql-custom/read-replica.conf # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_walg.conf.j2 /etc/postgresql-custom/wal-g.conf # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit
2024-12-09 21:57:50 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.sh # buildkit
2024-12-09 21:57:50 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-12-09 21:57:51 UTC (buildkit.dockerfile.v0)COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/init-scripts/00-schema.sql # buildkit
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/migrations/00-extension.sql # buildkit
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)COPY /usr/local/bin/gosu /usr/local/bin/gosu # buildkit
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)ADD https://github.com/docker-library/postgres/raw/master/15/bullseye/docker-entrypoint.sh /usr/local/bin/ # buildkit
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /var/run/postgresql && chown postgres:postgres /var/run/postgresql # buildkit
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" "0s" '\n'}
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)ENV POSTGRES_HOST=/var/run/postgresql
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)ENV POSTGRES_USER=supabase_admin
2024-12-09 21:57:51 UTC (buildkit.dockerfile.v0)ENV POSTGRES_DB=postgres
2024-12-09 21:57:57 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-12-09 21:57:59 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-12-09 21:57:59 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.UTF-8
2024-12-09 21:57:59 UTC (buildkit.dockerfile.v0)ENV LANGUAGE=en_US:en
2024-12-09 21:57:59 UTC (buildkit.dockerfile.v0)ENV LC_ALL=en_US.UTF-8
2024-12-09 21:57:59 UTC (buildkit.dockerfile.v0)ENV LC_CTYPE=C.UTF-8
2024-12-09 21:57:59 UTC (buildkit.dockerfile.v0)ENV LC_COLLATE=C.UTF-8
2024-12-09 21:57:59 UTC (buildkit.dockerfile.v0)ENV LOCALE_ARCHIVE=/usr/lib/locale/locale-archive
2024-12-09 21:57:59 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.