Tag

library/postgres:11.21-alpine3.17
Content Digest: sha256:4f8a782304578d59f8d5e5c3d97f50513b6dc6b914dad6adb04322fdc0f67a08
Manifests
Details
Content Digest

sha256:cc863cad29e406194b3827cd411a312c00e28ebe3de52a93145ccb321e754a3c

Created

2023-10-04 14:54:45 UTC

Size

92.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

07b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850

PG_VERSION

11.21


Layers

[#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)


History
2023-08-07 19:38:30 UTC

/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"]

Details
Content Digest

sha256:97373d349cb66d5115244a954e1c648acf820f7bf3524d62d9f9138ab0cff109

Created

2023-10-04 14:54:45 UTC

Size

88 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

07b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850

PG_VERSION

11.21


Layers

[#000] sha256:9398808236ffac29e60c04ec906d8d409af7fa19dc57d8c65ad167e9c4967006 - 3.66% (3.22 MB)

[#001] sha256:6aefadc5e0b8972dd532bd34f841b301b543a0bd0a5bac24b98eb76c0097d3a5 - 0.0% (1.24 KB)

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

[#003] sha256:5acd1a20a34cd1450842c3b4a7b92b04333832e95862c8bbd136f2eefc1d8976 - 96.32% (84.8 MB)

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

[#005] sha256:1c6d8c725b7289672d168e96aba04c137e23e688d61fd7103eefce24ec68af88 - 0.0% (129 Bytes)

[#006] sha256:f428b14496cc9f521dd89ab21ba36f22d500ebe22dcc673c587c64797cfc135f - 0.0% (163 Bytes)

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


History
2023-08-07 19:20:26 UTC

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

2023-08-07 19:20:26 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"]

Details
Content Digest

sha256:ed70410b1a12c5784f400ba937c95aedf0982496941b2eb984654eabb176f15d

Created

2023-10-04 14:54:45 UTC

Size

85.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

07b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850

PG_VERSION

11.21


Layers

[#000] sha256:342323bc858ed9706f7953ab06cbf6785b678c55ef2317577af748533d11165b - 3.46% (2.97 MB)

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

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

[#003] sha256:8d6e506d5f80a470bf9b8860980090c41964fc1831eca77dc52b2fed3ee5f96c - 96.52% (82.7 MB)

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

[#005] sha256:539555b8d3af0ce8c440742dd849f88cb2be70e67927288f0abfa9e048fd3a25 - 0.0% (129 Bytes)

[#006] sha256:d5f8c9a247d4ac1d8ae3764211df6fc945ba472476527c71bbc3a6d1c0baa716 - 0.0% (163 Bytes)

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


History
2023-08-07 19:49:17 UTC

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

2023-08-07 19:49:18 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"]

Details
Content Digest

sha256:90066e09a049d7f74f4705ab21b58b5c51bf14b153afc164adc82c9825b31029

Created

2023-10-04 14:54:45 UTC

Size

80.6 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

07b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850

PG_VERSION

11.21


Layers

[#000] sha256:b82e4fd40279a40aa2eecd301fabb2dca254727cc09daa8d0caf69ac28c44af1 - 3.39% (2.74 MB)

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

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

[#003] sha256:025ae88993da1825ba94926c912ef08dbc4627efad5603caacefeeed1733ccde - 96.59% (77.9 MB)

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

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

[#006] sha256:ae9a5d9465010eb016b7a2ae2de21fe38f6cb24b5668102dbdc590ae8e238615 - 0.0% (163 Bytes)

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


History
2023-08-07 19:57:29 UTC

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

2023-08-07 19:57:29 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"]

Details
Content Digest

sha256:bd2171341ddaaaba3a5694a2c0fe04765d37d6c7289662cfc30641e891eaba3f

Created

2023-10-04 14:54:45 UTC

Size

85.8 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

07b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850

PG_VERSION

11.21


Layers

[#000] sha256:4060ece20d7ac783f52cbe28a35fd5b06f90f7b4d773bae0d956024e85ff35b6 - 3.62% (3.11 MB)

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

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

[#003] sha256:f27c946b2f5021ea5766276b3c94c291923c32e3a38f078f7427e3598913e9b0 - 96.36% (82.7 MB)

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

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

[#006] sha256:12eb91661b2d720d3846be78ca3b1e412f66892d9c78b01f83c9748bcbeba216 - 0.0% (162 Bytes)

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


History
2023-08-07 19:39:22 UTC

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

2023-08-07 19:39:22 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"]

Details
Content Digest

sha256:c1f04f77e72928c4173e0f5cda68d20d191e8e24c4b038ac5e659952c1d0310f

Created

2023-10-04 14:54:45 UTC

Size

93.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

07b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850

PG_VERSION

11.21


Layers

[#000] sha256:1e00d0a2a797866697ccca7b6307a9182e2852583b2b3be3928d196e4cb8ba3d - 3.47% (3.23 MB)

[#001] sha256:4c5b974f36ada4db166b317dbd7ec8b2b88b37937068c28d805d09538326d90c - 0.0% (1.24 KB)

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

[#003] sha256:8ee26d454c7687d239a51d3c9b4ff88e80fd489be90d63f004dc07ef72b63981 - 96.52% (90.1 MB)

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

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

[#006] sha256:c254be1db1c92f9b14e4b7c8b501b487deb7d354bd054f23b5164ea09e3b2232 - 0.0% (164 Bytes)

[#007] sha256:71e35057fafd97a410c2ef0d4d99aed99de164624bb3bf2ad24b836b7953f90b - 0.0% (4.67 KB)


History
2023-08-07 20:16:35 UTC

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

2023-08-07 20:16:36 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"]

Details
Content Digest

sha256:ffa10640f1cef76f43acedc0aa52dd55512578f206b55b4fdaa82017f80e8291

Created

2023-10-04 14:54:45 UTC

Size

88.2 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

07b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850

PG_VERSION

11.21


Layers

[#000] sha256:b69f31b9e61dae76a66eb3f9dd10f9f86d10116c6339347c47739dcf850af4d3 - 3.43% (3.03 MB)

[#001] sha256:fd127ab918326354fabf67e5ea3a64351cd5ead4351072a4975ecdad37b818ed - 0.0% (1.24 KB)

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

[#003] sha256:5a328c9f609bdd5ecd04f294470187d876dd7d2f96cac014f6d979b3e843dd13 - 96.55% (85.2 MB)

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

[#005] sha256:8d82c7d8247cffd0d3794be084cb34054063e58b717baa63ab99d8b28c2a5560 - 0.0% (129 Bytes)

[#006] sha256:1e6ee73cdaafe7dd268f29d41e10b285f87d0213637b9dfd286b9f088779e75c - 0.0% (163 Bytes)

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


History
2023-08-07 19:42:01 UTC

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

2023-08-07 19:42:02 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"]

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.