{"slug":"postgresql","tag":"18.6-CE-ubuntu24.04-r4","current":true,"account":false,"tarball":"ReadyStack-postgresql-18.6-CE-ubuntu24.04-r4.tar.gz","tarball_sha256":"44732927d1ea4ccc3aeb8cb3283ee0900b6db52f232919999098ac175e65f7d0","generated_at":"2026-10-29T19:20:21Z","dockerfile":"Dockerfile.offline.pinned","build_script":"BUILD_OFFLINE.sh","pins":{"upstream":{"repo":"https://github.com/postgres/postgres","ref":"REL_18_6","commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","url":"https://github.com/postgres/postgres/tree/724edf9bde9d356724ad384a2e196edc3c9f80f7"},"fetches":[{"kind":"git","url":"https://github.com/postgres/postgres","ref":"REL_18_6"}],"bases":[{"image":"ubuntu:24.04","digest":"sha256:24737cef17f4e22b1977df7d9a05e77c4e28b7da5b8911f8d8ccda136bf3573c"}],"toolchain":{"buildkit":"moby/buildkit:v0.31.2","buildkit_image_digest":"sha256:e0e67ea9c4bb07bdef683e29f70f3b623d1eb9c82274a9ec04e6bb0511449fb0","builder_images":["ubuntu:24.04@sha256:24737cef17f4e22b1977df7d9a05e77c4e28b7da5b8911f8d8ccda136bf3573c"]},"build_method":"source-rebuild-c","source_date_epoch":1786473511,"source_date_epoch_utc":"2026-08-11T18:38:31Z","target":{"image":"readystack/postgresql:18.6-CE-ubuntu24.04-r4","image_manifest_digest":"sha256:183750538702ff27776350942f3d4676c8000b695960afd21d392f13cbfe37ff","config_digest":"sha256:1cb3a6da970db5dc158112809ea1c2782cf853f13911aa4fd87dd80d0cfcf990"},"checksummed_files":14754},"files":[{"path":"BASES.tsv","size":121,"sha256":"0da49a3ea98fcaa345080b1a4230d2c798b395f71854063c2af657eb53a8a2e0","public":"full","lines":1,"url":"/api/recipe/postgresql/18.6-CE-ubuntu24.04-r4/files/BASES.tsv","text":"ubuntu:24.04@sha256:24737cef17f4e22b1977df7d9a05e77c4e28b7da5b8911f8d8ccda136bf3573c\tbases/ubuntu_24.04_24737cef17f4.oci\n"},{"path":"BUILD_OFFLINE.sh","size":6738,"sha256":"83299978ccd02a0b69e163d760da1211b401bbfa35a3184ca674dc37ff876732","public":"preview","lines":125,"preview":{"text":"#!/usr/bin/env bash\n# =============================================================================\n# ReadyStack — offline reproducible rebuild.\n#\n# Rebuilds this product's image from THIS ARCHIVE ALONE, with no network access\n# of any kind, and prints the resulting linux/amd64 image-manifest digest.\n# Run ./VERIFY_OFFLINE.sh afterwards to assert it equals the published digest.\n#\n# Requirements: linux/amd64 Docker host, docker buildx >= 0.30, jq, tar.\n# No git, no registry access, no additional tooling.\n#\n#   ./BUILD_OFFLINE.sh                the rebuild (OCI image + a docker-loadable copy)\n#   ./BUILD_OFFLINE.sh --provenance   the same rebuild with SLSA v1 build provenance (mode=max) attached to the OCI\n#                                     image, generated by BuildKit, not by any build step. Run on your own hardened,\n#                                     isolated build platform and sign that provenance with a key the build cannot\n#                                     reach, and the result meets SLSA Build Level 3 (see REBUILD.md). The image\n#                                     digest is the same either way.\n# =============================================================================\nset -euo pipefail\nPROVENANCE=0\nfor arg in \"$@\"; do\n  case \"$arg\" in\n    --provenance) PROVENANCE=1 ;;\n    -h|--help) sed -n '2,20p' \"$0\"; exit 0 ;;","lines_shown":24,"lines_total":125}},{"path":"CHECKSUMS.sha256","size":1957632,"sha256":"37c4589afae86151fc85d3500d92eea6f724b3e7cbcdaa1a3b9fa74fe03324a2","public":"account","lines":14754},{"path":"DOCKERFILE_NAME.txt","size":26,"sha256":"9aadd1ede68e016a6f163c97befc5ff2fcdc8ebd4f84b108dba63cb195fa8c84","public":"full","lines":1,"url":"/api/recipe/postgresql/18.6-CE-ubuntu24.04-r4/files/DOCKERFILE_NAME.txt","text":"Dockerfile.offline.pinned\n"},{"path":"Dockerfile","size":3907,"sha256":"45f18b60374f8e321c2101a04f8ca21af017d9fdfb01be8751d944338eca1961","public":"account","lines":51},{"path":"Dockerfile.offline","size":3907,"sha256":"45f18b60374f8e321c2101a04f8ca21af017d9fdfb01be8751d944338eca1961","public":"account","lines":51},{"path":"Dockerfile.offline.pinned","size":3907,"sha256":"45f18b60374f8e321c2101a04f8ca21af017d9fdfb01be8751d944338eca1961","public":"preview","lines":51,"preview":{"text":"# GENERATED L-009 hermetic C build (--network=none, SBOM+SLSA-attestation-producing).\n# Pinned bases; vendored source (in-tree deps) + extra build debs + runtime debs from Dockerfile.vendor.\nFROM ubuntu:24.04@sha256:24737cef17f4e22b1977df7d9a05e77c4e28b7da5b8911f8d8ccda136bf3573c AS cbuild\n# dpkg-install the vendored EXTRA build debs (pkg-config/libssl-dev/...) — gcc/make are in the builder.\nRUN --mount=type=bind,source=vendored/build-debs,target=/tmp/bdebs \\\n    set --; for f in /tmp/bdebs/*.deb; do [ -e \"$f\" ] && set -- \"$@\" \"$f\"; done; \\\n    for pass in 1 2 3 4 5; do [ $# -eq 0 ] || dpkg -i --skip-same-version \"$@\" >/dev/null 2>&1 && break; done; \\\n    dpkg --configure -a && bad= && for d in \"$@\"; do p=$(dpkg-deb -f \"$d\" Package) v=$(dpkg-deb -f \"$d\" Version); \\\n      case \"$(dpkg-query -W -f='${Version} ${db:Status-Abbrev}' \"$p\" 2>/dev/null)\" in \"$v ii\"*) ;; *) bad=\"$bad $p=$v\" ;; esac; done && \\\n    { [ -z \"$bad\" ] || { echo \"vendored debs not installed at their vendored version:$bad\" >&2; false; }; }\nWORKDIR /src\nCOPY vendored/postgresql-src/ .\nARG SOURCE_DATE_EPOCH=1786473511\nENV SOURCE_DATE_EPOCH=${SOURCE_DATE_EPOCH}\nENV DEB_BUILD_OPTIONS=nocheck\nRUN ./configure --prefix=/usr/local/pgsql --with-openssl --with-libxml --with-icu --with-lz4 --with-zstd --with-readline --without-llvm\nRUN make -j\"$(nproc)\" world-bin\nRUN make install-world-bin\nFROM ubuntu:24.04@sha256:24737cef17f4e22b1977df7d9a05e77c4e28b7da5b8911f8d8ccda136bf3573c\nENV DEBIAN_FRONTEND=noninteractive PATH=/usr/local/pgsql/bin:$PATH PGDATA=/var/lib/postgresql/data LANG=C.UTF-8 LC_ALL=C.UTF-8\nRUN --mount=type=bind,source=vendored/debs,target=/tmp/debs \\\n    set --; for f in /tmp/debs/*.deb; do [ -e \"$f\" ] && set -- \"$@\" \"$f\"; done; \\\n    for pass in 1 2 3 4 5; do [ $# -eq 0 ] || dpkg -i --skip-same-version \"$@\" >/dev/null 2>&1 && break; done; \\\n    dpkg --configure -a && bad= && for d in \"$@\"; do p=$(dpkg-deb -f \"$d\" Package) v=$(dpkg-deb -f \"$d\" Version); \\","lines_shown":24,"lines_total":51}},{"path":"Dockerfile.vendor","size":1978,"sha256":"3fd1d2e3f5627f9a88fb400e63ebaa8e2f8f4f8d82b52892dde3a69b71c30f12","public":"account","lines":25},{"path":"MANIFEST.txt","size":954390,"sha256":"b0539d9c3c79752e1a8e7f17ade863f7b9e93f8d8424d86788bda16fd4ef74da","public":"account","lines":14756},{"path":"SOURCE_DATE_EPOCH.txt","size":11,"sha256":"a5153e81112ca9bd4f26fe05a199171215ec0064d53ad4ef56b2233ef9116a8f","public":"full","lines":1,"url":"/api/recipe/postgresql/18.6-CE-ubuntu24.04-r4/files/SOURCE_DATE_EPOCH.txt","text":"1786473511\n"},{"path":"TARGET_DIGEST.txt","size":363,"sha256":"ad26f1fd314106c272222e4e20b75e578057a3b14d0d32504e7fade118b9fcfe","public":"full","lines":8,"url":"/api/recipe/postgresql/18.6-CE-ubuntu24.04-r4/files/TARGET_DIGEST.txt","text":"image_manifest_digest=sha256:183750538702ff27776350942f3d4676c8000b695960afd21d392f13cbfe37ff\nconfig_digest=sha256:1cb3a6da970db5dc158112809ea1c2782cf853f13911aa4fd87dd80d0cfcf990\ntag=readystack/postgresql:18.6-CE-ubuntu24.04-r4\nprobe_port=5432\nprobe_path=/\nprobe_timeout=180\nverify_secret=POSTGRES_PASSWORD\nprobe_exec=pg_isready -U postgres -h 127.0.0.1 -p 5432\n"},{"path":"VERIFY_OFFLINE.sh","size":7331,"sha256":"8b036b1f9a7f7deb4dbab14ef6b7c40622d2820904e891b8845ba3580e924506","public":"account","lines":128},{"path":"docker-entrypoint.sh","size":4746,"sha256":"02e09c3562cff730fcfbe692d28ec9a0b0719d4c62e4078f40a3ea22aacaf5c3","public":"account","lines":81},{"path":"docs/PROVENANCE.md","size":1702,"sha256":"970fdce6a5ea3ecb62214feba08c18a391baf0240359500e5977bebeca64380c","public":"account","lines":28},{"path":"docs/REBUILD.md","size":5107,"sha256":"bc1753ac9a36132c97d7a93ff5b2c6446e569d0ae453262b75733bceb49bb47a","public":"account","lines":57},{"path":"docs/VERIFY.md","size":1964,"sha256":"3125d16c4beea3ef008dc484061aa55b8f25c3409cc1491e3f037b610f6efedd","public":"account","lines":34},{"path":"docs/provenance/BASE_IMAGE_DIGESTS.lock","size":65,"sha256":"bfca53c58fe03056902e833d68ae872b544dd355a9474995368fdb4835b2f011","public":"full","lines":2,"url":"/api/recipe/postgresql/18.6-CE-ubuntu24.04-r4/files/docs/provenance/BASE_IMAGE_DIGESTS.lock","text":"# base images for postgresql (resolve at build_kit)\nubuntu:24.04\n"},{"path":"docs/provenance/BUILD_RECIPE.json","size":2898,"sha256":"4c9ab6d25928ca48b8b0888f33bba99cc3f4094313df31d97baa1e1ceb55ef5f","public":"account","lines":70},{"path":"docs/provenance/CUSTODY_INPUTS.json","size":654,"sha256":"c30e0f5126f64c5e061f14bb79e492b86f5989e51147be537ef4e156fc32460d","public":"account","lines":17},{"path":"docs/provenance/SOURCE_FILE_MANIFEST.json","size":214677,"sha256":"721d1f2ab2f35116cc55e1bb441cfa7aa4e3810064301e63adb1cac013e7392b","public":"account","lines":5007},{"path":"docs/provenance/SOURCE_TREE_HASH.json","size":312,"sha256":"5ec2c02425420d47150d0bb52f865448c25bb7db446dfadbc650104a2bbde68c","public":"full","lines":9,"url":"/api/recipe/postgresql/18.6-CE-ubuntu24.04-r4/files/docs/provenance/SOURCE_TREE_HASH.json","text":"{\n  \"schema\": \"kitforge.source_tree_hash.v1\",\n  \"slug\": \"postgresql\",\n  \"repo\": \"https://github.com/postgres/postgres\",\n  \"ref\": \"REL_18_6\",\n  \"commit\": \"724edf9bde9d356724ad384a2e196edc3c9f80f7\",\n  \"tree_listing_sha256\": \"3077b76a2ae1976dc6a019f4e71c840935e7acb8b0240b33a383936e4a47a32d\",\n  \"file_count\": 7284\n}"},{"path":"docs/provenance/SYSTEM_PINNING.lock","size":105,"sha256":"b9f4e4183c64f15e62e53c456e4a5b9510f025afabc9a01438dd7ae9f1451f25","public":"account","lines":11},{"path":"docs/provenance/TOOLCHAIN.lock","size":2493,"sha256":"473f23fd7e8735e6159da5d326e1182988c06ec4291b9a4c57ece4f7f6fe3574","public":"account","lines":89},{"path":"rebuild.json","size":1237,"sha256":"dd10ad5870e88ec50201b8eb3af34de990c24ebda7317d4a75d49c8365db4101","public":"account","lines":36},{"path":"toolchain/BUILDKIT_TAG.txt","size":22,"sha256":"fcd530eeb02b063d2f047adad6eef896422a8e8d558513e5f09b2a262be32573","public":"full","lines":1,"url":"/api/recipe/postgresql/18.6-CE-ubuntu24.04-r4/files/toolchain/BUILDKIT_TAG.txt","text":"moby/buildkit:v0.31.2\n"}],"skipped":[],"kit_adds":{"bases":{"files":5,"bytes":29771169},"docs":{"files":7336,"bytes":144932668},"toolchain":{"files":1,"bytes":111529472},"vendored":{"files":7389,"bytes":277086278}},"links":{"page":"https://readystack.dev/products/postgresql/recipe","signup":"https://readystack.dev/login.html?create=1&next=%2Fproducts%2Fpostgresql%2Frecipe","kit":"https://readystack.dev/buy.html?product=postgresql"}}