# Project check: PostgreSQL 18.7, 17.12, 16.16, 15.20 and 14.25: 52 Security Fixes

The prompt behind the "Check your project" buttons on https://thestacksentinel.com/articles/postgresql-18-7-17-12-16-16-15-20-and-14-25-52-security-fixes-15949224/. Paste it into a coding agent that can read your project. It asks for a read-only check and changes nothing.

---

Check this project against a security advisory. This is a read-only check.

Advisory: PostgreSQL 18.7, 17.12, 16.16, 15.20 and 14.25: 52 Security Fixes
Article: https://thestacksentinel.com/articles/postgresql-18-7-17-12-16-16-15-20-and-14-25-52-security-fixes-15949224/
Data: CVE records on cve.org as of 2026-11-15.

Rules
- Only read files and run commands that print versions or list what is installed, for example `node --version`, `npm ls <package>`, `pip show <package>`, `docker image ls`.
- Do not install, upgrade, restart, edit, commit or delete anything, and do not send project files or data to any service.
- If a check would need a change or another command, skip it and say why.

Products and fixed releases (from the CVE records)
- PostgreSQL: fixed in 14.25, 15.20, 16.16, 17.12, 18.7. CVEs: CVE-2026-116304 (High 8.8), CVE-2026-116306 (High 8.8), CVE-2026-116307 (High 8.8), CVE-2026-116309 (High 8.8) and 36 more
"Fixed in" lists the earliest release on each line that fixes all of that product's CVEs here. A version is not affected if it is at or above the fixed release of its own line, or on a newer line than any listed. A version on an older line with no fixed release listed is affected unless the article says otherwise. Exact ranges are in each CVE record: https://www.cve.org/CVERecord?id=<CVE id>.

Releases our tester installed and ran from official packages: PostgreSQL 18.7, PostgreSQL 17.12, PostgreSQL 16.16.
The article's upgrade advice: "Checking PostgreSQL servers and partitioned tables after the update", https://thestacksentinel.com/articles/postgresql-18-7-17-12-16-16-15-20-and-14-25-52-security-fixes-15949224/#checking-postgresql-servers-and-partitioned-tables

Steps
1. Find every place this project uses or pins these products: manifests and lockfiles (with transitive dependencies), Dockerfiles and compose files, CI configuration, infrastructure code, and version files such as .nvmrc or .tool-versions.
2. Where you can, read the version that actually runs, such as the server or runtime that handles requests, not only the command-line tool.
3. Compare each version with the affected ranges above. If the advisory's title names a product the list leaves out, take its fixed releases from the article.
4. Packages from a Linux distribution (Debian, Ubuntu, RHEL, Alpine) can carry the fix under an older version number: mark them CHECK_DISTRO and name the distribution's security tracker instead of a verdict.

Report
- A table: component | where (file:line or command) | version | verdict (AFFECTED, NOT_AFFECTED, CHECK_DISTRO or UNKNOWN).
- For each AFFECTED row, the smallest change that fixes it, as text: the file and line, and the version to move to. Do not apply it.
- What you could not check, and why.
- Finish by asking me which of these fixes, if any, I want you to apply.
