Tag

library/postgres:12.16-alpine3.17
Content Digest: sha256:f126e8d08507b1634638865743e2c3e21fcb54fed0d40ef2be011a0d228f4ffb
Manifests
Details
Content Digest

sha256:7295dfaaf2b3a9af134dfa885330186b87f247d7ad25be18d256dcd7b530eebd

Created

2023-10-04 14:54:45 UTC

Size

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

12

PG_SHA256

c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

PG_VERSION

12.16


Layers

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

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

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

[#003] sha256:5f0585c9de13fbe051ea43126d59aeb49b9c6412be4e787e7ce711c891baa1de - 96.51% (90.4 MB)

[#004] sha256:6346cdba74856780d38433b8ce961bd235c23787bfa5eb49c24bab19c606ef26 - 0.01% (8.48 KB)

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

[#006] sha256:5263f2949a7720dbe1f5d3f3204e8730a5ae73bcbd69e656c781eeae7fe9c0ed - 0.0% (162 Bytes)

[#007] sha256:a032c1d9ae3360d056c2cba6c90c43a4cfff53e1045d7111f10ff6c36804ce28 - 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=12

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

ENV PG_VERSION=12.16

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

ENV PG_SHA256=c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"12.16","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@12.16?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:aa4dd040603ebe5aa23e2364d955b37f2050cb04f0871f035355527385cfce60

Created

2023-10-04 14:54:45 UTC

Size

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

12

PG_SHA256

c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

PG_VERSION

12.16


Layers

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

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

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

[#003] sha256:6f0befd616b8ba3ab21630194693ea5e2ba3c79b6e127e4a5abb7ff4c13967bf - 96.37% (85.9 MB)

[#004] sha256:eebd45e8028631cf4ed92c9648db1ad0d2810b9fe5c5bcfa4f8e57c7e66f0a24 - 0.01% (8.48 KB)

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

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

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


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

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

2023-08-07 19:20:26 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=12

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

ENV PG_VERSION=12.16

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

ENV PG_SHA256=c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"12.16","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@12.16?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:cd17a613614751e410d2f385d7fa772a11665ed5de39bb4ecb6a0f088ba24541

Created

2023-10-04 14:54:45 UTC

Size

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

12

PG_SHA256

c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

PG_VERSION

12.16


Layers

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

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

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

[#003] sha256:2a503fb411748b6ce405e61e9786983d4155fa92fcd9f71464499978d6a0d717 - 96.56% (83.8 MB)

[#004] sha256:8c18d66a94e729a86a5d3dbe6111b4bfb3e402552736a475c8c6359c82ef1a43 - 0.01% (8.48 KB)

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

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

[#007] sha256:4e5d0370c173ea2c136853a2e48495ebbc7f9c70da9751b0272b58a0d7a8c2c1 - 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=12

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

ENV PG_VERSION=12.16

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

ENV PG_SHA256=c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"12.16","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@12.16?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:29c9548b4f2388114acf4dabb88cfe52ab4f61db6156fcbb2d7547cec68daa4c

Created

2023-10-04 14:54:45 UTC

Size

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

12

PG_SHA256

c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

PG_VERSION

12.16


Layers

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

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

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

[#003] sha256:cedd2d61122feab4d18043ff527659e1077e50578a2cd181e1042a3a11032f51 - 96.63% (78.9 MB)

[#004] sha256:8b798e70e899cb16a8cd6606ccffef6542e37e8c935ae3c71972f6f05e6a38d3 - 0.01% (8.48 KB)

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

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

[#007] sha256:e899a09374e12bcba3963db26c2b9aaa5745a26073b10e8c2c9d71d3e912cad4 - 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=12

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

ENV PG_VERSION=12.16

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

ENV PG_SHA256=c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"12.16","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@12.16?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:2e9ac9efa6f5f4411af57bebf5b9015a5c45719a5c2c153ccb710f640461d1fa

Created

2023-10-04 14:54:45 UTC

Size

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

12

PG_SHA256

c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

PG_VERSION

12.16


Layers

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

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

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

[#003] sha256:355c21bbd3716a93a47b5d42319e3d099761eeb9866752b12ccb86c64227d4ce - 96.41% (83.8 MB)

[#004] sha256:1c51196c425496d3bec2eafc235efe52d3891600b176436f867988e6eafd2eb3 - 0.01% (8.48 KB)

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

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

[#007] sha256:46c2b5f9e61e92e69c7274d4df6dc62454f523e408d21f2e9bd6c4c4aa30b4ab - 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=12

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

ENV PG_VERSION=12.16

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

ENV PG_SHA256=c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"12.16","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@12.16?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:90d792a3097755664edff3b2c37e6b64b99b7bee14dca225706c365c04a5c25a

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

12

PG_SHA256

c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

PG_VERSION

12.16


Layers

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

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

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

[#003] sha256:93ecff7a124af146f74e539772495c1276c746947ce050b01eb16d9cdf672fbd - 96.56% (91.2 MB)

[#004] sha256:fab83f1f42ff0e2d1c4abe610b04ae452ecd99a8d1a0a02086d58cdd1a5a39e1 - 0.01% (8.49 KB)

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

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

[#007] sha256:1f96487db70f7774848d51e2451a7005237cf6d2714b6ff08bbcd6fb8fa76997 - 0.0% (4.68 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=12

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

ENV PG_VERSION=12.16

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

ENV PG_SHA256=c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"12.16","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@12.16?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:fc8ae4d718fc0451b3028144ccf7ce988ddfa7875980740b125d6047f6897dbd

Created

2023-10-04 14:54:45 UTC

Size

89.3 MB


Environment
DOCKER_PG_LLVM_DEPS

llvm15-dev clang15

LANG

en_US.utf8

PATH

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

PGDATA

/var/lib/postgresql/data

PG_MAJOR

12

PG_SHA256

c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

PG_VERSION

12.16


Layers

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

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

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

[#003] sha256:1ce3130bda16d1b6987a095ff268d969d55a58e1fc158309a4a5df4c58a3cefc - 96.59% (86.3 MB)

[#004] sha256:56d46dd6feb91e505c7812b5cb46049534ac1d2a2bf106185437af2e97c2543e - 0.01% (8.48 KB)

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

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

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


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

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

2023-08-07 19:42:02 UTC

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

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

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

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

ENV LANG=en_US.utf8

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

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

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

ENV PG_MAJOR=12

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

ENV PG_VERSION=12.16

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

ENV PG_SHA256=c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3

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

ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15

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

RUN /bin/sh -c set -eux; wget -O postgresql.tar.bz2 "https://ftp.postgresql.org/pub/source/v$PG_VERSION/postgresql-$PG_VERSION.tar.bz2"; echo "$PG_SHA256 *postgresql.tar.bz2" | sha256sum -c -; mkdir -p /usr/src/postgresql; tar --extract --file postgresql.tar.bz2 --directory /usr/src/postgresql --strip-components 1 ; rm postgresql.tar.bz2; apk add --no-cache --virtual .build-deps $DOCKER_PG_LLVM_DEPS bison coreutils dpkg-dev dpkg flex g++ gcc krb5-dev libc-dev libedit-dev libxml2-dev libxslt-dev linux-headers make openldap-dev openssl-dev perl-dev perl-ipc-run perl-utils python3-dev tcl-dev util-linux-dev zlib-dev icu-dev ; cd /usr/src/postgresql; awk '$1 == "#define" && $2 == "DEFAULT_PGSOCKET_DIR" && $3 == "\"/tmp\"" { $3 = "\"/var/run/postgresql\""; print; next } { print }' src/include/pg_config_manual.h > src/include/pg_config_manual.h.new; grep '/var/run/postgresql' src/include/pg_config_manual.h.new; mv src/include/pg_config_manual.h.new src/include/pg_config_manual.h; gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; wget -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; wget -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; export LLVM_CONFIG="/usr/lib/llvm15/bin/llvm-config"; export CLANG=clang-15; ./configure --enable-option-checking=fatal --build="$gnuArch" --enable-integer-datetimes --enable-thread-safety --enable-tap-tests --disable-rpath --with-uuid=e2fs --with-gnu-ld --with-pgport=5432 --with-system-tzdata=/usr/share/zoneinfo --prefix=/usr/local --with-includes=/usr/local/include --with-libraries=/usr/local/lib --with-gssapi --with-ldap --with-tcl --with-perl --with-python --with-openssl --with-libxml --with-libxslt --with-icu --with-llvm ; make -j "$(nproc)" world; make install-world; make -C contrib install; runDeps="$( scanelf --needed --nobanner --format '%n#p' --recursive /usr/local | tr ',' '\n' | sort -u | awk 'system("[ -e /usr/local/lib/" $1 " ]") == 0 { next } { print "so:" $1 }' | grep -v -e perl -e python -e tcl )"; apk add --no-cache --virtual .postgresql-rundeps $runDeps bash su-exec tzdata zstd icu-data-full $([ "$(apk --print-arch)" != 'ppc64le' ] && echo 'nss_wrapper') ; apk del --no-network .build-deps; cd /; rm -rf /usr/src/postgresql /usr/local/share/doc /usr/local/share/man ; echo '{"spdxVersion":"SPDX-2.3","SPDXID":"SPDXRef-DOCUMENT","name":"postgres-sbom","packages":[{"name":"postgres","versionInfo":"12.16","SPDXID":"SPDXRef-Package--postgres","externalRefs":[{"referenceCategory":"PACKAGE-MANAGER","referenceType":"purl","referenceLocator":"pkg:generic/postgres@12.16?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.