sha256:cc863cad29e406194b3827cd411a312c00e28ebe3de52a93145ccb321e754a3c
2023-10-04 14:54:45 UTC
92.5 MB
llvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR11
PG_SHA25607b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850
PG_VERSION11.21
[#000] sha256:ddc7d64c528fabaad61cc880e91abba829973f743d753415145211971f9ee10d - 3.52% (3.26 MB)
[#001] sha256:6192212658b761b7aca241a17fcb826fb268ccf46c8cf6ae152f1f5613e6ecbd - 0.0% (1.23 KB)
[#002] sha256:79ed44aa59686a2bd4d65cf0023ad54a5f191f0688b19043b1682cebbfb64e5e - 0.0% (116 Bytes)
[#003] sha256:d50f9ab35945a88ad76fc20d88edb1b6a4ccd23c336f33e3d6625646206e68d3 - 96.46% (89.2 MB)
[#004] sha256:a4a7178a79ae461fefc0525b328266e9dcdff425ecf27f157669d20df3a334f6 - 0.01% (7.79 KB)
[#005] sha256:89c9b26e6c7b5605ae135b9a5674f1cda2f610d1c53edd1a5e9f75fb9a9d039c - 0.0% (129 Bytes)
[#006] sha256:35fccaf5e1ea6e70928d3e77612cde29b4a3ba800ff08c9aa56a8988c9059b44 - 0.0% (163 Bytes)
[#007] sha256:7f09d739db4848d1419567e5352c57328e1d7dd1548bc926625109a336ee8392 - 0.0% (4.67 KB)
/bin/sh -c #(nop) ADD file:437e2411fa3e4795a759f54507f41caa000169f0c32600ec49b4397313cd0884 in /
2023-08-07 19:38:30 UTC/bin/sh -c #(nop) CMD ["/bin/sh"]
2023-10-04 14:54:45 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-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.utf8
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_MAJOR=11
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=11.21
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_SHA256=07b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15
2023-10-04 14:54:45 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.21","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@11.21?os_name=alpine&os_version=3.17"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit
2023-10-04 14:54:45 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-10-04 14:54:45 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-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 1777 "$PGDATA" # buildkit
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)VOLUME [/var/lib/postgresql/data]
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)COPY docker-entrypoint.sh /usr/local/bin/ # buildkit
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)CMD ["postgres"]
sha256:26ffe801e8885cb7312588de510e8610ae03f9cda99da112fff80325b3212ce5
2023-11-30 00:11:07 UTC
86.1 MB
llvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR11
PG_SHA2562cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0
PG_VERSION11.22
[#000] sha256:1207c741d8c9b028d98c4006013f9de959da3c55f85b91ed5e4583438a0112ca - 3.74% (3.22 MB)
[#001] sha256:d04e0d248ea7eb529e7a1a3e36c4dd213fc9fbb6c4e64b73334aa035d03dc8ac - 0.0% (1.23 KB)
[#002] sha256:2a021dc7ba867e197e499a6651713f1801824f976f393e226317f08076a62a97 - 0.0% (116 Bytes)
[#003] sha256:42d296c398458f4d29f240424d34f1399150120559bd7dd4608e340fd242fd67 - 96.24% (82.9 MB)
[#004] sha256:f902eca95841537a7e399ccc1774f84fb5bf8ff94ae02a34166324f155c85e33 - 0.01% (7.79 KB)
[#005] sha256:8806243a314b125a4f49006f079a8e74075563381588f7d35fd0e2b819df4b7a - 0.0% (128 Bytes)
[#006] sha256:eac7f3f5c8ee2de011237190708a09b515ea9758cf789199a47b7ea177ed3bc2 - 0.0% (163 Bytes)
[#007] sha256:caddf3c0d313dfebd8f705e95d51f571fd6eb0db38f91fc9f4c7a454b998d3cc - 0.01% (4.67 KB)
/bin/sh -c #(nop) ADD file:80331a5d882ac8a70763f4b19e06f2e04ea3dca34ae6d92810815b170b3c806c 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.17"}],"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"]
sha256:079c3562024a7c8bc9c6356f530747f14d3873ad6b51ccb03673567dccebfc9c
2023-11-30 00:11:07 UTC
84.1 MB
llvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR11
PG_SHA2562cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0
PG_VERSION11.22
[#000] sha256:f0440ff44d712e5fc701b84856116589b428157893ac461b633b1ab30b627eed - 3.53% (2.97 MB)
[#001] sha256:d6cf4f8e676ee69efccd3326170b642d4821da96caa3d84ab15fed2d10e82d03 - 0.0% (1.23 KB)
[#002] sha256:206833baca681b868d0cc0287361c32c09607f21a4c46269b488cac9ad8077b5 - 0.0% (116 Bytes)
[#003] sha256:409c9b2e2782f32a38a3dd51a9b16bf87d81711fe54605b80ba71d101c39838c - 96.45% (81.1 MB)
[#004] sha256:50ec019bcd0e2ced1960dd3e4e90a82e9c121312f3a7b0b0a49a1353ff5aa5bb - 0.01% (7.79 KB)
[#005] sha256:dcab90e097bf695a92d6018e17015fbefd5534fc9ad1e4f5b10ea69c93bafb06 - 0.0% (128 Bytes)
[#006] sha256:78f8a59bc871e7145d52b3d8b02a39e6aa981d5871bda813f3095b80d55d0b68 - 0.0% (163 Bytes)
[#007] sha256:275bf0f4c3941b49522029a6195dba0ca4d36c79b2d9c6d9f432ee72bd3b3249 - 0.01% (4.67 KB)
/bin/sh -c #(nop) ADD file:90d3bdc6a557ead63796de0110e2fda87e65aa091070cbae612dfb2126568253 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.17"}],"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"]
sha256:b649a45478bc3a2a2077e2ac3069849d77178da8c7409d3547588aa64099b0d1
2023-11-30 00:11:07 UTC
79.1 MB
llvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR11
PG_SHA2562cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0
PG_VERSION11.22
[#000] sha256:d4ee79c42f17f258e1c67dc32e0776c934799d208cd0a9b6264f65d60f1a26fc - 3.46% (2.74 MB)
[#001] sha256:daac7579ae28a407bb0d0a9db156253f5a411f5a6247ae429a4016d6c83c8b7b - 0.0% (1.23 KB)
[#002] sha256:1da7d87480054885d297e6e92334e8ce5ae4651ef7205b73ec344642632e87cd - 0.0% (116 Bytes)
[#003] sha256:741dd4c0b90780824d403176e42cd9e9653e4d0ac855a4aee36c9838032cdd5b - 96.52% (76.3 MB)
[#004] sha256:4d251d1f033109b3aa101cc164325e8e955a0d5da8427607738f6757174ea41d - 0.01% (7.79 KB)
[#005] sha256:b97d0670c5113381088c73297eb7eef5622128f9ae000a12b79750cc810473d0 - 0.0% (128 Bytes)
[#006] sha256:be76c1d2f4f54bcfeff161aebaf39eaf3b072177b4c017216edcd6a60468b41a - 0.0% (163 Bytes)
[#007] sha256:86b7fe858063b51d1a22306da9d7be68318fa573cedc90585baa8d29c3b64220 - 0.01% (4.67 KB)
/bin/sh -c #(nop) ADD file:02a6ccbee2a71a547141a8480f3a3912c7bb0934df31124f4a4720204d326698 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.17"}],"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"]
sha256:a399f416f1e95d699ace3542a051453aca63c2cc004ab55f4b7445a1ac47dd42
2023-11-30 00:11:07 UTC
84 MB
llvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR11
PG_SHA2562cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0
PG_VERSION11.22
[#000] sha256:b8180c93b172865af87a7c0e7e3c8bcb139e0d0c92e19c96467ff2cd4c8919ad - 3.7% (3.11 MB)
[#001] sha256:892bc68cc76cc391a887c761eb4892aef44e4199974b3cccf658f41ad2c41d74 - 0.0% (1.23 KB)
[#002] sha256:b7b809b35e3ecb592d0cef272df76134a11a4eed8dbde6629cd97bf414099e77 - 0.0% (116 Bytes)
[#003] sha256:efe17d40c2f5262aa782a378d7de4af904e64de13f1c5c56e86d082827774985 - 96.29% (80.9 MB)
[#004] sha256:ac4ecd957a53da416a1ca642299ba12f4175869a701432f429078adb51a2d161 - 0.01% (7.8 KB)
[#005] sha256:2ed39367226dfdbfada858227b424c86c310c8470e9ef5369f40824ca70b799c - 0.0% (129 Bytes)
[#006] sha256:ce8e546305ac81397927dafbeae03c4239e9e0b8b2da9a430c13f14b475a0808 - 0.0% (163 Bytes)
[#007] sha256:84ec1e36b70cb3ee8a7831b7af8e3544cef7eb9740be19fad3c21ee99739c076 - 0.01% (4.67 KB)
/bin/sh -c #(nop) ADD file:e5c66967d6570e36da50c9d42dd8f8f55e6c6a65b92c79601ea9e750c076fa2a 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.17"}],"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"]
sha256:ba544c92d01d25bdba836755bc857e06ccea1f67ae814faf9052485f7a4417dc
2023-11-30 00:11:07 UTC
91.5 MB
llvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR11
PG_SHA2562cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0
PG_VERSION11.22
[#000] sha256:c7d387f1f267ea360529df8d70b246f949e1afdb2317cdf84b028cda80a093d1 - 3.54% (3.23 MB)
[#001] sha256:5eefd687ec695dbf5ad2ea3426f89c171644eeb6b8a2f5ca1f82d86789dd7e67 - 0.0% (1.23 KB)
[#002] sha256:310619b08e66325eab5686b9b75b3fa3bbfbf31403f2be9f5b491fb5189cc7ef - 0.0% (116 Bytes)
[#003] sha256:260bc043700f6838baf6ea53b195bcf04f58ff8d020a8673ce44ac1ce2818ca6 - 96.45% (88.2 MB)
[#004] sha256:44f45998c4f0bd91b4f70aa4a8159e96bc27d62d7eaa4fb1072ce9d29dccb8a1 - 0.01% (7.8 KB)
[#005] sha256:f2388537b4e8fd0ebe0322dc8b4425e1711d0c8c5d415bcd0c8e2bc881fe3b42 - 0.0% (128 Bytes)
[#006] sha256:b4df0a888fa72d6343c4498c86249fcd87ae78f5c7e96e7be707593715c3ca18 - 0.0% (163 Bytes)
[#007] sha256:9e8486ddbe7a71bcc7a8dff067746d28517cda7eb329eaa7efbb71ba137c095b - 0.0% (4.68 KB)
/bin/sh -c #(nop) ADD file:e3eb0ea4f652282ad08228d0d146f33998b9e93641756d780ac0205aa828c070 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.17"}],"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"]
sha256:47c12d079894ef32e7099e1dde448aaf9bbed1ecf2b46e9007a66ce0b84a948b
2023-11-30 00:11:07 UTC
86.5 MB
llvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR11
PG_SHA2562cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0
PG_VERSION11.22
[#000] sha256:7e9e7e53b618240d2e82e8cab6b677eab6786c4210dcc2b1a35bfd4cb492757e - 3.5% (3.03 MB)
[#001] sha256:b3104d6f3f1d533a0d4fb71b4dc15da4cf1ef964a88da6bd5ad2d31b5e916d67 - 0.0% (1.23 KB)
[#002] sha256:492a581271ed07263f2c3709798fdf8d8a07f0e2354d9388a2a9bed66520b756 - 0.0% (116 Bytes)
[#003] sha256:5b7c291ea85de93834cc82f79aaae422bab6193d9ba224969fc0076d227d6a0f - 96.48% (83.5 MB)
[#004] sha256:70ecb97448e7f5d61f95b35dcac97c398d5835ba56087044be3024fb992e0627 - 0.01% (7.8 KB)
[#005] sha256:9ff41eb6c1b6036def1f2ff5edb35163fe67d9bca6b64f4168b8db3c4f9abf3b - 0.0% (129 Bytes)
[#006] sha256:60214cd8d253a945a02259bddea5b362f19e81909085b739947dfcdaaf276624 - 0.0% (164 Bytes)
[#007] sha256:1bf516b3b9d55b76119f9860b6170d8e174586c08102c6a65f500b88a1709745 - 0.01% (4.68 KB)
/bin/sh -c #(nop) ADD file:bf416048d22b9a0deecb508385355d79b8d5d12b655c600dbdc0948f7dcbb2c2 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.17"}],"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"]
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.