A dump/restore is not required for those running 17.X.
\nHowever, if you are upgrading from a version earlier than 17.6, see Section E.6.
", "compatibility_count": 0, "label": "17.9", "status_label": "Supported", "eol": "2029-11-08", "age_days": 212, "support_days": 1139}, "groups": [{"date": "2026-02-26", "build": "17.9", "major": "17", "minor": 9, "manual": "17", "status": "stable", "doc_git": "", "version": "17.9", "eol_date": "2029-11-08", "date_text": "2026-02-26", "supported": true, "manual_url": "/docs/17/release-17-9.html", "source_url": "/docs/release/17.9/", "entry_count": 6, "placeholder": false, "content_hash": "5cc2fa2fa4a262cbefe6dceba9a0f840ac5af5a0b91b8b2255922687c46cefb6", "manual_build": "17.11", "source_as_of": "", "changes_count": 6, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 17.X.
\nHowever, if you are upgrading from a version earlier than 17.6, see Section E.6.
", "compatibility_count": 0, "label": "17.9", "status_label": "Supported", "eol": "2029-11-08", "age_days": 212, "support_days": 1139, "entries": [{"id": "17.9-80ecbcad5117683e", "cves": [], "html": "Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version (Heikki Linnakangas) §
\nErroneous logic for coping with the way that previous versions handled multixid wraparound led to replay failure, with messages like “could not access status of transaction”. A typical scenario in which this could occur is a standby server of the latest minor version consuming WAL from a primary server of an older version.
", "text": "Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version (Heikki Linnakangas) § Erroneous logic for coping with the way that previous versions handled multixid wraparound led to replay failure, with messages like “could not access status of transaction”. A typical scenario in which this could occur is a standby server of the latest minor version consuming WAL from a primary server of an older version.", "title": "Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version", "commits": ["4a36c89f1"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/17.9/#RELEASE-17-9-CHANGES", "source_hash": "5301788c87a3db984faace17c7bd4a7a012ab0d7cc19a79a859c975b284beed6", "section_path": ["Changes"], "commit_groups": [["23064542f", "4a36c89f1", "547a8aaa7", "817f74600", "899de38d8"]], "identity_text": "Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version (Heikki Linnakangas) Erroneous logic for coping with the way that previous versions handled multixid wraparound led to replay failure, with messages like could not access status of transaction. A typical scenario in which this could occur is a standby server of the latest minor version consuming WAL from a primary server of an older version.", "commit_aliases": ["23064542f", "4a36c89f1", "547a8aaa7", "817f74600", "899de38d8"], "source_commits": ["4a36c89f1"], "source_entry_id": "17.9/changes/001", "db_id": "269e20cac41b248d80f469e35fb3be04", "patch_ids": ["e8c592597fe0c522a838714ea94d192e"], "statement_hash": "cf611d327c6efbb05b8c3c3eec25baadc4b81f3015eda12031c5dfd70647d75d", "relations": [{"rule": 2, "type": "equivalent", "target": "54acee06ad9ee6f00cba048e48dfdadc", "evidence": {"same_day": true, "patch_ids": ["e8c592597fe0c522a838714ea94d192e"], "statement_hash": "cf611d327c6efbb05b8c3c3eec25baadc4b81f3015eda12031c5dfd70647d75d"}}, {"rule": 2, "type": "equivalent", "target": "6d7df9238b789e2555fe1290d455a61a", "evidence": {"same_day": true, "patch_ids": ["e8c592597fe0c522a838714ea94d192e"], "statement_hash": "cf611d327c6efbb05b8c3c3eec25baadc4b81f3015eda12031c5dfd70647d75d"}}, {"rule": 2, "type": "equivalent", "target": "ac9d069b97f39c99f4c9540523c6dd01", "evidence": {"same_day": true, "patch_ids": ["e8c592597fe0c522a838714ea94d192e"], "statement_hash": "cf611d327c6efbb05b8c3c3eec25baadc4b81f3015eda12031c5dfd70647d75d"}}, {"rule": 2, "type": "equivalent", "target": "bb4c9dfad3173d99906963ab569e5990", "evidence": {"same_day": true, "patch_ids": ["e8c592597fe0c522a838714ea94d192e"], "statement_hash": "cf611d327c6efbb05b8c3c3eec25baadc4b81f3015eda12031c5dfd70647d75d"}}], "version": "17.9", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6d7df9238b789e2555fe1290d455a61a", "kind": "equivalent", "version": "18.3", "label": "18.3", "title": "Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version", "evidence": {"same_day": true, "patch_ids": ["e8c592597fe0c522a838714ea94d192e"], "statement_hash": "cf611d327c6efbb05b8c3c3eec25baadc4b81f3015eda12031c5dfd70647d75d"}, "url": "/docs/compare/?release=18.3#18.3-ad611cd1e209983f", "source_url": "/docs/release/18.3/#RELEASE-18-3-CHANGES"}, {"db_id": "54acee06ad9ee6f00cba048e48dfdadc", "kind": "equivalent", "version": "16.13", "label": "16.13", "title": "Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version", "evidence": {"same_day": true, "patch_ids": ["e8c592597fe0c522a838714ea94d192e"], "statement_hash": "cf611d327c6efbb05b8c3c3eec25baadc4b81f3015eda12031c5dfd70647d75d"}, "url": "/docs/compare/?release=16.13#16.13-2ec40dc78a340503", "source_url": "/docs/release/16.13/#RELEASE-16-13-CHANGES"}, {"db_id": "ac9d069b97f39c99f4c9540523c6dd01", "kind": "equivalent", "version": "15.17", "label": "15.17", "title": "Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version", "evidence": {"same_day": true, "patch_ids": ["e8c592597fe0c522a838714ea94d192e"], "statement_hash": "cf611d327c6efbb05b8c3c3eec25baadc4b81f3015eda12031c5dfd70647d75d"}, "url": "/docs/compare/?release=15.17#15.17-b825392cb651a3f2", "source_url": "/docs/release/15.17/#id-1.11.6.8.5"}, {"db_id": "bb4c9dfad3173d99906963ab569e5990", "kind": "equivalent", "version": "14.22", "label": "14.22", "title": "Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version", "evidence": {"same_day": true, "patch_ids": ["e8c592597fe0c522a838714ea94d192e"], "statement_hash": "cf611d327c6efbb05b8c3c3eec25baadc4b81f3015eda12031c5dfd70647d75d"}, "url": "/docs/compare/?release=14.22#14.22-006d7b5e05d070c9", "source_url": "/docs/release/14.22/#id-1.11.6.8.6"}]}, {"id": "17.9-24d7e69f6ec0ae9a", "cves": ["CVE-2026-2006"], "html": "Avoid incorrect complaint of invalid encoding when substring() is applied to “toasted” data (Noah Misch) § § §
The fix for CVE-2026-2006 was too aggressive and could raise an error about an incomplete character in cases that are actually valid.
", "text": "Avoid incorrect complaint of invalid encoding when substring() is applied to “toasted” data (Noah Misch) § § § The fix for CVE-2026-2006 was too aggressive and could raise an error about an incomplete character in cases that are actually valid.", "title": "Avoid incorrect complaint of invalid encoding when substring() is applied to “toasted” data", "commits": ["50d361f62", "5d5232bc3", "8e73530f1"], "section": "Changes", "category": "security", "source_url": "/docs/release/17.9/#RELEASE-17-9-CHANGES", "source_hash": "f66079943109d09ab5df6de739fc355e5c2d722d3c278d0cc7fdcdd0da281fcd", "section_path": ["Changes"], "commit_groups": [["14b1fd617", "5d5232bc3", "6e045e1a6", "9f4fd119b", "a20eb248c", "bdfb37228"], ["2280ab354", "50d361f62", "8cef93d8a", "a0769e74d", "d04b34d68", "ec86152e0"], ["4174e41b9", "44fc85bbf", "45eb47230", "4644f8b23", "5b305ebcc", "8e73530f1"]], "identity_text": "Avoid incorrect complaint of invalid encoding when substring() is applied to toasted data (Noah Misch) The fix for CVE-2026-2006 was too aggressive and could raise an error about an incomplete character in cases that are actually valid.", "commit_aliases": ["14b1fd617", "2280ab354", "4174e41b9", "44fc85bbf", "45eb47230", "4644f8b23", "50d361f62", "5b305ebcc", "5d5232bc3", "6e045e1a6", "8cef93d8a", "8e73530f1", "9f4fd119b", "a0769e74d", "a20eb248c", "bdfb37228", "d04b34d68", "ec86152e0"], "source_commits": ["50d361f62", "5d5232bc3", "8e73530f1"], "source_entry_id": "17.9/changes/002", "db_id": "91516991913d971894a1428891e4772e", "patch_ids": ["924bc2a7b62c922890c6948fec9b1504", "b621552d0483c3fe9118c60e77f297ab", "fe6380c6909ab3efff6be8983b7f18a1"], "statement_hash": "b34aae4222592f29a7ecee54df249e73bebb9346d81b2e5c859347ba8c1ea747", "relations": [{"rule": 2, "type": "equivalent", "target": "2913b28e99dd666bc31951814a799735", "evidence": {"same_day": true, "patch_ids": ["924bc2a7b62c922890c6948fec9b1504", "b621552d0483c3fe9118c60e77f297ab", "fe6380c6909ab3efff6be8983b7f18a1"], "statement_hash": "b34aae4222592f29a7ecee54df249e73bebb9346d81b2e5c859347ba8c1ea747"}}, {"rule": 2, "type": "equivalent", "target": "9b63cad6030353d772f1330dfd687e9f", "evidence": {"same_day": true, "patch_ids": ["924bc2a7b62c922890c6948fec9b1504", "b621552d0483c3fe9118c60e77f297ab", "fe6380c6909ab3efff6be8983b7f18a1"], "statement_hash": "b34aae4222592f29a7ecee54df249e73bebb9346d81b2e5c859347ba8c1ea747"}}, {"rule": 2, "type": "equivalent", "target": "da9fc04e8b825c72955bd70be9fd53ee", "evidence": {"same_day": true, "patch_ids": ["924bc2a7b62c922890c6948fec9b1504", "b621552d0483c3fe9118c60e77f297ab", "fe6380c6909ab3efff6be8983b7f18a1"], "statement_hash": "b34aae4222592f29a7ecee54df249e73bebb9346d81b2e5c859347ba8c1ea747"}}, {"rule": 2, "type": "equivalent", "target": "fe28a154c085da9085a635db8d9d4460", "evidence": {"same_day": true, "patch_ids": ["924bc2a7b62c922890c6948fec9b1504", "b621552d0483c3fe9118c60e77f297ab", "fe6380c6909ab3efff6be8983b7f18a1"], "statement_hash": "b34aae4222592f29a7ecee54df249e73bebb9346d81b2e5c859347ba8c1ea747"}}], "version": "17.9", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "9b63cad6030353d772f1330dfd687e9f", "kind": "equivalent", "version": "18.3", "label": "18.3", "title": "Avoid incorrect complaint of invalid encoding when substring() is applied to “toasted” data", "evidence": {"same_day": true, "patch_ids": ["924bc2a7b62c922890c6948fec9b1504", "b621552d0483c3fe9118c60e77f297ab", "fe6380c6909ab3efff6be8983b7f18a1"], "statement_hash": "b34aae4222592f29a7ecee54df249e73bebb9346d81b2e5c859347ba8c1ea747"}, "url": "/docs/compare/?release=18.3#18.3-77113f5b52409590", "source_url": "/docs/release/18.3/#RELEASE-18-3-CHANGES"}, {"db_id": "fe28a154c085da9085a635db8d9d4460", "kind": "equivalent", "version": "16.13", "label": "16.13", "title": "Avoid incorrect complaint of invalid encoding when substring() is applied to “toasted” data", "evidence": {"same_day": true, "patch_ids": ["924bc2a7b62c922890c6948fec9b1504", "b621552d0483c3fe9118c60e77f297ab", "fe6380c6909ab3efff6be8983b7f18a1"], "statement_hash": "b34aae4222592f29a7ecee54df249e73bebb9346d81b2e5c859347ba8c1ea747"}, "url": "/docs/compare/?release=16.13#16.13-46657f359d7a6c06", "source_url": "/docs/release/16.13/#RELEASE-16-13-CHANGES"}, {"db_id": "2913b28e99dd666bc31951814a799735", "kind": "equivalent", "version": "15.17", "label": "15.17", "title": "Avoid incorrect complaint of invalid encoding when substring() is applied to “toasted” data", "evidence": {"same_day": true, "patch_ids": ["924bc2a7b62c922890c6948fec9b1504", "b621552d0483c3fe9118c60e77f297ab", "fe6380c6909ab3efff6be8983b7f18a1"], "statement_hash": "b34aae4222592f29a7ecee54df249e73bebb9346d81b2e5c859347ba8c1ea747"}, "url": "/docs/compare/?release=15.17#15.17-ed7a109835c41923", "source_url": "/docs/release/15.17/#id-1.11.6.8.5"}, {"db_id": "da9fc04e8b825c72955bd70be9fd53ee", "kind": "equivalent", "version": "14.22", "label": "14.22", "title": "Avoid incorrect complaint of invalid encoding when substring() is applied to “toasted” data", "evidence": {"same_day": true, "patch_ids": ["924bc2a7b62c922890c6948fec9b1504", "b621552d0483c3fe9118c60e77f297ab", "fe6380c6909ab3efff6be8983b7f18a1"], "statement_hash": "b34aae4222592f29a7ecee54df249e73bebb9346d81b2e5c859347ba8c1ea747"}, "url": "/docs/compare/?release=14.22#14.22-0e619c964c972dcb", "source_url": "/docs/release/14.22/#id-1.11.6.8.6"}]}, {"id": "17.9-1441e21296f1914d", "cves": [], "html": "Fix computation of the set of potentially-nulling outer joins for the output of a LATERAL UNION ALL subquery (Richard Guo) §
This error could lead to skipping NOT NULL tests in the mistaken belief that they were unnecessary, resulting in wrong query output.
Fix pg_stat_get_backend_wait_event() and pg_stat_get_backend_wait_event_type() to report values for auxiliary processes (Heikki Linnakangas) §
Previously these functions returned NULL for auxiliary processes, but that's inconsistent with the pg_stat_activity view.
Fix casting a composite-type variable to a domain type when returning its value from a PL/pgSQL function (Tom Lane) §
\nIf the variable's value is NULL, a “cache lookup failed for type 0” error resulted.
", "text": "Fix casting a composite-type variable to a domain type when returning its value from a PL/pgSQL function (Tom Lane) § If the variable's value is NULL, a “cache lookup failed for type 0” error resulted.", "title": "Fix casting a composite-type variable to a domain type when returning its value from a PL/pgSQL function", "commits": ["dfd850980"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/17.9/#RELEASE-17-9-CHANGES", "source_hash": "8609a1b3bab14b3c4cbecc4cce37cf565bb82d9fbe4e1193bf5243274eacf17c", "section_path": ["Changes"], "commit_groups": [["254b15cbf", "2b93d3820", "9863c9075", "c66f4cff1", "ce4b7e3a1", "dfd850980"]], "identity_text": "Fix casting a composite-type variable to a domain type when returning its value from a PL/pgSQL function (Tom Lane) If the variable's value is NULL, a cache lookup failed for type 0 error resulted.", "commit_aliases": ["254b15cbf", "2b93d3820", "9863c9075", "c66f4cff1", "ce4b7e3a1", "dfd850980"], "source_commits": ["dfd850980"], "source_entry_id": "17.9/changes/005", "db_id": "1f6375c5be0406ebaeab1ddd1281f48a", "patch_ids": ["4682bfcc99694f6b7bf7c07af3082c2e"], "statement_hash": "257a19cad310234769985e6594cf9f32698b7849a63b72427ee23e58e321e7d5", "relations": [{"rule": 2, "type": "equivalent", "target": "08e9766e078b0f98d664963d7351568a", "evidence": {"same_day": true, "patch_ids": ["4682bfcc99694f6b7bf7c07af3082c2e"], "statement_hash": "257a19cad310234769985e6594cf9f32698b7849a63b72427ee23e58e321e7d5"}}, {"rule": 2, "type": "equivalent", "target": "509c9d18c03750ab5a1af4533e9e3f71", "evidence": {"same_day": true, "patch_ids": ["4682bfcc99694f6b7bf7c07af3082c2e"], "statement_hash": "257a19cad310234769985e6594cf9f32698b7849a63b72427ee23e58e321e7d5"}}, {"rule": 2, "type": "equivalent", "target": "b3e55b2d8440115c6283ddb4434aed5d", "evidence": {"same_day": true, "patch_ids": ["4682bfcc99694f6b7bf7c07af3082c2e"], "statement_hash": "257a19cad310234769985e6594cf9f32698b7849a63b72427ee23e58e321e7d5"}}, {"rule": 2, "type": "equivalent", "target": "d7289871637eb477a52d704b8b129dee", "evidence": {"same_day": true, "patch_ids": ["4682bfcc99694f6b7bf7c07af3082c2e"], "statement_hash": "257a19cad310234769985e6594cf9f32698b7849a63b72427ee23e58e321e7d5"}}], "version": "17.9", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d7289871637eb477a52d704b8b129dee", "kind": "equivalent", "version": "18.3", "label": "18.3", "title": "Fix casting a composite-type variable to a domain type when returning its value from a PL/pgSQL function", "evidence": {"same_day": true, "patch_ids": ["4682bfcc99694f6b7bf7c07af3082c2e"], "statement_hash": "257a19cad310234769985e6594cf9f32698b7849a63b72427ee23e58e321e7d5"}, "url": "/docs/compare/?release=18.3#18.3-68534f113dfbb27d", "source_url": "/docs/release/18.3/#RELEASE-18-3-CHANGES"}, {"db_id": "b3e55b2d8440115c6283ddb4434aed5d", "kind": "equivalent", "version": "16.13", "label": "16.13", "title": "Fix casting a composite-type variable to a domain type when returning its value from a PL/pgSQL function", "evidence": {"same_day": true, "patch_ids": ["4682bfcc99694f6b7bf7c07af3082c2e"], "statement_hash": "257a19cad310234769985e6594cf9f32698b7849a63b72427ee23e58e321e7d5"}, "url": "/docs/compare/?release=16.13#16.13-63ccf52c03df56be", "source_url": "/docs/release/16.13/#RELEASE-16-13-CHANGES"}, {"db_id": "509c9d18c03750ab5a1af4533e9e3f71", "kind": "equivalent", "version": "15.17", "label": "15.17", "title": "Fix casting a composite-type variable to a domain type when returning its value from a PL/pgSQL function", "evidence": {"same_day": true, "patch_ids": ["4682bfcc99694f6b7bf7c07af3082c2e"], "statement_hash": "257a19cad310234769985e6594cf9f32698b7849a63b72427ee23e58e321e7d5"}, "url": "/docs/compare/?release=15.17#15.17-f14d3ac393cef450", "source_url": "/docs/release/15.17/#id-1.11.6.8.5"}, {"db_id": "08e9766e078b0f98d664963d7351568a", "kind": "equivalent", "version": "14.22", "label": "14.22", "title": "Fix casting a composite-type variable to a domain type when returning its value from a PL/pgSQL function", "evidence": {"same_day": true, "patch_ids": ["4682bfcc99694f6b7bf7c07af3082c2e"], "statement_hash": "257a19cad310234769985e6594cf9f32698b7849a63b72427ee23e58e321e7d5"}, "url": "/docs/compare/?release=14.22#14.22-3b6651931176e1ab", "source_url": "/docs/release/14.22/#id-1.11.6.8.6"}]}, {"id": "17.9-09236fba7643dbb2", "cves": [], "html": "Fix potential null pointer dereference in contrib/hstore's binary input function (Michael Paquier) §
hstore's receive function crashed on input containing duplicate keys. hstore values generated by Postgres would never contain duplicate keys, so this mistake has gone unnoticed. The crash could be provoked by malicious or corrupted data.