Namespace
supabase
Image / Tag
postgres:15.1.0.43_amd64
Content Digest
sha256:8b287ef4bd38d3156e22ee6a65d62830678c036b000e70d454640e57e1a4c5a4
Details
Created

2023-02-21 06:31:47 UTC

Size

247 MB

Content Digest
Environment
DEBIAN_FRONTEND

noninteractive

GOSU_VERSION

1.16

LANG

en_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_MAJOR

15

PG_VERSION

15.1-1.pgdg110+1

POSTGRES_HOST

/var/run/postgresql

POSTGRES_INITDB_ARGS

--lc-ctype=C.UTF-8


Layers

[#000] sha256:bb263680fed18eecdc67f885094df6f589bafc19004839d7fdf141df236a61aa - 12.11% (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.54% (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:14f44c71631af0b0293ac8b2880201a33eeeed404e0dd54725930d7d270b9aad - 14.24% (35.2 MB)

[#014] sha256:ee43e96a76df5d6daf6c4ae5dbad3c916fde45f3a16f281dea79961535d367aa - 32.24% (79.8 MB)

[#015] sha256:6a50ba0eb45316525e7019fd665586c36a47c2b9488aeffca1a019e5a04ed503 - 0.0% (8.29 KB)

[#016] sha256:f4995050b97b9034c3827bcf79814f1c9f4490997a6cd4e5b3fa6f547eda1868 - 0.0% (1.85 KB)

[#017] sha256:a01e6b404c9d498d4e40487e45547bdc5e50848b95c66d29c9d3baa2358e9af2 - 0.0% (1 KB)

[#018] sha256:79de78b2d65d6389474201784f1d909fb9f7179a4134270ae9cb65906eb8fba9 - 0.0% (289 Bytes)

[#019] sha256:f10efdf6f1078f51dfa4782cc0fed6b8f21b5f20a29ae71cdb1bf8e6e8eb8b5a - 0.0% (402 Bytes)

[#020] sha256:ed670e594f44b57302461431b89367d5b81f5473521dac404082332b9835fb64 - 0.0% (8.41 KB)

[#021] sha256:096d31231d6deebbb88139f9e8b0f615bed77f2f3118ec3fbd096dfd30a2e7c3 - 0.0% (488 Bytes)

[#022] sha256:79436d51bff85b721c8b6e94cead769120e683664d49ebcfae45413724c3ff70 - 0.0% (254 Bytes)

[#023] sha256:ca7ee4205b50f2abf3abb097bc27fa51472c71848e6a5291f1050ee5c69cce29 - 0.0% (8.72 KB)


History
2023-02-09 03:20:20 UTC

/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-21 06:31:31 UTC (buildkit.dockerfile.v0)

ARG TARGETARCH

2023-02-21 06:31:31 UTC (buildkit.dockerfile.v0)

ARG postgresql_major

2023-02-21 06:31:31 UTC (buildkit.dockerfile.v0)

COPY /tmp /tmp # buildkit

2023-02-21 06:31:31 UTC (buildkit.dockerfile.v0)

ENV DEBIAN_FRONTEND=noninteractive

2023-02-21 06:31:46 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-21 06:31:46 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/postgresql.conf.j2 /etc/postgresql/postgresql.conf # buildkit

2023-02-21 06:31:46 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/pg_hba.conf.j2 /etc/postgresql/pg_hba.conf # buildkit

2023-02-21 06:31:46 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/pg_ident.conf.j2 /etc/postgresql/pg_ident.conf # buildkit

2023-02-21 06:31:46 UTC (buildkit.dockerfile.v0)

COPY ansible/files/postgresql_config/postgresql-stdout-log.conf /etc/postgresql/logging.conf # buildkit

2023-02-21 06:31:46 UTC (buildkit.dockerfile.v0)

COPY ansible/files/pgsodium_getkey_urandom.sh.j2 /usr/lib/postgresql/15/bin/pgsodium_getkey.sh # buildkit

2023-02-21 06:31:47 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-21 06:31:47 UTC (buildkit.dockerfile.v0)

COPY ansible/files/pgbouncer_config/pgbouncer_auth_schema.sql /docker-entrypoint-initdb.d/00-schema.sql # buildkit

2023-02-21 06:31:47 UTC (buildkit.dockerfile.v0)

COPY ansible/files/stat_extension.sql /docker-entrypoint-initdb.d/01-extension.sql # buildkit

2023-02-21 06:31:47 UTC (buildkit.dockerfile.v0)

COPY migrations/db /docker-entrypoint-initdb.d/ # buildkit

2023-02-21 06:31:47 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_HOST=/var/run/postgresql

2023-02-21 06:31:47 UTC (buildkit.dockerfile.v0)

ENV POSTGRES_INITDB_ARGS=--lc-ctype=C.UTF-8

2023-02-21 06:31:47 UTC (buildkit.dockerfile.v0)

CMD ["postgres" "-D" "/etc/postgresql"]

2023-02-21 06:31:47 UTC (buildkit.dockerfile.v0)

HEALTHCHECK &{["CMD-SHELL" "pg_isready -U postgres -h localhost"] "2s" "2s" "0s" '\n'}

Danger Zone
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.

Delete