Namespace
nextcloud
Image / Tagaio-postgresql:20231130_081302-latest
Content Digestsha256:5e4b1fbdd414d03d5ee5a9954923e187010550ef6447a369f865609fd730cf33
Details
2023-11-23 18:17:15 UTC
91.8 MB
Labels
-
com.centurylinklabs.watchtower.enablefalse
Environment
DOCKER_PG_LLVM_DEPSllvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR15
PG_SHA2568f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6
PG_VERSION15.5
Layers
[#000] sha256:96526aa774ef0126ad0fe9e9a95764c5fc37f409ab9e97021e7b4775d82bf6fa - 3.53% (3.24 MB)
[#001] sha256:f3836ccc9a671f92dd7a0a39b773099c2b4f7ed43e34f382ce3c7bd9749fbdf0 - 0.0% (1.23 KB)
[#002] sha256:3625732fb368127891ca01e88849356e1a7eb52799691bb39f647b70751a4812 - 0.0% (116 Bytes)
[#003] sha256:db2cf8153bfecc54d53cfd37e08632a6931d2477fe9175fb7ad6839b35d59664 - 96.02% (88.2 MB)
[#004] sha256:57d1e4d158ff5bfb791b54ffcec3949ba4718b23bfb33c7e9c7302084a73ca44 - 0.01% (9.22 KB)
[#005] sha256:d4b0373986676d450c11f56c0d42ac27028bf780591f95082e60213fc4a63ec4 - 0.0% (129 Bytes)
[#006] sha256:fffdf7fd1f651f11ce0ab47aa2eba0b71f7286b7d5e9c832c325b4b1840e4623 - 0.0% (169 Bytes)
[#007] sha256:6fbe9502899e9e63e0fe2cdf366dcf73d0704e439f3c5c2d56583fde02d81a88 - 0.0% (4.67 KB)
[#008] sha256:cb2dc036547cddc8659889510c33d595955ebba1ff7d092d428db9a4ad942513 - 0.0% (2.67 KB)
[#009] sha256:52dc4165169fe2ee4053eb340b88b11d47f848647b5b64de082929f796554681 - 0.0% (255 Bytes)
[#010] sha256:e6879f6ab404f006d5dc76945865ff2b8fb59211085417121826be3a99ae6601 - 0.0% (400 Bytes)
[#011] sha256:1c55ac3e090e89b46b6734b930fa88a3ff9d280a4fa1e35c1f8b37307331b541 - 0.43% (402 KB)
History
/bin/sh -c #(nop) ADD file:756183bba9c7f4593c2b216e98e4208b9163c4c962ea0837ef88bd917609d001 in /
2023-09-28 21:19:27 UTC/bin/sh -c #(nop) CMD ["/bin/sh"]
2023-11-09 19:51:15 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-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.utf8
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV PG_MAJOR=15
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=15.5
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV PG_SHA256=8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15
2023-11-09 19:51:15 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.18"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit
2023-11-09 19:51:15 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-09 19:51:15 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-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 1777 "$PGDATA" # buildkit
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)VOLUME [/var/lib/postgresql/data]
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)COPY docker-entrypoint.sh /usr/local/bin/ # buildkit
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)CMD ["postgres"]
2023-11-23 18:17:14 UTC (buildkit.dockerfile.v0)COPY start.sh /start.sh # buildkit
2023-11-23 18:17:14 UTC (buildkit.dockerfile.v0)COPY healthcheck.sh /healthcheck.sh # buildkit
2023-11-23 18:17:14 UTC (buildkit.dockerfile.v0)COPY init-user-db.sh /docker-entrypoint-initdb.d/init-user-db.sh # buildkit
2023-11-23 18:17:15 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -ex; apk add --no-cache bash openssl shadow grep; deluser postgres; groupmod -g 9999 ping; addgroup -g 999 -S postgres; adduser -u 999 -S -D -G postgres -H -h /var/lib/postgresql -s /bin/sh postgres; apk del --no-cache shadow; chown -R postgres:postgres /var/lib/postgresql; chown -R postgres:postgres /var/run/postgresql; chmod -R 777 /var/run/postgresql; chown -R postgres:postgres "$PGDATA"; mkdir /mnt/data; chown postgres:postgres /mnt/data; echo "root:$(openssl rand -base64 12)" | chpasswd; apk --no-cache del openssl; # buildkit
2023-11-23 18:17:15 UTC (buildkit.dockerfile.v0)VOLUME [/mnt/data]
2023-11-23 18:17:15 UTC (buildkit.dockerfile.v0)USER postgres
2023-11-23 18:17:15 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["/start.sh"]
2023-11-23 18:17:15 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "/healthcheck.sh"] "0s" "0s" "0s" "0s" '\x00'}
2023-11-23 18:17:15 UTC (buildkit.dockerfile.v0)LABEL com.centurylinklabs.watchtower.enable=false
Details
2023-11-23 18:17:50 UTC
90.7 MB
Labels
-
com.centurylinklabs.watchtower.enablefalse
Environment
DOCKER_PG_LLVM_DEPSllvm15-dev clang15
LANGen_US.utf8
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGDATA/var/lib/postgresql/data
PG_MAJOR15
PG_SHA2568f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6
PG_VERSION15.5
Layers
[#000] sha256:579b34f0a95bb83b3acd6b3249ddc52c3d80f5c84b13c944e9e324feb86dd329 - 3.5% (3.18 MB)
[#001] sha256:57128d869f4112bd058a44bc2fd19d9b05ea0895b34ad51c07e45ddadd30d480 - 0.0% (1.23 KB)
[#002] sha256:a1755e5b66878a2e0b911de75610a642179f0862fd67d7ac96105919310c7ee6 - 0.0% (116 Bytes)
[#003] sha256:46fabcd5e3e9569fcb3194313347a65a35ffab93031c7bc3508f4387e60ee9a8 - 96.04% (87.1 MB)
[#004] sha256:4c719d2e51cca8e9eed1c6c3c7260be19d963e788f6022ff7f2bc16403aef834 - 0.01% (9.22 KB)
[#005] sha256:e422dee7789d16578133cdb5f5568913c61b52be88c45ae067aa17a6cb72ebde - 0.0% (129 Bytes)
[#006] sha256:ccca81d5347aaa12072913d94e73c290a9843c998107c0c07dc8ad4fe092318b - 0.0% (165 Bytes)
[#007] sha256:1bcd5742871b25ff689300fe1b04a2a1f64ff113a363a25a48ac51be196e7db3 - 0.01% (4.67 KB)
[#008] sha256:4d576b20635044ed08e3f6f793edc74ef221862c2e19f193ad8688bf4a39f69f - 0.0% (2.67 KB)
[#009] sha256:43aa031dd5c9e2bc55b3a0a15a93ad570946594a4f0b9f0611c682457a84d822 - 0.0% (255 Bytes)
[#010] sha256:8e9dcdda4e6bc989806a97691c5d217143a3d691e79578dd172c3b507f37f570 - 0.0% (400 Bytes)
[#011] sha256:36bb7d2b2b7824f2329cb9da71d8a3d55ada8bc51feb45b42ef91cc382ccc42a - 0.44% (405 KB)
History
/bin/sh -c #(nop) ADD file:ff3112828967e8004a3264d7ece3f81c88e6a1d44d360b9b5613caab15b41717 in /
2023-09-28 20:39:34 UTC/bin/sh -c #(nop) CMD ["/bin/sh"]
2023-11-09 19:51:15 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-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV LANG=en_US.utf8
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir /docker-entrypoint-initdb.d # buildkit
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV PG_MAJOR=15
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV PG_VERSION=15.5
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV PG_SHA256=8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV DOCKER_PG_LLVM_DEPS=llvm15-dev clang15
2023-11-09 19:51:15 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.18"}],"licenseDeclared":"PostgreSQL"}]}' > /usr/local/postgres.spdx.json ; postgres --version # buildkit
2023-11-09 19:51:15 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-09 19:51:15 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-09 19:51:15 UTC (buildkit.dockerfile.v0)ENV PGDATA=/var/lib/postgresql/data
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 1777 "$PGDATA" # buildkit
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)VOLUME [/var/lib/postgresql/data]
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)COPY docker-entrypoint.sh /usr/local/bin/ # buildkit
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["docker-entrypoint.sh"]
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)STOPSIGNAL SIGINT
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)EXPOSE map[5432/tcp:{}]
2023-11-09 19:51:15 UTC (buildkit.dockerfile.v0)CMD ["postgres"]
2023-11-23 18:17:44 UTC (buildkit.dockerfile.v0)COPY start.sh /start.sh # buildkit
2023-11-23 18:17:44 UTC (buildkit.dockerfile.v0)COPY healthcheck.sh /healthcheck.sh # buildkit
2023-11-23 18:17:44 UTC (buildkit.dockerfile.v0)COPY init-user-db.sh /docker-entrypoint-initdb.d/init-user-db.sh # buildkit
2023-11-23 18:17:50 UTC (buildkit.dockerfile.v0)RUN /bin/sh -c set -ex; apk add --no-cache bash openssl shadow grep; deluser postgres; groupmod -g 9999 ping; addgroup -g 999 -S postgres; adduser -u 999 -S -D -G postgres -H -h /var/lib/postgresql -s /bin/sh postgres; apk del --no-cache shadow; chown -R postgres:postgres /var/lib/postgresql; chown -R postgres:postgres /var/run/postgresql; chmod -R 777 /var/run/postgresql; chown -R postgres:postgres "$PGDATA"; mkdir /mnt/data; chown postgres:postgres /mnt/data; echo "root:$(openssl rand -base64 12)" | chpasswd; apk --no-cache del openssl; # buildkit
2023-11-23 18:17:50 UTC (buildkit.dockerfile.v0)VOLUME [/mnt/data]
2023-11-23 18:17:50 UTC (buildkit.dockerfile.v0)USER postgres
2023-11-23 18:17:50 UTC (buildkit.dockerfile.v0)ENTRYPOINT ["/start.sh"]
2023-11-23 18:17:50 UTC (buildkit.dockerfile.v0)HEALTHCHECK &{["CMD-SHELL" "/healthcheck.sh"] "0s" "0s" "0s" "0s" '\x00'}
2023-11-23 18:17:50 UTC (buildkit.dockerfile.v0)LABEL com.centurylinklabs.watchtower.enable=false
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.