Namespace
supabase
Image / Tagpostgres:15.1.0.47_amd64
Content Digestsha256:a2ce48b2c193a03435a46ae23038e5f887cd676192cb363f0eafeda88b242081
Details
2023-02-24 16:32:40 UTC
248 MB
Environment
DEBIAN_FRONTENDnoninteractive
GOSU_VERSION1.16
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/15/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR15
PG_VERSION15.1-1.pgdg110+1
POSTGRES_HOST/var/run/postgresql
POSTGRES_INITDB_ARGS--lc-ctype=C.UTF-8
Layers
[#000] sha256:bb263680fed18eecdc67f885094df6f589bafc19004839d7fdf141df236a61aa - 12.09% (30 MB)
[#001] sha256:75a54e59e691b29df361577e6c5b4d32fa6d2fa9039ad55f293d392f261afd68 - 1.7% (4.21 MB)
[#002] sha256:3ce7f8df2b36f15fa7e09f22a197cb272923063dab7c0164c918505c22bfbfbb - 0.0% (1.76 KB)
[#003] sha256:f30287ef02b9d1aa20483a1cb8af5136c17747081a4508cbbf9843dd960b7338 - 0.57% (1.4 MB)
[#004] sha256:dc1f0e9024d8067e86a5c358052285b986b7d113e4ebe2bf5534188547ba0150 - 3.1% (7.67 MB)
[#005] sha256:7f0a68628bceef9a8e7a7bad7a51a39ef4bea0e4d84449a54c8217486586591b - 0.49% (1.2 MB)
[#006] sha256:32b11818cae32e3bc189ab44f009297a2545c3b3fac7eb95c9c15201fda30080 - 0.0% (149 Bytes)
[#007] sha256:48111fe612c159d653ed7b96e5d6eb784f7b49fa920f66a17bbff924333b28c8 - 0.0% (3.12 KB)
[#008] sha256:07b5cb2894c7e025417216ebeb14c1b02720cd79523c9a47f5cb2ee654710d84 - 35.5% (87.9 MB)
[#009] sha256:7cca76b73db06b3589a5384a6f888a0de6425d822fe06316256bed702f082d04 - 0.0% (9.56 KB)
[#010] sha256:87f7b375a7d2491600497fec264ba959d855e64fbd6780b3cf24678c4722a210 - 0.0% (130 Bytes)
[#011] sha256:d9daaa1dc184568ee6012a64f53629d7f9297cea21cd7894b958f33739ff9fdc - 0.0% (202 Bytes)
[#012] sha256:536a8b3564501e359a7015b04d645f7a974843011b989878ba9bf6d5ccdce9f5 - 0.0% (4.67 KB)
[#013] sha256:94526d212a77bbb3bd0851463540a3c672a3b28bbb08389c3a1eee0bd36a7b47 - 14.27% (35.3 MB)
[#014] sha256:4f4a28aab65df1778d7e828e60a70b17e1205a0f8ef472fcb4641324facaaf25 - 32.26% (79.9 MB)
[#015] sha256:d441e542de88070a74e7e4e12ae40404e1cb27a4daf1807d7133d08557897287 - 0.0% (8.3 KB)
[#016] sha256:f83df0e183fc0f8d6252fb8655bb43a10af6e3db7cc963fc1f707b6801456640 - 0.0% (1.85 KB)
[#017] sha256:28756b6011d8b6c9807405dec6c3b7d2e1452427e46ae8fe6598c9e10d85ca5f - 0.0% (1 KB)
[#018] sha256:d3d2cb4488701549c9f7d580ae4177e173c923c8a3a15cbdefe5637a57527491 - 0.0% (291 Bytes)
[#019] sha256:0233191428b5efdacdd4b7f7f98662e213d671c284ab1bc2d771f7d121849262 - 0.0% (403 Bytes)
[#020] sha256:6a31931ab0c6fd0c8ec22ab063bcdd3fd28c7b40179c5efc1cfe0c674cb87d5d - 0.0% (8.41 KB)
[#021] sha256:c16ac4228af81b7ed394bc3c0d66ac53dc246ac359105b6bc531156724b8cab0 - 0.0% (489 Bytes)
[#022] sha256:794301b5d778d982e55306e589e4133bfc6b60c1c3f75dfebf8807e4873dcf9c - 0.0% (254 Bytes)
[#023] sha256:5302d73015c794e3192f83275234acfc8bafc8e53de42dc5435cd4a3a2c681c4 - 0.0% (8.72 KB)
History
/bin/sh -c #(nop) ADD file:3ea7c69e4bfac2ebb6f86baaedab31827c86a594dba8080a49928e211ad3c7a0 in /
2023-02-09 03:20:20 UTC/bin/sh -c #(nop) CMD ["bash"]
2023-02-09 04:39:37 UTC/bin/sh -c set -ex; if ! command -v gpg > /dev/null; then apt-get update; apt-get install -y --no-install-recommends gnupg dirmngr ; rm -rf /var/lib/apt/lists/*; fi
2023-02-09 04:39:38 UTC/bin/sh -c set -eux; groupadd -r postgres --gid=999; useradd -r -g postgres --uid=999 --home-dir=/var/lib/postgresql --shell=/bin/bash postgres; mkdir -p /var/lib/postgresql; chown -R postgres:postgres /var/lib/postgresql
2023-02-09 04:39:38 UTC/bin/sh -c #(nop) ENV GOSU_VERSION=1.16
2023-02-09 04:39:47 UTC/bin/sh -c set -eux; savedAptMark="$(apt-mark showmanual)"; apt-get update; apt-get install -y --no-install-recommends ca-certificates wget; rm -rf /var/lib/apt/lists/*; dpkgArch="$(dpkg --print-architecture | awk -F- '{ print $NF }')"; wget -O /usr/local/bin/gosu "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch"; wget -O /usr/local/bin/gosu.asc "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch.asc"; export GNUPGHOME="$(mktemp -d)"; gpg --batch --keyserver hkps://keys.openpgp.org --recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4; gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu; gpgconf --kill all; rm -rf "$GNUPGHOME" /usr/local/bin/gosu.asc; apt-mark auto '.*' > /dev/null; [ -z "$savedAptMark" ] || apt-mark manual $savedAptMark > /dev/null; apt-get purge -y --auto-remove -o APT::AutoRemove::RecommendsImportant=false; chmod +x /usr/local/bin/gosu; gosu --version; gosu nobody true
2023-02-09 04:39:54 UTC/bin/sh -c set -eux; if [ -f /etc/dpkg/dpkg.cfg.d/docker ]; then grep -q '/usr/share/locale' /etc/dpkg/dpkg.cfg.d/docker; sed -ri '/\/usr\/share\/locale/d' /etc/dpkg/dpkg.cfg.d/docker; ! grep -q '/usr/share/locale' /etc/dpkg/dpkg.cfg.d/docker; fi; 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
2023-02-09 04:39:54 UTC/bin/sh -c #(nop) ENV LANG=en_US.utf8
2023-02-09 04:39:57 UTC/bin/sh -c set -eux; apt-get update; apt-get install -y --no-install-recommends libnss-wrapper xz-utils zstd ; rm -rf /var/lib/apt/lists/*
2023-02-09 04:39:58 UTC/bin/sh -c mkdir /docker-entrypoint-initdb.d
2023-02-09 04:39:59 UTC/bin/sh -c set -ex; key='B97B0AFCAA1A47F044F244A07FCC7D46ACCC4CF8'; export GNUPGHOME="$(mktemp -d)"; mkdir -p /usr/local/share/keyrings/; gpg --batch --keyserver keyserver.ubuntu.com --recv-keys "$key"; gpg --batch --export --armor "$key" > /usr/local/share/keyrings/postgres.gpg.asc; command -v gpgconf > /dev/null && gpgconf --kill all; rm -rf "$GNUPGHOME"
2023-02-09 04:39:59 UTC/bin/sh -c #(nop) ENV PG_MAJOR=15
2023-02-09 04:39:59 UTC/bin/sh -c #(nop) ENV PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/15/bin
2023-02-09 04:40:00 UTC/bin/sh -c #(nop) ENV PG_VERSION=15.1-1.pgdg110+1
2023-02-09 04:40:19 UTC/bin/sh -c set -ex; export PYTHONDONTWRITEBYTECODE=1; dpkgArch="$(dpkg --print-architecture)"; aptRepo="[ signed-by=/usr/local/share/keyrings/postgres.gpg.asc ] http://apt.postgresql.org/pub/repos/apt/ bullseye-pgdg main $PG_MAJOR"; case "$dpkgArch" in amd64 | arm64 | ppc64el) echo "deb $aptRepo" > /etc/apt/sources.list.d/pgdg.list; apt-get update; ;; *) echo "deb-src $aptRepo" > /etc/apt/sources.list.d/pgdg.list; savedAptMark="$(apt-mark showmanual)"; tempDir="$(mktemp -d)"; cd "$tempDir"; apt-get update; apt-get install -y --no-install-recommends dpkg-dev; echo "deb [ trusted=yes ] file://$tempDir ./" > /etc/apt/sources.list.d/temp.list; _update_repo() { dpkg-scanpackages . > Packages; apt-get -o Acquire::GzipIndexes=false update; }; _update_repo; nproc="$(nproc)"; export DEB_BUILD_OPTIONS="nocheck parallel=$nproc"; apt-get build-dep -y postgresql-common pgdg-keyring; apt-get source --compile postgresql-common pgdg-keyring; _update_repo; apt-get build-dep -y "postgresql-$PG_MAJOR=$PG_VERSION"; apt-get source --compile "postgresql-$PG_MAJOR=$PG_VERSION"; apt-mark showmanual | xargs apt-mark auto > /dev/null; apt-mark manual $savedAptMark; ls -lAFh; _update_repo; grep '^Package: ' Packages; cd /; ;; esac; apt-get install -y --no-install-recommends postgresql-common; sed -ri 's/#(create_main_cluster) .*$/\1 = false/' /etc/postgresql-common/createcluster.conf; apt-get install -y --no-install-recommends "postgresql-$PG_MAJOR=$PG_VERSION" ; rm -rf /var/lib/apt/lists/*; if [ -n "$tempDir" ]; then apt-get purge -y --auto-remove; rm -rf "$tempDir" /etc/apt/sources.list.d/temp.list; fi; find /usr -name '*.pyc' -type f -exec bash -c 'for pyc; do dpkg -S "$pyc" &> /dev/null || rm -vf "$pyc"; done' -- '{}' +; postgres --version
2023-02-09 04:40:20 UTC/bin/sh -c set -eux; dpkg-divert --add --rename --divert "/usr/share/postgresql/postgresql.conf.sample.dpkg" "/usr/share/postgresql/$PG_MAJOR/postgresql.conf.sample"; cp -v /usr/share/postgresql/postgresql.conf.sample.dpkg /usr/share/postgresql/postgresql.conf.sample; ln -sv ../postgresql.conf.sample "/usr/share/postgresql/$PG_MAJOR/"; sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/share/postgresql/postgresql.conf.sample; grep -F "listen_addresses = '*'" /usr/share/postgresql/postgresql.conf.sample
2023-02-09 04:40:21 UTC/bin/sh -c mkdir -p /var/run/postgresql && chown -R postgres:postgres /var/run/postgresql && chmod 2777 /var/run/postgresql
2023-02-09 04:40:21 UTC/bin/sh -c #(nop) ENV PGDATA=/var/lib/postgresql/data
2023-02-09 04:40:21 UTC/bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 777 "$PGDATA"
2023-02-09 04:40:21 UTC/bin/sh -c #(nop) VOLUME [/var/lib/postgresql/data]
2023-02-09 04:40:22 UTC/bin/sh -c #(nop) COPY file:d4c2ceee202d1390df115217c6e567abc1da7a31572f20a840d966332148ebe4 in /usr/local/bin/
2023-02-09 04:40:22 UTC/bin/sh -c #(nop) ENTRYPOINT ["docker-entrypoint.sh"]
2023-02-09 04:40:22 UTC/bin/sh -c #(nop) STOPSIGNAL SIGINT
2023-02-09 04:40:22 UTC/bin/sh -c #(nop) EXPOSE 5432
2023-02-09 04:40:22 UTC/bin/sh -c #(nop) CMD ["postgres"]
2023-02-24 16:29:44 UTC (buildkit.dockerfile.v0)ARG TARGETARCH
2023-02-24 16:29:44 UTC (buildkit.dockerfile.v0)ARG postgresql_major
2023-02-24 16:29:44 UTC (buildkit.dockerfile.v0)COPY /tmp /tmp # buildkit
2023-02-24 16:29:44 UTC (buildkit.dockerfile.v0)ENV DEBIAN_FRONTEND=noninteractive
2023-02-24 16:30:00 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c apt-get update && apt-get install -y --no-install-recommends /tmp/*.deb && rm -rf /var/lib/apt/lists/* /tmp/* # buildkit
2023-02-24 16:30:00 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit
2023-02-24 16:30:00 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit
2023-02-24 16:30:00 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit
2023-02-24 16:30:00 UTC (buildkit.dockerfile.v0)COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit
2023-02-24 16:30:00 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/15/bin/pgsodium_getkey.sh # buildkit
2023-02-24 16:30:00 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c sed -i "s/#unix_socket_directories = '\/tmp'/unix_socket_directories = '\/var\/run\/postgresql'/g" /etc/postgresql/postgresql.conf && echo "cron.database_name = 'postgres'" >> /etc/postgresql/postgresql.conf && echo "pljava.libjvm_location = '/usr/lib/jvm/java-11-openjdk-${TARGETARCH}/lib/server/libjvm.so'" >> /etc/postgresql/postgresql.conf && echo "pgsodium.getkey_script= '/usr/lib/postgresql/${postgresql_major}/bin/pgsodium_getkey.sh'" >> /etc/postgresql/postgresql.conf && echo 'auto_explain.log_min_duration = 10s' >> /etc/postgresql/postgresql.conf && mkdir -p /etc/postgresql-custom && chown postgres:postgres /etc/postgresql-custom # buildkit
2023-02-24 16:30:00 UTC (buildkit.dockerfile.v0)COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/00-schema.sql # buildkit
2023-02-24 16:30:00 UTC (buildkit.dockerfile.v0)COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/01-extension.sql # buildkit
2023-02-24 16:32:40 UTC (buildkit.dockerfile.v0)COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit
2023-02-24 16:32:40 UTC (buildkit.dockerfile.v0)ENV POSTGRES_HOST=/var/run/postgresql
2023-02-24 16:32:40 UTC (buildkit.dockerfile.v0)ENV POSTGRES_INITDB_ARGS=--lc-ctype=C.UTF-8
2023-02-24 16:32:40 UTC (buildkit.dockerfile.v0)CMD ["postgres" "-D" "/etc/postgresql"]
2023-02-24 16:32:40 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" '\n'}
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.