Tag

library/postgres:11.22-alpine3.18
Content Digest: sha256:6d566df3f466bae532a396f9496c7e7fa232d8e39919013ce94109d2b9a6300a
Manifests
Details
Content Digest

sha256:3dcb0d6d2ae608e0920bfe0a5adc8eb6c340d5a3bdabfd44399a401fec22ac1e

Created

2023-11-30 00:11:07 UTC

Size

85.3 MB


Environment
DOCKER_PG_LLVM_DEPS

llvm15-dev clang15

LANG

en_US.utf8

PATH

/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

PGDATA

/var/lib/postgresql/data

PG_MAJOR

11

PG_SHA256

2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

PG_VERSION

11.22


Layers

[#000] sha256:c926b61bad3b94ae7351bafd0c184c159ebf0643b085f7ef1d47ecdc7316833c - 3.81% (3.24 MB)

[#001] sha256:e915d0b8530143b20886c020822068391e6db91b6fd0db7f327ac0fcc360d670 - 0.0% (1.23 KB)

[#002] sha256:ddf151f63d3273cb2b290eace3b147e1b3a075383cc5e4a3d74cf7d876a9beef - 0.0% (116 Bytes)

[#003] sha256:8cb994074e8c502f89efd63f30cb4138bad8b5e5535d3bb38f9cf4e769ab9594 - 96.18% (82 MB)

[#004] sha256:2e8cbb16f6188c3a18c43f84cde5504c73d2d5db4ad3c804d57e23004e9f7c07 - 0.01% (7.79 KB)

[#005] sha256:1151c9479185ff27568f80472d586983daaf7b46816cf7731339f351e0eafd95 - 0.0% (127 Bytes)

[#006] sha256:105d9670556043a80fba35deb532e5e1cd8be1ed91505da9f134f209fe8ae8d3 - 0.0% (169 Bytes)

[#007] sha256:31427546244d366a7a55b1e0471fbd7320a47d99f3a1c4ff385c66e7e8b51951 - 0.01% (4.67 KB)


History
2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) ADD file:fc714080c3bcbbce7ac746a10d7b4355ffa36293a8d435d62cd5359ea8eb8364 in /

2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) CMD ["/bin/sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; addgroup -g 70 -S postgres; adduser -u 70 -S -D -G postgres -H -h /var/lib/postgresql -s /bin/sh postgres; mkdir -p /var/lib/postgresql; chown -R postgres:postgres /var/lib/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.utf8

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_MAJOR=11

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=11.22

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"11.22","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@11.22?os_name=alpine&os_version=3.18"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; cp -v /usr/local/share/postgresql/postgresql.conf.sample /usr/local/share/postgresql/postgresql.conf.sample.orig; sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/local/share/postgresql/postgresql.conf.sample; grep -F "listen_addresses = '*'" /usr/local/share/postgresql/postgresql.conf.sample # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /var/run/postgresql && chown -R postgres:postgres /var/run/postgresql && chmod 3777 /var/run/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 1777 "$PGDATA" # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

VOLUME [/var/lib/postgresql/data]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

COPY docker-entrypoint.sh /usr/local/bin/ # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

CMD ["postgres"]

Details
Content Digest

sha256:5824bafbcfd4c5e877b4b478a40cff1d636c0342ef3b2a63cdc9634c174050b2

Created

2023-11-30 00:11:07 UTC

Size

84.1 MB


Environment
DOCKER_PG_LLVM_DEPS

llvm15-dev clang15

LANG

en_US.utf8

PATH

/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

PGDATA

/var/lib/postgresql/data

PG_MAJOR

11

PG_SHA256

2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

PG_VERSION

11.22


Layers

[#000] sha256:85ae953f9e6740471d4e1440b27721679dc7a511e112eb73df467a4cde26e421 - 3.57% (3 MB)

[#001] sha256:b15fd338a558cca8e8fb9e95da4b163d4139e04b07c8f17e217ca5072c85c378 - 0.0% (1.23 KB)

[#002] sha256:343abf89f372cbd395abbb9f47b6e96b2f565771cbd8baac6584d4080fcb49d6 - 0.0% (116 Bytes)

[#003] sha256:e3ee42209ce2b7b91bf4403106eaaad2365f18bd2cd86377992904fe6a21b19d - 96.41% (81.1 MB)

[#004] sha256:d0781bd76b1e166e0a703bc88aa64db4b9b0fab4e796184d22d2828a88a5c9f2 - 0.01% (7.8 KB)

[#005] sha256:13e622035c6e640e37ba031f135ac347a62bdc470933475b6eeb63b5318eb247 - 0.0% (128 Bytes)

[#006] sha256:7fa0d2dfbcdee2ddc5b2cea47363efc56fbbd2ccb52357b80d7e9b2d08641c44 - 0.0% (170 Bytes)

[#007] sha256:d6850d31c6a61e49d754db5fe536099c7775a219d8d4d95a1705c45d35a61504 - 0.01% (4.67 KB)


History
2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) ADD file:dbf65487d049081dc2d39b3d99d2c64b6c89754e7e2996a46169d3512e59f32a in /

2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) CMD ["/bin/sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; addgroup -g 70 -S postgres; adduser -u 70 -S -D -G postgres -H -h /var/lib/postgresql -s /bin/sh postgres; mkdir -p /var/lib/postgresql; chown -R postgres:postgres /var/lib/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.utf8

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_MAJOR=11

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=11.22

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"11.22","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@11.22?os_name=alpine&os_version=3.18"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; cp -v /usr/local/share/postgresql/postgresql.conf.sample /usr/local/share/postgresql/postgresql.conf.sample.orig; sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/local/share/postgresql/postgresql.conf.sample; grep -F "listen_addresses = '*'" /usr/local/share/postgresql/postgresql.conf.sample # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /var/run/postgresql && chown -R postgres:postgres /var/run/postgresql && chmod 3777 /var/run/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 1777 "$PGDATA" # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

VOLUME [/var/lib/postgresql/data]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

COPY docker-entrypoint.sh /usr/local/bin/ # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

CMD ["postgres"]

Details
Content Digest

sha256:430ebaab0e53750be5f63edf72e0c5a38c1d843e1a7f6c21878ef8656d8523d2

Created

2023-11-30 00:11:07 UTC

Size

79.1 MB


Environment
DOCKER_PG_LLVM_DEPS

llvm15-dev clang15

LANG

en_US.utf8

PATH

/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

PGDATA

/var/lib/postgresql/data

PG_MAJOR

11

PG_SHA256

2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

PG_VERSION

11.22


Layers

[#000] sha256:2387a44129d2147bd4e806bf369f3db92eb3ad3b6b8825c739db364b8baa4e26 - 3.5% (2.77 MB)

[#001] sha256:e2bfc0542e5492e97a68e6f18e94440d45ffc8761699bca754d8dfc93e8481b3 - 0.0% (1.23 KB)

[#002] sha256:e6789a1e41e6e508d9a04707412592f64bc62f1c1cbbc44d48af6c4b056f6bbf - 0.0% (116 Bytes)

[#003] sha256:2b066debeb2d8ae7ac304542860c817c028440f8183c69cec7d3fe8c096b5071 - 96.49% (76.4 MB)

[#004] sha256:6827ea9cfed21596bedd34c32392d144f4865a00ab016e14665a38b8153f8a96 - 0.01% (7.8 KB)

[#005] sha256:163b395bb0b47bb68e498fda7db23d34a36666a03205ee755a63acf634137eda - 0.0% (128 Bytes)

[#006] sha256:22e7a77e7428a81e475bc904b808d686e80d5ab7a68b3e4241c5dd390aaa97d9 - 0.0% (170 Bytes)

[#007] sha256:6d284e5c457e5801ccc42b34faf63e0ee8f40ed65c6ba6abc55bd6f37e69a572 - 0.01% (4.67 KB)


History
2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) ADD file:dcb85d43d1fb96861612c42288878b13debfa9d0b956adea1f2472d0c50f0144 in /

2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) CMD ["/bin/sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; addgroup -g 70 -S postgres; adduser -u 70 -S -D -G postgres -H -h /var/lib/postgresql -s /bin/sh postgres; mkdir -p /var/lib/postgresql; chown -R postgres:postgres /var/lib/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.utf8

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_MAJOR=11

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=11.22

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"11.22","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@11.22?os_name=alpine&os_version=3.18"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; cp -v /usr/local/share/postgresql/postgresql.conf.sample /usr/local/share/postgresql/postgresql.conf.sample.orig; sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/local/share/postgresql/postgresql.conf.sample; grep -F "listen_addresses = '*'" /usr/local/share/postgresql/postgresql.conf.sample # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /var/run/postgresql && chown -R postgres:postgres /var/run/postgresql && chmod 3777 /var/run/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 1777 "$PGDATA" # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

VOLUME [/var/lib/postgresql/data]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

COPY docker-entrypoint.sh /usr/local/bin/ # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

CMD ["postgres"]

Details
Content Digest

sha256:ee81634e833be5d552bc6ded74e9dfe5de112b2b724547556383befb502ff86e

Created

2023-11-30 00:11:07 UTC

Size

84.4 MB


Environment
DOCKER_PG_LLVM_DEPS

llvm15-dev clang15

LANG

en_US.utf8

PATH

/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

PGDATA

/var/lib/postgresql/data

PG_MAJOR

11

PG_SHA256

2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

PG_VERSION

11.22


Layers

[#000] sha256:2c03dbb20264f09924f9eab176da44e5421e74a78b09531d3c63448a7baa7c59 - 3.77% (3.18 MB)

[#001] sha256:f798db588ae6fde88b954134dc2770c538e7f303f6722bb97530b45d03fcfb77 - 0.0% (1.23 KB)

[#002] sha256:8ce70f11c3056d3f50af6aea7118a185ccb0281e752b45b0601fa5746444263c - 0.0% (116 Bytes)

[#003] sha256:a724911b55be5bd919922ee18e0487693d56552e9bfef4f60a883b3a53b0203e - 96.22% (81.2 MB)

[#004] sha256:d0806037f8458910349bd09bfda75d119c80f1c277b53e262aad80eb99eb7adb - 0.01% (7.79 KB)

[#005] sha256:27980d1439861d3cc6c59ec763db63e5da685a9ead2eac9aaa443eeda7439dec - 0.0% (129 Bytes)

[#006] sha256:5de5c27b129b730a5f4442c5de6a3fe8806ca8fd647782ea2679258caec5017b - 0.0% (169 Bytes)

[#007] sha256:5fc83771086a375b58b7e32c1e10135eb4acfb86a9f18380032bb6008e122990 - 0.01% (4.67 KB)


History
2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) ADD file:d8a30995bbcd627f084912c728fda5483b6ba486de25af588a0956069d0bd7ad in /

2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) CMD ["/bin/sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; addgroup -g 70 -S postgres; adduser -u 70 -S -D -G postgres -H -h /var/lib/postgresql -s /bin/sh postgres; mkdir -p /var/lib/postgresql; chown -R postgres:postgres /var/lib/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.utf8

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_MAJOR=11

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=11.22

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"11.22","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@11.22?os_name=alpine&os_version=3.18"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; cp -v /usr/local/share/postgresql/postgresql.conf.sample /usr/local/share/postgresql/postgresql.conf.sample.orig; sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/local/share/postgresql/postgresql.conf.sample; grep -F "listen_addresses = '*'" /usr/local/share/postgresql/postgresql.conf.sample # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /var/run/postgresql && chown -R postgres:postgres /var/run/postgresql && chmod 3777 /var/run/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 1777 "$PGDATA" # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

VOLUME [/var/lib/postgresql/data]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

COPY docker-entrypoint.sh /usr/local/bin/ # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

CMD ["postgres"]

Details
Content Digest

sha256:d53649c6aa9dc7d2ed1293bb8288856d112130c468e7ed65177a39705bc0a10c

Created

2023-11-30 00:11:07 UTC

Size

90.5 MB


Environment
DOCKER_PG_LLVM_DEPS

llvm15-dev clang15

LANG

en_US.utf8

PATH

/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

PGDATA

/var/lib/postgresql/data

PG_MAJOR

11

PG_SHA256

2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

PG_VERSION

11.22


Layers

[#000] sha256:4e13780adf2776477b14ef9c0f4f563f820a2fde166d472218037b979e84d31a - 3.53% (3.19 MB)

[#001] sha256:c97a8f2d8d939eb0eea89a93502a87ad9d40da077a6fe6af4156f76e3acc8449 - 0.0% (1.23 KB)

[#002] sha256:6cc48f355de7494bf68cde21c4435ea2e5cb59e0946f9becd7f9b7efedae2168 - 0.0% (116 Bytes)

[#003] sha256:e0aafe7f676c4f50367c104e95e96338fde2443dd66183c2c20c48bff6f318f0 - 96.46% (87.3 MB)

[#004] sha256:64a28da62776d835824163b867df9cb2bd135ea7ce2ebfd733a52d09860a76e1 - 0.01% (7.8 KB)

[#005] sha256:235fd9df6ee3c51f37f131e286e665c7be80ddbbf6491689e19d8effa76fd42a - 0.0% (129 Bytes)

[#006] sha256:c630e74bfa4a131f726895c2e39e68c11ec06554124e66870a0a1a4a2e2a2923 - 0.0% (168 Bytes)

[#007] sha256:f511811d4c2423d10cb90447cd9c9f05b2dab7d0f8917056a8f3dbe88e7ac49e - 0.01% (4.68 KB)


History
2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) ADD file:3450a1687b552498a987f87cb844b7f597c7181d7c3d31943d7b3036d5300d5e in /

2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) CMD ["/bin/sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; addgroup -g 70 -S postgres; adduser -u 70 -S -D -G postgres -H -h /var/lib/postgresql -s /bin/sh postgres; mkdir -p /var/lib/postgresql; chown -R postgres:postgres /var/lib/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.utf8

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_MAJOR=11

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=11.22

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"11.22","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@11.22?os_name=alpine&os_version=3.18"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; cp -v /usr/local/share/postgresql/postgresql.conf.sample /usr/local/share/postgresql/postgresql.conf.sample.orig; sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/local/share/postgresql/postgresql.conf.sample; grep -F "listen_addresses = '*'" /usr/local/share/postgresql/postgresql.conf.sample # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /var/run/postgresql && chown -R postgres:postgres /var/run/postgresql && chmod 3777 /var/run/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 1777 "$PGDATA" # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

VOLUME [/var/lib/postgresql/data]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

COPY docker-entrypoint.sh /usr/local/bin/ # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

CMD ["postgres"]

Details
Content Digest

sha256:f0c5302ada9bd6290011912b03809291046c55aaf5f1b1bf86f03f535e065d05

Created

2023-11-30 00:11:07 UTC

Size

86.7 MB


Environment
DOCKER_PG_LLVM_DEPS

llvm15-dev clang15

LANG

en_US.utf8

PATH

/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

PGDATA

/var/lib/postgresql/data

PG_MAJOR

11

PG_SHA256

2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

PG_VERSION

11.22


Layers

[#000] sha256:2ea477e1c0c3db3337ee1d7c659f8c465021a65c036998ed3fa3b667d4b30153 - 3.54% (3.07 MB)

[#001] sha256:27bcd26549413369ead069f500749ce0ae16821f64e6d60804baa6152394462d - 0.0% (1.23 KB)

[#002] sha256:9ddd291aa374d793bb3af09e04075fc92745b6a3a33189056192481ba8494419 - 0.0% (116 Bytes)

[#003] sha256:a47b79d6abea185901959ba86c4c46ba4bf6368662f98b00d9a1fe47872a7dc8 - 96.45% (83.6 MB)

[#004] sha256:06c54976a5b012dba5cb7a25c329b2bed99e7d032ae2933d0e4b67dc29bc2cc5 - 0.01% (7.8 KB)

[#005] sha256:5a328c9db6bb3a6bfb92379bd378f03312b90fa4fe334b65d9879d6976840820 - 0.0% (129 Bytes)

[#006] sha256:773243f3e14266b9e7c76579b77a111ca19e359d431b42a8b9cc73d72a0639d5 - 0.0% (169 Bytes)

[#007] sha256:37f0aa8caaf78932943328e062378b61d5982fd95433e1783c38cc0fa18e349f - 0.01% (4.68 KB)


History
2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) ADD file:50d6643abf7df167a927decd69d193b980557ff73cca48dce86d57e2ff25ad45 in /

2023-11-30 00:11:07 UTC

/bin/sh -c #(nop) CMD ["/bin/sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; addgroup -g 70 -S postgres; adduser -u 70 -S -D -G postgres -H -h /var/lib/postgresql -s /bin/sh postgres; mkdir -p /var/lib/postgresql; chown -R postgres:postgres /var/lib/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV LANG=en_US.utf8

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_MAJOR=11

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=11.22

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"11.22","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@11.22?os_name=alpine&os_version=3.18"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c set -eux; cp -v /usr/local/share/postgresql/postgresql.conf.sample /usr/local/share/postgresql/postgresql.conf.sample.orig; sed -ri "s!^#?(listen_addresses)\s*=\s*\S+.*!\1 = '*'!" /usr/local/share/postgresql/postgresql.conf.sample; grep -F "listen_addresses = '*'" /usr/local/share/postgresql/postgresql.conf.sample # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p /var/run/postgresql && chown -R postgres:postgres /var/run/postgresql && chmod 3777 /var/run/postgresql # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENV PGDATA=/var/lib/postgresql/data

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

RUN /bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 1777 "$PGDATA" # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

VOLUME [/var/lib/postgresql/data]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

COPY docker-entrypoint.sh /usr/local/bin/ # buildkit

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

ENTRYPOINT ["docker-entrypoint.sh"]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

STOPSIGNAL SIGINT

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

EXPOSE map[5432/tcp:{}]

2023-11-30 00:11:07 UTC (buildkit.dockerfile.v0)

CMD ["postgres"]

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.