Tag

library/postgres:15-alpine3.17
Content Digest: sha256:084a37262d16e7e6f31a3f1cdb2f7cea486625f9aa096710804533fdffb939c4
Manifests
Details
Content Digest

sha256:b0b81fdf83a2661890b2f2f3acca5a1a151498280e37e918ce2eacc11e4282df

Created

2023-10-04 14:54:45 UTC

Size

96.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:ddc7d64c528fabaad61cc880e91abba829973f743d753415145211971f9ee10d - 3.38% (3.26 MB)

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

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

[#003] sha256:ae20923351913edd1fa2b910a421c7f3a21bbc1f0f36730500a9d6385315e306 - 96.61% (93.1 MB)

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

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

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

[#007] sha256:4a2f25fe02ca0578e7fb8dc309921bd77e0baf1bfdffcd7ca66992cd7044334b - 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=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.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:5f1215a588a8d87c3ad4d0273394760cb6bda41d1b176a4815d4c58c047af320

Created

2023-11-30 00:11:07 UTC

Size

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

8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

PG_VERSION

15.5


Layers

[#000] sha256:1207c741d8c9b028d98c4006013f9de959da3c55f85b91ed5e4583438a0112ca - 3.59% (3.22 MB)

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

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

[#003] sha256:c84a3875bc6a61af1bbbf327a1eb446f5240c1c06af83ea60d41f8897941c975 - 96.4% (86.6 MB)

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

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

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

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


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

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

2023-11-30 00:11:07 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=15

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

ENV PG_VERSION=15.5

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

ENV PG_SHA256=8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev 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.5","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.5?os_name=alpine&os_version=3.17"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

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

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

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

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

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

ENV PGDATA=/var/lib/postgresql/data

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

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

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

VOLUME [/var/lib/postgresql/data]

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

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

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

ENTRYPOINT ["docker-entrypoint.sh"]

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

STOPSIGNAL SIGINT

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

EXPOSE map[5432/tcp:{}]

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

CMD ["postgres"]

Details
Content Digest

sha256:f74a3c9f034c5c4d0243b3a1d005e8cde577342a5c47a3be609a931ebf39b814

Created

2023-11-30 00:11:07 UTC

Size

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

8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

PG_VERSION

15.5


Layers

[#000] sha256:f0440ff44d712e5fc701b84856116589b428157893ac461b633b1ab30b627eed - 3.39% (2.97 MB)

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

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

[#003] sha256:5d927f8107d4582d70e690838c6742e7848470f8a8fe65ac1cfcd8d92d1af22e - 96.6% (84.7 MB)

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

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

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

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


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

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

2023-11-30 00:11:07 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=15

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

ENV PG_VERSION=15.5

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

ENV PG_SHA256=8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev 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.5","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.5?os_name=alpine&os_version=3.17"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

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

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

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

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

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

ENV PGDATA=/var/lib/postgresql/data

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

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

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

VOLUME [/var/lib/postgresql/data]

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

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

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

ENTRYPOINT ["docker-entrypoint.sh"]

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

STOPSIGNAL SIGINT

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

EXPOSE map[5432/tcp:{}]

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

CMD ["postgres"]

Details
Content Digest

sha256:0dd5bf2ff2dc8589b688830590e642915ca3fb3ccf89e9a0f76dfe4c55fe344b

Created

2023-11-30 00:11:07 UTC

Size

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

15

PG_SHA256

8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

PG_VERSION

15.5


Layers

[#000] sha256:d4ee79c42f17f258e1c67dc32e0776c934799d208cd0a9b6264f65d60f1a26fc - 3.31% (2.74 MB)

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

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

[#003] sha256:127697222127fcfede08de99ecd620e631d17da5bb469a629311f4d3057b1b20 - 96.67% (79.9 MB)

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

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

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

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


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

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

2023-11-30 00:11:07 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=15

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

ENV PG_VERSION=15.5

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

ENV PG_SHA256=8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev 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.5","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.5?os_name=alpine&os_version=3.17"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

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

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

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

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

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

ENV PGDATA=/var/lib/postgresql/data

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

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

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

VOLUME [/var/lib/postgresql/data]

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

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

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

ENTRYPOINT ["docker-entrypoint.sh"]

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

STOPSIGNAL SIGINT

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

EXPOSE map[5432/tcp:{}]

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

CMD ["postgres"]

Details
Content Digest

sha256:c8ef3213786e1dfce5dde66bc0a8489c46cd75615fbf0afd3b97ff643ab375c2

Created

2023-11-30 00:11:07 UTC

Size

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

8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

PG_VERSION

15.5


Layers

[#000] sha256:b8180c93b172865af87a7c0e7e3c8bcb139e0d0c92e19c96467ff2cd4c8919ad - 3.54% (3.11 MB)

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

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

[#003] sha256:a09789b8cd033c1251b24bfd420c2cadc5a0710bf971b1169b2bbcfea7e94e59 - 96.44% (84.5 MB)

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

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

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

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


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

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

2023-11-30 00:11:07 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=15

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

ENV PG_VERSION=15.5

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

ENV PG_SHA256=8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev 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.5","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.5?os_name=alpine&os_version=3.17"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

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

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

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

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

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

ENV PGDATA=/var/lib/postgresql/data

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

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

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

VOLUME [/var/lib/postgresql/data]

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

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

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

ENTRYPOINT ["docker-entrypoint.sh"]

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

STOPSIGNAL SIGINT

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

EXPOSE map[5432/tcp:{}]

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

CMD ["postgres"]

Details
Content Digest

sha256:8e786162a03b0125cd64bba0e64a48406b026b4d33933778163d3d36b966481c

Created

2023-11-30 00:11:07 UTC

Size

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

8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

PG_VERSION

15.5


Layers

[#000] sha256:c7d387f1f267ea360529df8d70b246f949e1afdb2317cdf84b028cda80a093d1 - 3.39% (3.23 MB)

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

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

[#003] sha256:333f46643c6562a4345ba7e9b4a6ce0127f858b690cf85a28d552d043fa21766 - 96.59% (92.2 MB)

[#004] sha256:796e9d3c75787d6d27a26c81e3308e9df5c4f27e224d171e8b70e4188aaa4479 - 0.01% (9.23 KB)

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

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

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


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

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

2023-11-30 00:11:07 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=15

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

ENV PG_VERSION=15.5

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

ENV PG_SHA256=8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev 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.5","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.5?os_name=alpine&os_version=3.17"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

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

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

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

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

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

ENV PGDATA=/var/lib/postgresql/data

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

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

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

VOLUME [/var/lib/postgresql/data]

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

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

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

ENTRYPOINT ["docker-entrypoint.sh"]

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

STOPSIGNAL SIGINT

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

EXPOSE map[5432/tcp:{}]

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

CMD ["postgres"]

Details
Content Digest

sha256:624f21878e8d53051389ccbf7d8dbde853ca4181c60e65a03c8e9148c6b07a14

Created

2023-11-30 00:11:07 UTC

Size

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

8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

PG_VERSION

15.5


Layers

[#000] sha256:7e9e7e53b618240d2e82e8cab6b677eab6786c4210dcc2b1a35bfd4cb492757e - 3.35% (3.03 MB)

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

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

[#003] sha256:78ae7ad56a47727630b6b6c43bba9e6db4565e9d3a9547552b7380e3055f3c73 - 96.63% (87.3 MB)

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

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

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

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


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

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

2023-11-30 00:11:07 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=15

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

ENV PG_VERSION=15.5

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

ENV PG_SHA256=8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev 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.5","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@15.5?os_name=alpine&os_version=3.17"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

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

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

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

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

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

ENV PGDATA=/var/lib/postgresql/data

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

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

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

VOLUME [/var/lib/postgresql/data]

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

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

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

ENTRYPOINT ["docker-entrypoint.sh"]

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

STOPSIGNAL SIGINT

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

EXPOSE map[5432/tcp:{}]

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

CMD ["postgres"]

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.