Tag
library/postgres:14.9-alpine
Content Digest: sha256:874f566dd512d79cf74f59754833e869ae76ece96716d153b0fa3e64aec88d92Manifests
Details
Content Digestsha256:03f565ad90682dcbb4cdec263e54d37f663494d6e616b7baf806111ef3b1fe8c
2023-10-04 14:54:45 UTC
93.6 MB
Environment
DOCKER_PG_LLVM_DEPSllvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR14
PG_SHA256b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
PG_VERSION14.9
Layers
[#000] sha256:dc95107ad2a031a015320bb397f73ec151d738127175b31ad643120697dc7e90 - 3.3% (3.09 MB)
[#001] sha256:d3d5018b17e005c513f6881d991bf92ec3fe967b37f462d7bac655d1af2b3835 - 0.0% (1.24 KB)
[#002] sha256:4bdffa4be94eb880fa910907cc67ca1f9960a22179f85ac2df4dbd9f1fc93b34 - 0.0% (116 Bytes)
[#003] sha256:45b0d2a90bf3218a92117eba74a6a267940db19c9a30ee6388d9fc3da4f72d03 - 96.69% (90.5 MB)
[#004] sha256:af22832ecf700f4cc4f30f58563433ec2b953bcd983d401cd3877bb4bce72759 - 0.01% (8.98 KB)
[#005] sha256:343d7c7db22c9e83080658783d33c59df774677d1c77a2b1f6d7683b08f6fdab - 0.0% (127 Bytes)
[#006] sha256:410a7efc8a62b488b5d443fc2a4c1c2bdbbd3f234b37dd0c46b3be4232b4c10b - 0.0% (169 Bytes)
[#007] sha256:01127b313975f49ee1b207b6ee2ac1815bf67c31f424670497b28c4233190904 - 0.0% (4.67 KB)
History
/bin/sh -c #(nop) ADD file:8402753f294e403e92353bd65c86a6428c960be5116c0a15484b663a84f66fcd in /
2023-09-28 20:38:20 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=14
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=14.9
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_SHA256=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
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 lz4-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 --with-lz4 ; 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":"14.9","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@14.9?os_name=alpine&os_version=3.18"}],"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 Digestsha256:ed089947c1bdc9da0227e586c66a7338ef397e2af36d650a8027a5cc0de60935
2023-10-04 14:54:45 UTC
88.8 MB
Environment
DOCKER_PG_LLVM_DEPSllvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR14
PG_SHA256b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
PG_VERSION14.9
Layers
[#000] sha256:96526aa774ef0126ad0fe9e9a95764c5fc37f409ab9e97021e7b4775d82bf6fa - 3.65% (3.24 MB)
[#001] sha256:cae7778f1ca2397c8fd392dab70a64b9aba211e29fc5d659230b6e746d3b531c - 0.0% (1.24 KB)
[#002] sha256:a068e763669a8f750c7e4e490bc08e5cfcafee3ceeec1268c441caed8de1e3ad - 0.0% (116 Bytes)
[#003] sha256:0787333105a22d0651ace2295b9bca0f2d91eca5611b020bec5c1c39ab2a8e5e - 96.33% (85.5 MB)
[#004] sha256:e1c22c2c0cb87c0fa9faa25a636a84d8b1ffeb59614481c102e35ece04cdc7f3 - 0.01% (8.98 KB)
[#005] sha256:5eaf5c39276d80466d152a5a19700c29f2ffc189fa815ccb4fc10fd6fafd9da0 - 0.0% (129 Bytes)
[#006] sha256:03ec842f1e62619a2c393f9c235ae6a93aa6bf18266faf5e4ed061e4d5840004 - 0.0% (169 Bytes)
[#007] sha256:1c5e4ba7601702525bbb4494f9a47b04537acb6a8cb879330b351070e3e61595 - 0.01% (4.67 KB)
History
/bin/sh -c #(nop) ADD file:756183bba9c7f4593c2b216e98e4208b9163c4c962ea0837ef88bd917609d001 in /
2023-09-28 21:19:27 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=14
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=14.9
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_SHA256=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
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 lz4-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 --with-lz4 ; 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":"14.9","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@14.9?os_name=alpine&os_version=3.18"}],"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 Digestsha256:28d4ec7a6459599889e0ef5ce5ad305397cbfa525c1e0a05ea43cbe06109752b
2023-10-04 14:54:45 UTC
87.2 MB
Environment
DOCKER_PG_LLVM_DEPSllvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR14
PG_SHA256b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
PG_VERSION14.9
Layers
[#000] sha256:91cb83b91ee16f1ee0d588fccef56ab5dbb5689a64e5373caf33d7e4fe52ceb4 - 3.44% (3 MB)
[#001] sha256:99f9677461cc1446c142c4f11c5e5ba7ae5eb0160b5884c6c4703d8bbc271706 - 0.0% (1.23 KB)
[#002] sha256:0da301824fff35c4518ffe54b8851eeba7f52fe7519c55c3daee52a26301b52c - 0.0% (116 Bytes)
[#003] sha256:684726f79521de229737aa0ced902f1e12949f5ea72da39c33cee9bd0d4632fe - 96.54% (84.2 MB)
[#004] sha256:428590f17859b1795fbbdd750f723646affd2b007b8b42243b6ce512d2839fe6 - 0.01% (8.98 KB)
[#005] sha256:13aeba42324914ba41fe61c29e27abde07735dd8c7f051d2e9653377968cb324 - 0.0% (128 Bytes)
[#006] sha256:13f7f0def2d4d5c95ee0c5dc0b051c910383575f782060d554769dc09738bdb1 - 0.0% (169 Bytes)
[#007] sha256:e7b934ac1b35257bf14868d46b37b35b52166a2d1702a644cdb04fd99f5358c3 - 0.01% (4.67 KB)
History
/bin/sh -c #(nop) ADD file:2222b03381ff0fce22edd647f5c60529ec6a72202f8d3cb1d6e4648ebcd19a1e in /
2023-09-28 20:49:16 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=14
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=14.9
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_SHA256=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
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 lz4-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 --with-lz4 ; 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":"14.9","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@14.9?os_name=alpine&os_version=3.18"}],"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 Digestsha256:961821342dfb29fa16d7d122d32f8a58ddf187719fdea98b48528fedc1ebd1d6
2023-10-04 14:54:45 UTC
82.1 MB
Environment
DOCKER_PG_LLVM_DEPSllvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR14
PG_SHA256b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
PG_VERSION14.9
Layers
[#000] sha256:622a0779436eb93ceea635e910268f867c2eba47d4f62f0bd45f0bd165af3572 - 3.37% (2.77 MB)
[#001] sha256:3de34561774cc0a52beeb06fef6a1f6af2bd2a08d4ea304d8d6da8fca56b666f - 0.0% (1.23 KB)
[#002] sha256:9f40d1b3c22c63e3341b41845b4002cf47594b6e022558becb3c12725dbea465 - 0.0% (116 Bytes)
[#003] sha256:e8598d2d053a0be6d6117aa9d4c535e1c0b43e86632c31f35b8c53af89720141 - 96.61% (79.3 MB)
[#004] sha256:efda34300b741cb60d197126ed89ba63e05e3ca8d3ed43ea60809d7f427ceae2 - 0.01% (8.98 KB)
[#005] sha256:d3a670b00297332c4f2399263e5b8458a95a0762ced53a3934317db5cd994bc6 - 0.0% (128 Bytes)
[#006] sha256:708c5ca39d9ca7207508bb6441cf27eede797e3494bdcf70d2dca3b606a252ce - 0.0% (169 Bytes)
[#007] sha256:37d60054cc68f0d3729626ac2d24da8e8c72882cae487c2a2697773a5afc81e8 - 0.01% (4.67 KB)
History
/bin/sh -c #(nop) ADD file:61f54a318ad79861c6177783bb4c604412b5d952f45a9aa12ff97f4dccba7f73 in /
2023-09-28 20:59:24 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=14
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=14.9
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_SHA256=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
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 lz4-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 --with-lz4 ; 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":"14.9","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@14.9?os_name=alpine&os_version=3.18"}],"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 Digestsha256:b0dba3a9bfeb644a4a43fb3795fcdc4be19a4f05e6a2d5cd05ce5b120ceaa7d0
2023-10-04 14:54:45 UTC
87.4 MB
Environment
DOCKER_PG_LLVM_DEPSllvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR14
PG_SHA256b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
PG_VERSION14.9
Layers
[#000] sha256:579b34f0a95bb83b3acd6b3249ddc52c3d80f5c84b13c944e9e324feb86dd329 - 3.63% (3.18 MB)
[#001] sha256:57128d869f4112bd058a44bc2fd19d9b05ea0895b34ad51c07e45ddadd30d480 - 0.0% (1.23 KB)
[#002] sha256:a1755e5b66878a2e0b911de75610a642179f0862fd67d7ac96105919310c7ee6 - 0.0% (116 Bytes)
[#003] sha256:11f256b78518475cf14942bd0509653998dd940ae00a749444820ab0a25423c8 - 96.35% (84.2 MB)
[#004] sha256:f6a6b74d17861d6db951a3290bfa232ab241126f6a187fca3bdeb25ed9440456 - 0.01% (8.98 KB)
[#005] sha256:f963cea3efffa5ebcc08e6baf3c5768fff3437a87888d0b0adf345b2540e946e - 0.0% (128 Bytes)
[#006] sha256:5678465de0feac9f7eb6f93c12ee4fbb8a3f8a6d9a9ce67381b7a7c63284dd5c - 0.0% (167 Bytes)
[#007] sha256:f25d985bc5d7dbee048da208b9597a62ec5bf2b9a15975f57e971d849326dd27 - 0.01% (4.67 KB)
History
/bin/sh -c #(nop) ADD file:ff3112828967e8004a3264d7ece3f81c88e6a1d44d360b9b5613caab15b41717 in /
2023-09-28 20:39:34 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=14
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=14.9
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_SHA256=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
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 lz4-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 --with-lz4 ; 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":"14.9","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@14.9?os_name=alpine&os_version=3.18"}],"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 Digestsha256:fa6563319592cabd4d283d4abc77c40b3e25cffe465f6560b1419232353e23ca
2023-10-04 14:54:45 UTC
93.8 MB
Environment
DOCKER_PG_LLVM_DEPSllvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR14
PG_SHA256b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
PG_VERSION14.9
Layers
[#000] sha256:cd37f9856024d6685ac0233823aded690551c5872d6a27699a96c6a479d20f6f - 3.4% (3.19 MB)
[#001] sha256:fb0eda61a2703e25325ea1e358d3a74fe87529df79e6beb419567f1bdbbb63df - 0.0% (1.23 KB)
[#002] sha256:e9b29b4ecd4028475762890da3e105d2ad2bb7690a0bff52c89c3d7180aca779 - 0.0% (116 Bytes)
[#003] sha256:a885294727628e0c4e40e209973c5ac9a61a1d3c9d9bf0b50c52494401713312 - 96.58% (90.6 MB)
[#004] sha256:a4562bafc8d786c3fe12de624de97e2632eb60e2b9ad544b452e2fe6304f8bf2 - 0.01% (8.99 KB)
[#005] sha256:3a382f6430ef08b5ef359111f6e27835d5f5b27c33c1e480394e9d2fd66c4bd4 - 0.0% (129 Bytes)
[#006] sha256:b528583dda2ac7f4acc0706e124d1a7cb7bf23ed3afdfe7e18d2f2cb786cc211 - 0.0% (170 Bytes)
[#007] sha256:0d7b496e336d8a61a646a025e695f05ca6a63bca6f604ff24921299e89ce4690 - 0.0% (4.68 KB)
History
/bin/sh -c #(nop) ADD file:a720acb99214334c501363d564d8cae9b90d062ccf8a24a5ba1c831545b783dd in /
2023-09-28 21:22:21 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=14
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=14.9
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_SHA256=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
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 lz4-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 --with-lz4 ; 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":"14.9","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@14.9?os_name=alpine&os_version=3.18"}],"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 Digestsha256:7680a91b62ad46cf63d4d27ebb2a6daf25fd2b4b5685ed2516b7f8923c36f240
2023-10-04 14:54:45 UTC
90.4 MB
Environment
DOCKER_PG_LLVM_DEPSllvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR14
PG_SHA256b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
PG_VERSION14.9
Layers
[#000] sha256:47539bffe0f44273ec7731d86be2a6171359b3847c9b60c6ac74c4875c3264af - 3.39% (3.07 MB)
[#001] sha256:e7ae232bced3defb4eae7f5affb566ea50f50655d575488965e418a8da86b3ed - 0.0% (1.23 KB)
[#002] sha256:e68a6f64e487e2750fccb626c86600fd10e0346eabb9bdb31da4b7824cac4a0b - 0.0% (116 Bytes)
[#003] sha256:896a181240e9e41637b812ff092e92209f975e04504b31be3de1af86293ec502 - 96.59% (87.3 MB)
[#004] sha256:8e0bed7401c178f9a011b05f83af704554dbda89eec3b350bfccee8874a4ed34 - 0.01% (8.99 KB)
[#005] sha256:9150b7c422e81392765ff350a26cd691829a7c3ec77eee57d0d581c387f293f0 - 0.0% (128 Bytes)
[#006] sha256:5b0b45282741b78fba37232951e291c68e877bcc131c87f930c8f6d0b743550e - 0.0% (169 Bytes)
[#007] sha256:69946a0f50153a59a61e606d628556717323b25495fad75dd6ec9ca0a47c3997 - 0.01% (4.67 KB)
History
/bin/sh -c #(nop) ADD file:fd3808a676fc56c1380e55b2ddbf4014d9371346cf789860b336bc9f00729ed0 in /
2023-09-28 20:41:44 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=14
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=14.9
2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)ENV PG_SHA256=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
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 lz4-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 --with-lz4 ; 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":"14.9","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@14.9?os_name=alpine&os_version=3.18"}],"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"]
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.