Tag

library/postgres:15.4-alpine
Content Digest: sha256:35ce2187f2f7fb75e8e79493e13743596c21eb3789ff41ece145ae04d06e93a5
Manifests
Details
Content Digest

sha256:5a01f2c7b920e1d3898920f1b5986102f6b638cb6767ea4ed1b820a880968648

Created

2023-10-04 14:54:45 UTC

Size

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

15

PG_SHA256

baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

PG_VERSION

15.4


Layers

[#000] sha256:dc95107ad2a031a015320bb397f73ec151d738127175b31ad643120697dc7e90 - 3.27% (3.09 MB)

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

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

[#003] sha256:83e751fcc3c2977a688c87b7141b558985817110d8930c011bf1aaab08f91046 - 96.71% (91.1 MB)

[#004] sha256:a1609558a9d9197e9b278205e3985f914130f2889b4cd626daf06f41e96711db - 0.01% (9.22 KB)

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

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

[#007] sha256:172c7914ebcb5c6080fda0eff048571d37e5e8d1a55c6f55c4930d3ad61c90b7 - 0.0% (4.67 KB)


History
2023-09-28 20:38:19 UTC

/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=15

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=15.4

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

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 zstd-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 --with-zstd ; 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":"15.4","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.4?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 Digest

sha256:d43df62c9cb97b57fd18cdd1714c73bfb6ce043e7147bc1a89df4bf6f6fac694

Created

2023-10-04 14:54:45 UTC

Size

89.4 MB


Environment
DOCKER_PG_LLVM_DEPS

llvm15-dev clang15

LANG

en_US.utf8

PATH

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

PGDATA

/var/lib/postgresql/data

PG_MAJOR

15

PG_SHA256

baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

PG_VERSION

15.4


Layers

[#000] sha256:96526aa774ef0126ad0fe9e9a95764c5fc37f409ab9e97021e7b4775d82bf6fa - 3.63% (3.24 MB)

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

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

[#003] sha256:9737661d941c51683ee3735a7c54b728d14a36a45d358856a3568bd92a49a76f - 96.36% (86.2 MB)

[#004] sha256:eb9232875c660bc508837534e5d7402d766e0f04237a97428cb258e2f12dead1 - 0.01% (9.22 KB)

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

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

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


History
2023-09-28 21:19:27 UTC

/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=15

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=15.4

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

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 zstd-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 --with-zstd ; 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":"15.4","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.4?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 Digest

sha256:304f8a73dbd64bbcf082ae8b478b2d3a521a3fd2f0562a533aaef442eb3e32f9

Created

2023-10-04 14:54:45 UTC

Size

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

15

PG_SHA256

baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

PG_VERSION

15.4


Layers

[#000] sha256:91cb83b91ee16f1ee0d588fccef56ab5dbb5689a64e5373caf33d7e4fe52ceb4 - 3.42% (3 MB)

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

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

[#003] sha256:88a4ee36bfe5829efd2bc5df79369840744e7c66f35ac46f3a4e9682ca3aabc9 - 96.57% (84.8 MB)

[#004] sha256:690ba003e2a326253f115f32d6065bc1c55b97b83249b9c89c75c1392c5b299c - 0.01% (9.22 KB)

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

[#006] sha256:61354faa5727df38aeabdcdabf6be30d1b31940e11c7a05a360b245f79e6a7f3 - 0.0% (169 Bytes)

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


History
2023-09-28 20:49:16 UTC

/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=15

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=15.4

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

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 zstd-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 --with-zstd ; 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":"15.4","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.4?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 Digest

sha256:1e48b2217080fa916fb4199b6fae837a7f863373e22cdc55e6404d4007bd2885

Created

2023-10-04 14:54:45 UTC

Size

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

15

PG_SHA256

baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

PG_VERSION

15.4


Layers

[#000] sha256:622a0779436eb93ceea635e910268f867c2eba47d4f62f0bd45f0bd165af3572 - 3.34% (2.77 MB)

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

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

[#003] sha256:673c5bc632d8a7fc501bfa89092e9db34e5a4a778aafa223e481dd0c7fb3b1de - 96.64% (79.9 MB)

[#004] sha256:460abd356295e3581c25410dfaed1836fe1cc5cb4ee7fea625f92a5d91d3a41f - 0.01% (9.22 KB)

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

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

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


History
2023-09-28 20:59:24 UTC

/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=15

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=15.4

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

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 zstd-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 --with-zstd ; 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":"15.4","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.4?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 Digest

sha256:b3bcb0ef48d7fc471e5d7f17356fc70c314229889bfbdbe31ca056a31ec5485f

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

15

PG_SHA256

baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

PG_VERSION

15.4


Layers

[#000] sha256:579b34f0a95bb83b3acd6b3249ddc52c3d80f5c84b13c944e9e324feb86dd329 - 3.61% (3.18 MB)

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

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

[#003] sha256:1d50d476db1ad60f78a19ce33dc1c448b069963f1a7af5066e7eadfa6cc40371 - 96.37% (84.9 MB)

[#004] sha256:3dcbde0c4b59619854b0d99de55fdbd48e149464f9a46bc0ed8db709d10cd5f4 - 0.01% (9.23 KB)

[#005] sha256:8287c0658f7a2d4d6cbfc5e34c69d2bbea44906a0c3d9a8a16d69158fb6d55ff - 0.0% (127 Bytes)

[#006] sha256:7292e9358e1f7de83a69b006adc9d78daa300b616ca892130586df12e41e1dfa - 0.0% (169 Bytes)

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


History
2023-09-28 20:39:33 UTC

/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=15

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=15.4

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

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 zstd-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 --with-zstd ; 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":"15.4","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.4?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 Digest

sha256:f413f856ac8a9c28d3f871a3e7155d8aa5e20810ce404b4812324d0b3e0bfdea

Created

2023-10-04 14:54:45 UTC

Size

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

15

PG_SHA256

baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

PG_VERSION

15.4


Layers

[#000] sha256:cd37f9856024d6685ac0233823aded690551c5872d6a27699a96c6a479d20f6f - 3.38% (3.19 MB)

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

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

[#003] sha256:e1e550b4ac768307eac17a068367268e38026697bbe877a60245f8ebd223de36 - 96.61% (91.3 MB)

[#004] sha256:594ce1505d090394b60c44191a007cc125fca669a088939e12f04a8035005ea7 - 0.01% (9.23 KB)

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

[#006] sha256:160b927f29a15aa0834cd2c245a01bbf51db4e73deca814c480c773cb44711bf - 0.0% (172 Bytes)

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


History
2023-09-28 21:22:20 UTC

/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=15

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=15.4

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

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 zstd-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 --with-zstd ; 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":"15.4","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.4?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 Digest

sha256:1bd82a612b1b701617e2659a40d591dac9621be50c7c74e2bb3d4602ca6faaf6

Created

2023-10-04 14:54:45 UTC

Size

91 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

15

PG_SHA256

baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

PG_VERSION

15.4


Layers

[#000] sha256:47539bffe0f44273ec7731d86be2a6171359b3847c9b60c6ac74c4875c3264af - 3.37% (3.07 MB)

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

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

[#003] sha256:bf759e56648aad1118c6a757e7df4d8887b9e959699324db8b7d999a4261ab07 - 96.62% (87.9 MB)

[#004] sha256:645e81a4d620b6f2287601e6c1aedf86d3f138d567594e278bfa7a93557ca2cb - 0.01% (9.23 KB)

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

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

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


History
2023-09-28 20:41:43 UTC

/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=15

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_VERSION=15.4

2023-10-04 14:54:45 UTC (buildkit.dockerfile.v0)

ENV PG_SHA256=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9

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 zstd-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 --with-zstd ; 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":"15.4","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.4?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"]

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.