Tag

library/postgres:16.0-alpine3.17
Content Digest: sha256:0678a5f3ad60ef755bb3ef37a9fc196f32c04fd0cac3c00e808641c5cfac2bee
Manifests
Details
Content Digest

sha256:e1f78b03c20061eb700ce9e71bfc52fdee78e91079aeaa12586c7f6d9c5444d4

Created

2023-10-04 14:54:45 UTC

Size

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

16

PG_SHA256

df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

PG_VERSION

16.0


Layers

[#000] sha256:ddc7d64c528fabaad61cc880e91abba829973f743d753415145211971f9ee10d - 3.35% (3.26 MB)

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

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

[#003] sha256:255903dc541ba4c0493df922fdf10204d07842eca3b4ebcd139ccdc12b275df5 - 96.64% (93.9 MB)

[#004] sha256:631bde8104172e2a77f5cdce82557eb5ece78ac602d96f1e63b9c700d2a02938 - 0.01% (9.34 KB)

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

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

[#007] sha256:374d00d6e1f28b72314c7c9e0d10e301eb5bbc477dd1426373db1098f0ee331e - 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=16

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

ENV PG_VERSION=16.0

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

ENV PG_SHA256=df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

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

Created

2023-10-04 14:54:45 UTC

Size

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

16

PG_SHA256

df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

PG_VERSION

16.0


Layers

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

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

[#002] sha256:7b3646067faa53422f28a84d91034779d879fb78ba312755f36b6036900d0100 - 0.0% (114 Bytes)

[#003] sha256:42a56d97b494ff2461e145b0ed2e85986b1b717c36b5911bdfbac272c42023cd - 96.5% (89.3 MB)

[#004] sha256:aee64896bb4b039fb879244b64c7f1d1d2565f105106eb84554cc34d391c454c - 0.01% (9.34 KB)

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

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

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


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

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

2023-08-07 19:20:26 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=16

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

ENV PG_VERSION=16.0

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

ENV PG_SHA256=df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

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

Created

2023-10-04 14:54:45 UTC

Size

90.1 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

16

PG_SHA256

df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

PG_VERSION

16.0


Layers

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

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

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

[#003] sha256:a54ff475db2fa31479ae6eda78414516d40dc7aa69753a455b8649d57997150f - 96.69% (87.1 MB)

[#004] sha256:99ed46d0f3dc1d13071e72227e77f607445e7c9eadcd16702dff4b16b7634ac5 - 0.01% (9.34 KB)

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

[#006] sha256:573827ccb5c52328d0e3ef1f2d11e8f6b4e37b2ebbe0f2e1c0e714d8a732581f - 0.0% (162 Bytes)

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


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

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

2023-08-07 19:49:18 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=16

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

ENV PG_VERSION=16.0

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

ENV PG_SHA256=df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

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-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":"16.0","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@16.0?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:9408d2658aa336e47cd4af3a161ffa9687fc599243fa930c2e51ea865b3888fb

Created

2023-10-04 14:54:45 UTC

Size

84.9 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

16

PG_SHA256

df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

PG_VERSION

16.0


Layers

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

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

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

[#003] sha256:4caa1c4777cb96f5cd36ea4a1cb89091015676a9bd8f43d4f22239bbbd906396 - 96.76% (82.1 MB)

[#004] sha256:0b546cb4182650ad73a7ddd2538f2150418d26bea9b2f6e689021ba69a080d8f - 0.01% (9.33 KB)

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

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

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


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

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

2023-08-07 19:57:29 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=16

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

ENV PG_VERSION=16.0

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

ENV PG_SHA256=df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

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

Created

2023-10-04 14:54:45 UTC

Size

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

16

PG_SHA256

df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

PG_VERSION

16.0


Layers

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

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

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

[#003] sha256:0aed40ee92f7a8660fa7aed3032d467d35df57cd128b86982189d2dc9054973a - 96.54% (87.1 MB)

[#004] sha256:8714615958e4c1465af83ef72b4e9cf7fa146511867138ab99efe5289dab7e9b - 0.01% (9.34 KB)

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

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

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


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

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

2023-08-07 19:39:22 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=16

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

ENV PG_VERSION=16.0

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

ENV PG_SHA256=df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

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-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":"16.0","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@16.0?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:0344180f3d51f47aa56acaed4c51270d5bf478978faf7be4ab02f4aea831d429

Created

2023-10-04 14:54:45 UTC

Size

98.1 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

16

PG_SHA256

df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

PG_VERSION

16.0


Layers

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

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

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

[#003] sha256:bfcc9e05256adeffdd1dbb02263b159f1aa3e9217b61bead389e337215302c0b - 96.69% (94.9 MB)

[#004] sha256:32c24bc4e44c015ace689e4a5650b4670cca20063d326c09e699b75a40b8cbff - 0.01% (9.34 KB)

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

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

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


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

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

2023-08-07 20:16:36 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=16

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

ENV PG_VERSION=16.0

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

ENV PG_SHA256=df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

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

Created

2023-10-04 14:54:45 UTC

Size

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

16

PG_SHA256

df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

PG_VERSION

16.0


Layers

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

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

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

[#003] sha256:2a1c323726aa497c6d0e617751fca2027dda7de986b565b62f492923b6760ee4 - 96.72% (89.8 MB)

[#004] sha256:2314e21c078fe99c92e205311170abccaeb4d5ad7ef0b8eaa127823b1f946450 - 0.01% (9.34 KB)

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

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

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


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

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

2023-08-07 19:42:02 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=16

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

ENV PG_VERSION=16.0

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

ENV PG_SHA256=df9e823eb22330444e1d48e52cc65135a652a6fdb3ce325e3f08549339f51b99

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-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":"16.0","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@16.0?os_name=alpine&os_version=3.17"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit

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

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

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

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

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

ENV PGDATA=/var/lib/postgresql/data

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

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

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

VOLUME [/var/lib/postgresql/data]

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

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

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

ENTRYPOINT ["docker-entrypoint.sh"]

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

STOPSIGNAL SIGINT

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

EXPOSE map[5432/tcp:{}]

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

CMD ["postgres"]

Danger Zone
Delete Tag

Please be careful as this will not just delete the reference but also the actual content!

For example when you have latest and v1.2.3 both pointing to the same image
the deletion of latest will also permanently remove v1.2.3.