Namespace
supabase
Image / Tagpostgres:15.6.1.100_arm64
Content Digestsha256:dbdab4bb07135951a7682c385fae39a899ceef3151136c965033cb639161d161
Details
2024-07-30 14:34:29 UTC
741 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_HOST/var/run/postgresql
Layers
[#000] sha256:f02209be4ee528c246399de81af4552e52adb005a8a499815607b6b0d42746bf - 3.34% (24.8 MB)
[#001] sha256:a90455234d8d9538f75651f7ee041eae4372198c8cd8512f002593705d401d8e - 9.63% (71.4 MB)
[#002] sha256:81ad3e857acf06a39bbb50af43d6d41cdbd1d81920f649d0302cf9865af678d5 - 0.0% (1.53 KB)
[#003] sha256:32e48954ae6511e65fb963c610bad621fc52771404cec92653dc4846e22a34ab - 0.0% (1.55 KB)
[#004] sha256:bf82c56aa8573c341bb52a745592cb96fef402b3e34889ab1309011a4e8d388a - 7.66% (56.8 MB)
[#005] sha256:7b858a399e818be1f0a21632918587e869622936bfafd1fb9ff280b96f65e61a - 0.03% (250 KB)
[#006] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#007] sha256:7caeee29f954056cc3093c070b70493de3fccb4609d9dea665dea8f2425e66c1 - 64.36% (477 MB)
[#008] sha256:09e2c8cab56555a3e22802458697985e4cfed652f74004ddd6390fafc55eef52 - 0.0% (219 Bytes)
[#009] sha256:c5b677be38b2f803a5d98c3bc546d45e822566e593054b8be7b8f1f461d30e5f - 2.14% (15.9 MB)
[#010] sha256:b033bc25cb58f483ecfacf5d038c03613e7cbee4a8a3aad0bc49a857a2951d2b - 0.0% (584 Bytes)
[#011] sha256:4796a970e7aa8e89c538c132187127973e937989c0b053906b64f4e3415e8960 - 0.0% (564 Bytes)
[#012] sha256:22729f2ce6e3a449057ad4cc228a6a9bcfa3802b4699aede5a272ae1039c3224 - 0.0% (581 Bytes)
[#013] sha256:dc9f7ebcac7b02d145b41a2f9edd0207681dd21aea3d6874fe47b23116dcea88 - 0.0% (561 Bytes)
[#014] sha256:502dc6ed763812e441505fce8cb7cd0c6a9d2883e44ffab006c84536775dc5db - 0.11% (803 KB)
[#015] sha256:b3df03a16a0b3ab16360392993746a076b4465acc58ce0c8ecf99e655388c5a9 - 0.0% (1.21 KB)
[#016] sha256:ccc14dc8b3b3c92d5664587962863146b8edab1b9f4430a333024239103a3edd - 0.0% (286 Bytes)
[#017] sha256:b8f3cd48341ec4ed4ee6267b06d1343c144fa7ba7630fba26c9977447b1fe24f - 0.0% (1.17 KB)
[#018] sha256:60c3cd97b95bd5c20fa82c214e7f2348c72056e787b1612559216f4209a12b41 - 0.06% (432 KB)
[#019] sha256:43744ef2404b64b7a26e5169a3b5ae7e1f8d3753d8ab25276383d9151b321587 - 9.72% (72 MB)
[#020] sha256:b43aac7ed1d923ddedf7651db9c1ff89193f3ab256934f7fae54839caba149d3 - 0.0% (1.82 KB)
[#021] sha256:d19db62876a21fdb1fc8e947949eeb4a2ec45d6b71b9afb752403fabf036951e - 0.12% (892 KB)
[#022] sha256:7fee10421c45d9c3aae9b7a202273c64de7fb4618c2e92cafd2e72919b20570f - 0.0% (796 Bytes)
[#023] sha256:56172af24c9aa02dc06c0901c3fa86c6ed51443799d1d8b0905dbe12791b75fb - 0.12% (909 KB)
[#024] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#025] sha256:c26e1a294340421b476e36f15de894a7af0149c7568e5216a66aca12d34fa1fa - 1.56% (11.6 MB)
[#026] sha256:51f174aae8a1a6842de55d88fd438fd8fc89f43947dc116bd84c0b854b72b73e - 0.0% (8.33 KB)
[#027] sha256:bad05f66f7c74e77ba3192de716b21c2a2cd8e1c164e6a1511fcf06cb8c688eb - 0.0% (1.84 KB)
[#028] sha256:0c56e8f8147a7b41551d26d0b4c731b616ec3b65c97ef6167beb4cdeb8005dbd - 0.0% (1017 Bytes)
[#029] sha256:63aec38d860a9270ac433aa0f98981c4c3914f6f8c4f98a0650d0daed418de80 - 0.0% (277 Bytes)
[#030] sha256:2170be65b05d8260f34f91a3c27181dcfc5dcd2aada4ba7588fc053f4f0a9b57 - 0.0% (1.26 KB)
[#031] sha256:b93581acd635f3ec0185d37d7841c9c58656e26aed6a5f092b4bb00982a7a639 - 0.0% (1.9 KB)
[#032] sha256:e5ef175959b9b256cc873dc52e9196e0b35f24f237dbcc46ebae583c74db0175 - 0.0% (363 Bytes)
[#033] sha256:d8b02aec582b6f751cd8173dae9eeb30d013f3ad57d12b885bc24f9f0db239e4 - 0.0% (335 Bytes)
[#034] sha256:4717854b5710a7905b90852a4ebf1e0d8dac6ee02c6046a7d192b7d176fbc4bc - 0.0% (393 Bytes)
[#035] sha256:df304604f32018e456b67e283f9b2ec6265750b331400197e3c8bb05c5e04607 - 0.0% (398 Bytes)
[#036] sha256:50cac3f65e4045e915c5d26a032e887293be832bff84bc3620a3f2be31582acb - 0.0% (637 Bytes)
[#037] sha256:344403bb518b4accb6a86ddb095e90387411c15cf906066169af253b24ef7147 - 0.0% (9.06 KB)
[#038] sha256:1f5cf5b465f252ab1d2ce66a08236da2a7c8b7b54d660717d02985dcb878b1d9 - 0.0% (9.75 KB)
[#039] sha256:4012fb767b9b8e5b072ecc0b18edd9a6c76d05f7b058c8a5bee33bd4198e5a07 - 0.0% (508 Bytes)
[#040] sha256:7c73a4eb37d02a0d756f89d9092302bc95f52959561bd4f9e986c5250ba81159 - 0.0% (272 Bytes)
[#041] sha256:4f4fb700ef54461cfa02571ae0db9a0dc1e0cdb5577484a6d75e68dc38e8acc1 - 0.0% (32 Bytes)
[#042] sha256:47a0c936f97bfb7c018dc03a910ab3626795fa60306af4defc606e05458037c7 - 0.0% (4.76 KB)
[#043] sha256:5e91fd62a6e7f59e8ac4fa209bc149658287b25b60b9ac37e3ea46edcb2faf20 - 0.0% (128 Bytes)
[#044] sha256:94a4cb3ce2c99e33b318384f2986ef82fc9ee83ab3499c3e595b34482ca994c8 - 0.96% (7.1 MB)
[#045] sha256:2757e8a95ec0d2f07d46e82187f3b49dae8d68ae0dfbaeed101117a19a89d7ce - 0.2% (1.5 MB)
History
/bin/sh -c #(nop) ARG RELEASE
2024-06-03 16:52:57 UTC/bin/sh -c #(nop) ARG LAUNCHPAD_BUILD_ARCH
2024-06-03 16:52:57 UTC/bin/sh -c #(nop) LABEL org.opencontainers.image.ref.name=ubuntu
2024-06-03 16:52:57 UTC/bin/sh -c #(nop) LABEL org.opencontainers.image.version=20.04
2024-06-03 16:52:59 UTC/bin/sh -c #(nop) ADD file:6d8cc056ee741f09a6c7d965d8e2027d80ed2eccbfb0312593ce52d9256db437 in /
2024-06-03 16:52:59 UTC/bin/sh -c #(nop) CMD ["/bin/bash"]
2024-07-30 14:31:23 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-07-30 14:31:23 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-07-30 14:31:23 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c adduser --system --no-create-home --shell /bin/bash --group wal-g # buildkit
2024-07-30 14:31:30 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-07-30 14:31:30 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-07-30 14:31:30 UTC (buildkit.dockerfile.v0)COPY . /nixpg # buildkit
2024-07-30 14:31:30 UTC (buildkit.dockerfile.v0)WORKDIR /nixpg
2024-07-30 14:32:39 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c nix profile install .#psql_15/bin # buildkit
2024-07-30 14:32:39 UTC (buildkit.dockerfile.v0)WORKDIR /
2024-07-30 14:32:41 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-07-30 14:32:42 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-07-30 14:32:42 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/lib/postgresql/share/postgresql/ # buildkit
2024-07-30 14:32:42 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -s /nix/var/nix/profiles/default/share/postgresql/* /usr/share/postgresql/ # buildkit
2024-07-30 14:32:42 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql/share/postgresql/ # buildkit
2024-07-30 14:32:42 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/share/postgresql/ # buildkit
2024-07-30 14:32:43 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-07-30 14:32:43 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c chown -R postgres:postgres /usr/lib/postgresql # buildkit
2024-07-30 14:32:43 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -sf /usr/lib/postgresql/share/postgresql/timezonesets /usr/share/postgresql/timezonesets # buildkit
2024-07-30 14:32:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends tzdata # buildkit
2024-07-30 14:32:46 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c ln -fs /usr/share/zoneinfo/Etc/UTC /etc/localtime && dpkg-reconfigure --frontend noninteractive tzdata # buildkit
2024-07-30 14:33:56 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends build-essential checkinstall cmake # buildkit
2024-07-30 14:33:56 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2024-07-30 14:33:56 UTC (buildkit.dockerfile.v0)ARG TARGETARCH
2024-07-30 14:33:59 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
2024-07-30 14:33:59 UTC (buildkit.dockerfile.v0)ARG GOSU_VERSION=1.16
2024-07-30 14:33:59 UTC (buildkit.dockerfile.v0)ARG GOSU_GPG_KEY=B42F6819007F00F88E364FD4036A9C25BF357DD4
2024-07-30 14:33:59 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-arm64 /usr/local/bin/gosu # buildkit
2024-07-30 14:33:59 UTC (buildkit.dockerfile.v0)ADD https://github.com/tianon/gosu/releases/download/1.16/gosu-arm64.asc /usr/local/bin/gosu.asc # buildkit
2024-07-30 14:34:00 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
2024-07-30 14:34:00 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c id postgres || (echo "postgres user does not exist" && exit 1) # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY /tmp/wal-g /usr/local/bin/ # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/supautils.conf.j2 /etc/postgresql-custom/supautils.conf # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_extension_custom_scripts /etc/postgresql-custom/extension-custom-scripts # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/bin/pgsodium_getkey.sh # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_read_replica.conf.j2 /etc/postgresql-custom/read-replica.conf # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/custom_walg.conf.j2 /etc/postgresql-custom/wal-g.conf # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_fetch.sh /home/postgres/wal_fetch.sh # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/walg_helper_scripts/wal_change_ownership.sh /root/wal_change_ownership.sh # buildkit
2024-07-30 14:34:01 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-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/init-scripts/00-schema.sql # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/migrations/00-extension.sql # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)COPY /usr/local/bin/gosu /usr/local/bin/gosu # buildkit
2024-07-30 14:34:01 UTC (buildkit.dockerfile.v0)ADD https://github.com/docker-library/postgres/raw/master/15/bullseye/docker-entrypoint.sh /usr/local/bin/ # buildkit
2024-07-30 14:34:02 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p /var/run/postgresql && chown postgres:postgres /var/run/postgresql # buildkit
2024-07-30 14:34:02 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2024-07-30 14:34:02 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" "0s" '\n'}
2024-07-30 14:34:02 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2024-07-30 14:34:02 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2024-07-30 14:34:02 UTC (buildkit.dockerfile.v0)ENV POSTGRES_HOST=/var/run/postgresql
2024-07-30 14:34:26 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends locales && rm -rf /var/lib/apt/lists/* && localedef -i en_US -c -f UTF-8 -A /usr/share/locale/locale.alias en_US.UTF-8 && localedef -i C -c -f UTF-8 -A /usr/share/locale/locale.alias C.UTF-8 # buildkit
2024-07-30 14:34:29 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c echo "C.UTF-8 UTF-8" > /etc/locale.gen && echo "en_US.UTF-8 UTF-8" >> /etc/locale.gen && locale-gen # buildkit
2024-07-30 14:34:29 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.UTF-8
2024-07-30 14:34:29 UTC (buildkit.dockerfile.v0)ENV LANGUAGE=en_US:en
2024-07-30 14:34:29 UTC (buildkit.dockerfile.v0)ENV LC_ALL=en_US.UTF-8
2024-07-30 14:34:29 UTC (buildkit.dockerfile.v0)ENV LC_CTYPE=C.UTF-8
2024-07-30 14:34:29 UTC (buildkit.dockerfile.v0)ENV LC_COLLATE=C.UTF-8
2024-07-30 14:34:29 UTC (buildkit.dockerfile.v0)ENV LOCALE_ARCHIVE=/usr/lib/locale/locale-archive
2024-07-30 14:34:29 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.