A dump/restore is not required for those running 9.6.X.
\nHowever, if your installation has been affected by the bugs described in the first two changelog entries below, then after updating you may need to take action to repair corrupted free space maps and/or visibility maps.
", "compatibility_count": 0, "label": "9.6.1", "status_label": "Historical", "eol": "2021-11-11", "age_days": 3624, "support_days": -1783}, "groups": [{"date": "2016-10-27", "build": "9.6.1", "major": "9.6", "minor": 1, "manual": "9.6", "status": "stable", "doc_git": "", "version": "9.6.1", "eol_date": "2021-11-11", "date_text": "2016-10-27", "supported": false, "manual_url": "/docs/9.6/release-9-6-1.html", "source_url": "/docs/release/9.6.1/", "entry_count": 28, "placeholder": false, "content_hash": "6aa262b8cd13b60f2729bfd37a23343ec247aa55bbfbe03889b0cd1ae19ef800", "manual_build": "9.6.24", "source_as_of": "", "changes_count": 28, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.6.X.
\nHowever, if your installation has been affected by the bugs described in the first two changelog entries below, then after updating you may need to take action to repair corrupted free space maps and/or visibility maps.
", "compatibility_count": 0, "label": "9.6.1", "status_label": "Historical", "eol": "2021-11-11", "age_days": 3624, "support_days": -1783, "entries": [{"id": "9.6.1-3182bd69069db480", "cves": [], "html": "Fix WAL-logging of truncation of relation free space maps and visibility maps (Pavan Deolasee, Heikki Linnakangas)
\nIt was possible for these files to not be correctly restored during crash recovery, or to be written incorrectly on a standby server. Bogus entries in a free space map could lead to attempts to access pages that have been truncated away from the relation itself, typically producing errors like \"could not read block XXX: read only 0 of 8192 bytes\". Checksum failures in the visibility map are also possible, if checksumming is enabled.
\nProcedures for determining whether there is a problem and repairing it if so are discussed at https://wiki.postgresql.org/wiki/Free_Space_Map_Problems.
", "text": "Fix WAL-logging of truncation of relation free space maps and visibility maps (Pavan Deolasee, Heikki Linnakangas) It was possible for these files to not be correctly restored during crash recovery, or to be written incorrectly on a standby server. Bogus entries in a free space map could lead to attempts to access pages that have been truncated away from the relation itself, typically producing errors like \"could not read block XXX: read only 0 of 8192 bytes\". Checksum failures in the visibility map are also possible, if checksumming is enabled. Procedures for determining whether there is a problem and repairing it if so are discussed at https://wiki.postgresql.org/wiki/Free_Space_Map_Problems.", "title": "Fix WAL-logging of truncation of relation free space maps and visibility maps", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "cd3ea0102e9a5a4f7116bbedbaf3a4c77cb441af55d076783a92c1e0276104da", "section_path": ["Changes"], "commit_groups": [["142530ef0", "1c02ee314", "2523bef15", "917dc7d23", "b82573d6e"]], "identity_text": "Fix WAL-logging of truncation of relation free space maps and visibility maps (Pavan Deolasee, Heikki Linnakangas) It was possible for these files to not be correctly restored during crash recovery, or to be written incorrectly on a standby server. Bogus entries in a free space map could lead to attempts to access pages that have been truncated away from the relation itself, typically producing errors like could not read block XXX: read only 0 of 8192 bytes. Checksum failures in the visibility map are also possible, if checksumming is enabled. Procedures for determining whether there is a problem and repairing it if so are discussed at .", "commit_aliases": ["142530ef0", "1c02ee314", "2523bef15", "917dc7d23", "b82573d6e"], "source_commits": ["142530ef0"], "source_entry_id": "9.6.1/changes/001", "db_id": "f7aa35ae515033d8874d9c9a6d5aa129", "patch_ids": ["4a3d761dc18937abc8bd445a2277d498"], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734", "relations": [{"rule": 2, "type": "equivalent", "target": "2e98beda261d76d5e2d451d7d589fe76", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}}, {"rule": 2, "type": "equivalent", "target": "b8931467596606ee308ef7bf67015c41", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}}, {"rule": 2, "type": "equivalent", "target": "ec09950c4b42590a3a372f8dbd97440b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}}], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2e98beda261d76d5e2d451d7d589fe76", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix WAL-logging of truncation of relation free space maps and visibility maps", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}, "url": "/docs/compare/?release=9.5.5#9.5.5-3182bd69069db480", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "ec09950c4b42590a3a372f8dbd97440b", "kind": "equivalent", "version": "9.4.10", "label": "9.4.10", "title": "Fix WAL-logging of truncation of relation free space maps and visibility maps", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}, "url": "/docs/compare/?release=9.4.10#9.4.10-3182bd69069db480", "source_url": "/docs/release/9.4.10/#AEN122083"}, {"db_id": "b8931467596606ee308ef7bf67015c41", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Fix WAL-logging of truncation of relation free space maps and visibility maps", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}, "url": "/docs/compare/?release=9.3.15#9.3.15-3182bd69069db480", "source_url": "/docs/release/9.3.15/#AEN116409"}]}, {"id": "9.6.1-4aaf7ea039bb417a", "cves": [], "html": "Fix possible data corruption when pg_upgrade rewrites a relation visibility map into 9.6 format (Tom Lane)
\nOn big-endian machines, bytes of the new visibility map were written in the wrong order, leading to a completely incorrect map. On Windows, the old map was read using text mode, leading to incorrect results if the map happened to contain consecutive bytes that matched a carriage return/line feed sequence. The latter error would almost always lead to a pg_upgrade failure due to the map file appearing to be the wrong length.
\nIf you are using a big-endian machine (many non-Intel architectures are big-endian) and have used pg_upgrade to upgrade from a pre-9.6 release, you should assume that all visibility maps are incorrect and need to be regenerated. It is sufficient to truncate each relation's visibility map with contrib/pg_visibility's pg_truncate_visibility_map() function. For more information see https://wiki.postgresql.org/wiki/Visibility_Map_Problems.
Don't throw serialization errors for self-conflicting insertions in INSERT ... ON CONFLICT (Thomas Munro, Peter Geoghegan)
", "text": "Don't throw serialization errors for self-conflicting insertions in INSERT ... ON CONFLICT (Thomas Munro, Peter Geoghegan)", "title": "Don't throw serialization errors for self-conflicting insertions in INSERT ... ON CONFLICT", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "8768e8184b579541a2a94f5408c8edf7cc2febe951a1ddcff03d5be21a0d72f5", "section_path": ["Changes"], "commit_groups": [["65d85b8f9", "a6c0a5b6e", "c4016fcb1"]], "identity_text": "Don't throw serialization errors for self-conflicting insertions in INSERT ... ON CONFLICT (Thomas Munro, Peter Geoghegan)", "commit_aliases": ["65d85b8f9", "a6c0a5b6e", "c4016fcb1"], "source_commits": ["c4016fcb1"], "source_entry_id": "9.6.1/changes/003", "db_id": "a71c63c6645ce0253391abccc57a5638", "patch_ids": ["a00463c5e71a6404f69027742e6dff70"], "statement_hash": "c127d9cacb2d73f3395dbd9f01f659d1f36652880c92cd494e5d9b8f13a66e3e", "relations": [{"rule": 2, "type": "equivalent", "target": "4925fd02193c528c2bf941a69d416d4a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c127d9cacb2d73f3395dbd9f01f659d1f36652880c92cd494e5d9b8f13a66e3e"}}], "version": "9.6.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "4925fd02193c528c2bf941a69d416d4a", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Don't throw serialization errors for self-conflicting insertions in INSERT ... ON CONFLICT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c127d9cacb2d73f3395dbd9f01f659d1f36652880c92cd494e5d9b8f13a66e3e"}, "url": "/docs/compare/?release=9.5.5#9.5.5-9ca163e88566126e", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.6.1-e05dfe44435e7a5a", "cves": [], "html": "Fix use-after-free hazard in execution of aggregate functions using DISTINCT (Peter Geoghegan)
\nThis could lead to a crash or incorrect query results.
", "text": "Fix use-after-free hazard in execution of aggregate functions using DISTINCT (Peter Geoghegan) This could lead to a crash or incorrect query results.", "title": "Fix use-after-free hazard in execution of aggregate functions using DISTINCT", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "f5df7fa5bdf56cc1f98f098c46d5e67ba635e506beca11409cf3e3ea6754fda7", "section_path": ["Changes"], "commit_groups": [["a5f0bd77a", "d8589946d"]], "identity_text": "Fix use-after-free hazard in execution of aggregate functions using DISTINCT (Peter Geoghegan) This could lead to a crash or incorrect query results.", "commit_aliases": ["a5f0bd77a", "d8589946d"], "source_commits": ["a5f0bd77a"], "source_entry_id": "9.6.1/changes/004", "db_id": "1fe654cc162d25b34a32a148bf4b91e6", "patch_ids": ["7bcf6fcc18a3a99fad3d32b2f8839554"], "statement_hash": "43eb45108dae92f21d12ed088c3683604e49317e165b53896edc403c4f45b233", "relations": [], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.6.1-8d5411812218474a", "cves": [], "html": "Fix incorrect handling of polymorphic aggregates used as window functions (Tom Lane)
\nThe aggregate's transition function was told that its first argument and result were of the aggregate's output type, rather than the state type. This led to errors or crashes with polymorphic transition functions.
", "text": "Fix incorrect handling of polymorphic aggregates used as window functions (Tom Lane) The aggregate's transition function was told that its first argument and result were of the aggregate's output type, rather than the state type. This led to errors or crashes with polymorphic transition functions.", "title": "Fix incorrect handling of polymorphic aggregates used as window functions", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "24b3dc65cc0aeb8a41c36f373f863e54a36d52d8a86c0c771c39de225a527cb5", "section_path": ["Changes"], "commit_groups": [["ac4a9d92f", "dca25c256"]], "identity_text": "Fix incorrect handling of polymorphic aggregates used as window functions (Tom Lane) The aggregate's transition function was told that its first argument and result were of the aggregate's output type, rather than the state type. This led to errors or crashes with polymorphic transition functions.", "commit_aliases": ["ac4a9d92f", "dca25c256"], "source_commits": ["dca25c256"], "source_entry_id": "9.6.1/changes/005", "db_id": "07907458595e08b42a2fe02357e5c7ee", "patch_ids": ["2db20fa516cd2450acb901a23cf0ce01"], "statement_hash": "0abcc2fd9a49db54d85da9060280029f7107eae04a71a2ee136239662a4924b2", "relations": [], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.6.1-62893f6d124a3ae8", "cves": [], "html": "Fix COPY with a column name list from a table that has row-level security enabled (Adam Brightwell)
", "text": "Fix COPY with a column name list from a table that has row-level security enabled (Adam Brightwell)", "title": "Fix COPY with a column name list from a table that has row-level security enabled", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "2fccf0535f2521e5288f8420b32aa65453629ac1b0ba31446675e4ce334f8217", "section_path": ["Changes"], "commit_groups": [["190765a05", "647a86e37", "814b9e9b8"]], "identity_text": "Fix COPY with a column name list from a table that has row-level security enabled (Adam Brightwell)", "commit_aliases": ["190765a05", "647a86e37", "814b9e9b8"], "source_commits": ["190765a05"], "source_entry_id": "9.6.1/changes/006", "db_id": "67d5ac0ca5a3eed110d770ca22cc9e1c", "patch_ids": ["1d627f4a58bc5427a277f089f6667fbc"], "statement_hash": "c9b07a2acda4ca684db76cc1fba42bb9a4718b98ff9e024dd532efc56ca477bc", "relations": [{"rule": 2, "type": "equivalent", "target": "d899869d00de43211c7aa6d89fbe38c8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c9b07a2acda4ca684db76cc1fba42bb9a4718b98ff9e024dd532efc56ca477bc"}}], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d899869d00de43211c7aa6d89fbe38c8", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix COPY with a column name list from a table that has row-level security enabled", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c9b07a2acda4ca684db76cc1fba42bb9a4718b98ff9e024dd532efc56ca477bc"}, "url": "/docs/compare/?release=9.5.5#9.5.5-62893f6d124a3ae8", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.6.1-353e840feef16b9a", "cves": [], "html": "Fix EXPLAIN to emit valid XML when track_io_timing is on (Markus Winand)
\nPreviously the XML output-format option produced syntactically invalid tags such as <I/O-Read-Time>. That is now rendered as <I-O-Read-Time>.
", "text": "Fix EXPLAIN to emit valid XML when track_io_timing is on (Markus Winand) Previously the XML output-format option produced syntactically invalid tags such as . That is now rendered asFix statistics update for TRUNCATE in a prepared transaction (Stas Kelvich)
", "text": "Fix statistics update for TRUNCATE in a prepared transaction (Stas Kelvich)", "title": "Fix statistics update for TRUNCATE in a prepared transaction", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "8d6380e3dc5b2c6ff31ec270aebc794f71ae1ca6c44406908afa082116824c0a", "section_path": ["Changes"], "commit_groups": [["03f2bf70a", "3cd504254", "81e82a2bd"]], "identity_text": "Fix statistics update for TRUNCATE in a prepared transaction (Stas Kelvich)", "commit_aliases": ["03f2bf70a", "3cd504254", "81e82a2bd"], "source_commits": ["03f2bf70a"], "source_entry_id": "9.6.1/changes/008", "db_id": "449a2512af576a09b3bdfd593f77d9cb", "patch_ids": ["f1e9112301fef7d8455574626b453033"], "statement_hash": "981c2e6e7c8d983c70c6a0235524fe9f7c0dbbc00a2fcc63122610d97574d8d4", "relations": [{"rule": 2, "type": "equivalent", "target": "4f00adb909846432c51419a45c9a5479", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "981c2e6e7c8d983c70c6a0235524fe9f7c0dbbc00a2fcc63122610d97574d8d4"}}], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4f00adb909846432c51419a45c9a5479", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix statistics update for TRUNCATE in a prepared transaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "981c2e6e7c8d983c70c6a0235524fe9f7c0dbbc00a2fcc63122610d97574d8d4"}, "url": "/docs/compare/?release=9.5.5#9.5.5-a31f92e4fc6df708", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.6.1-c92ac7bad376f3b4", "cves": [], "html": "Fix bugs in merging inherited CHECK constraints while creating or altering a table (Tom Lane, Amit Langote)
\nAllow identical CHECK constraints to be added to a parent and child table in either order. Prevent merging of a valid constraint from the parent table with a NOT VALID constraint on the child. Likewise, prevent merging of a NO INHERIT child constraint with an inherited constraint.
", "text": "Fix bugs in merging inherited CHECK constraints while creating or altering a table (Tom Lane, Amit Langote) Allow identical CHECK constraints to be added to a parent and child table in either order. Prevent merging of a valid constraint from the parent table with a NOT VALID constraint on the child. Likewise, prevent merging of a NO INHERIT child constraint with an inherited constraint.", "title": "Fix bugs in merging inherited CHECK constraints while creating or altering a table", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "9e0aa396bbf22322bcc9b91a4a4dc5875617343e5cf728b26d24abec5f43cafa", "section_path": ["Changes"], "commit_groups": [["12230c478", "56a047f46", "a54faa659", "b605aeba0", "d1a9f128d", "e55a946a8"], ["3217ac3a9", "3cca13cbf", "6f2db29ec", "f0bf0f233", "f2024d59a", "f9e8b05e5"]], "identity_text": "Fix bugs in merging inherited CHECK constraints while creating or altering a table (Tom Lane, Amit Langote) Allow identical CHECK constraints to be added to a parent and child table in either order. Prevent merging of a valid constraint from the parent table with a NOT VALID constraint on the child. Likewise, prevent merging of a NO INHERIT child constraint with an inherited constraint.", "commit_aliases": ["12230c478", "3217ac3a9", "3cca13cbf", "56a047f46", "6f2db29ec", "a54faa659", "b605aeba0", "d1a9f128d", "e55a946a8", "f0bf0f233", "f2024d59a", "f9e8b05e5"], "source_commits": ["b605aeba0", "f9e8b05e5"], "source_entry_id": "9.6.1/changes/009", "db_id": "820976eee5d0d58fc24e6faef69ef024", "patch_ids": ["7855b05750225fc106ea8dbc42e37eb2", "7c1d3ebdad386a3a1549a646ddd79b86"], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a", "relations": [{"rule": 2, "type": "equivalent", "target": "17c3b5c88a4e18eeb9db0d79f1bd4738", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}}, {"rule": 2, "type": "equivalent", "target": "864da9828cbc9dedf3a48fbb88838d2c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}}, {"rule": 2, "type": "equivalent", "target": "cf4210aa72e5ceb04465bf6396e92fd3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}}, {"rule": 2, "type": "equivalent", "target": "d0ba967b9080e8d3d7c374af62b71ddc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}}], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d0ba967b9080e8d3d7c374af62b71ddc", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix bugs in merging inherited CHECK constraints while creating or altering a table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}, "url": "/docs/compare/?release=9.5.5#9.5.5-c92ac7bad376f3b4", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "864da9828cbc9dedf3a48fbb88838d2c", "kind": "equivalent", "version": "9.4.10", "label": "9.4.10", "title": "Fix bugs in merging inherited CHECK constraints while creating or altering a table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}, "url": "/docs/compare/?release=9.4.10#9.4.10-c92ac7bad376f3b4", "source_url": "/docs/release/9.4.10/#AEN122083"}, {"db_id": "cf4210aa72e5ceb04465bf6396e92fd3", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Fix bugs in merging inherited CHECK constraints while creating or altering a table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}, "url": "/docs/compare/?release=9.3.15#9.3.15-c92ac7bad376f3b4", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "17c3b5c88a4e18eeb9db0d79f1bd4738", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Fix bugs in merging inherited CHECK constraints while creating or altering a table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}, "url": "/docs/compare/?release=9.2.19#9.2.19-c92ac7bad376f3b4", "source_url": "/docs/release/9.2.19/#AEN111404"}]}, {"id": "9.6.1-635c715fa6df1254", "cves": [], "html": "Show a sensible value in pg_settings.unit for min_wal_size and max_wal_size (Tom Lane)
", "text": "Show a sensible value in pg_settings.unit for min_wal_size and max_wal_size (Tom Lane)", "title": "Show a sensible value in pg_settings.unit for min_wal_size and max_wal_size", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "3f13b0bc3ca897bf29ed2c8f4adb48026656999b50559ed1f27bf55a6648a8c3", "section_path": ["Changes"], "commit_groups": [["6bc811c99", "993d94c59", "f50fa46cc"]], "identity_text": "Show a sensible value in pg_settings.unit for min_wal_size and max_wal_size (Tom Lane)", "commit_aliases": ["6bc811c99", "993d94c59", "f50fa46cc"], "source_commits": ["993d94c59"], "source_entry_id": "9.6.1/changes/010", "db_id": "b0badb4d8e0ca5c536eb7fe9efed9439", "patch_ids": ["23e8fab3206c2aa11d48ee35b6a0388e"], "statement_hash": "11bd97214d153c36ec602bba6c569b4e9a227dbcf57d661037d3acf23019a5c6", "relations": [{"rule": 2, "type": "equivalent", "target": "b74c3b34bd426427dbb634addc6f069f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "11bd97214d153c36ec602bba6c569b4e9a227dbcf57d661037d3acf23019a5c6"}}], "version": "9.6.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b74c3b34bd426427dbb634addc6f069f", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Show a sensible value in pg_settings.unit for min_wal_size and max_wal_size", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "11bd97214d153c36ec602bba6c569b4e9a227dbcf57d661037d3acf23019a5c6"}, "url": "/docs/compare/?release=9.5.5#9.5.5-635c715fa6df1254", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.6.1-3239937a414d840f", "cves": [], "html": "Fix replacement of array elements in jsonb_set() (Tom Lane)
If the target is an existing JSON array element, it got deleted instead of being replaced with a new value.
", "text": "Fix replacement of array elements in jsonb_set() (Tom Lane) If the target is an existing JSON array element, it got deleted instead of being replaced with a new value.", "title": "Fix replacement of array elements in jsonb_set()", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "7d5c7afa90a73d29e9f10028da9c81d5f8d2eb0703b1e35140ea5dee3a8b0870", "section_path": ["Changes"], "commit_groups": [["0e9e64c07", "9c4cc9e2c"]], "identity_text": "Fix replacement of array elements in jsonb_set() (Tom Lane) If the target is an existing JSON array element, it got deleted instead of being replaced with a new value.", "commit_aliases": ["0e9e64c07", "9c4cc9e2c"], "source_commits": ["0e9e64c07"], "source_entry_id": "9.6.1/changes/011", "db_id": "11e3dd2c6235912220fcbea99115b5f2", "patch_ids": ["34d6cbefd12e68c1ffe120d78e8914ac"], "statement_hash": "da0657c9b7214eb1a3d332aaf30672104d1babbc3529dd136c0d0fd2054b5f87", "relations": [], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.6.1-e29f106759f1d612", "cves": [], "html": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock (Thomas Munro, Peter Geoghegan, Tom Lane)
", "text": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock (Thomas Munro, Peter Geoghegan, Tom Lane)", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "f6707b5ec6072a51de6a2209466027bacabc8eff011e822827834c86feae0d8e", "section_path": ["Changes"], "commit_groups": [["5beb73b49", "6292c2339", "676c60375", "913e7e598", "9bc01e7a4", "9ec21591f", "d4fa18a55"], ["8f1fb7d62", "beac79369", "fdcee9f1f"]], "identity_text": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock (Thomas Munro, Peter Geoghegan, Tom Lane)", "commit_aliases": ["5beb73b49", "6292c2339", "676c60375", "8f1fb7d62", "913e7e598", "9bc01e7a4", "9ec21591f", "beac79369", "d4fa18a55", "fdcee9f1f"], "source_commits": ["5beb73b49", "fdcee9f1f"], "source_entry_id": "9.6.1/changes/012", "db_id": "faba4ef996319c8db73db30748abf489", "patch_ids": ["a6b7e34970060495328385d27c213a3c", "c0908100272a961771a5c51c610c7cb0"], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37", "relations": [{"rule": 2, "type": "equivalent", "target": "53b0b52d899de881f8586469efa7f5aa", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}}, {"rule": 2, "type": "equivalent", "target": "6ca408c5775b0169d72f4bf6b3f53cbe", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}}, {"rule": 2, "type": "equivalent", "target": "ae85002bd79a9c04b168f6dc9ace9ce5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}}, {"rule": 2, "type": "equivalent", "target": "f765abee4edf5f8c07e5c00859b6aef5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}}, {"rule": 2, "type": "equivalent", "target": "fec739de452ca83cbdf70ca3235da08b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}}], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "fec739de452ca83cbdf70ca3235da08b", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}, "url": "/docs/compare/?release=9.5.5#9.5.5-e29f106759f1d612", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "53b0b52d899de881f8586469efa7f5aa", "kind": "equivalent", "version": "9.4.10", "label": "9.4.10", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}, "url": "/docs/compare/?release=9.4.10#9.4.10-e29f106759f1d612", "source_url": "/docs/release/9.4.10/#AEN122083"}, {"db_id": "f765abee4edf5f8c07e5c00859b6aef5", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}, "url": "/docs/compare/?release=9.3.15#9.3.15-e29f106759f1d612", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "6ca408c5775b0169d72f4bf6b3f53cbe", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}, "url": "/docs/compare/?release=9.2.19#9.2.19-e29f106759f1d612", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "ae85002bd79a9c04b168f6dc9ace9ce5", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}, "url": "/docs/compare/?release=9.1.24#9.1.24-e29f106759f1d612", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.6.1-63f49e1cd1bebb94", "cves": [], "html": "Preserve commit timestamps across server restart (Julien Rouhaud, Craig Ringer)
\nWith track_commit_timestamp turned on, old commit timestamps became inaccessible after a clean server restart.
", "text": "Preserve commit timestamps across server restart (Julien Rouhaud, Craig Ringer) With track_commit_timestamp turned on, old commit timestamps became inaccessible after a clean server restart.", "title": "Preserve commit timestamps across server restart", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "717b3358cac01b334e4ce7e2a7b760c54f07722d773bb5d6d2374d7bf7fe4f0b", "section_path": ["Changes"], "commit_groups": [["00f15338b", "7a2fa5774", "c8329f934"]], "identity_text": "Preserve commit timestamps across server restart (Julien Rouhaud, Craig Ringer) With guc-track-commit-timestamp turned on, old commit timestamps became inaccessible after a clean server restart.", "commit_aliases": ["00f15338b", "7a2fa5774", "c8329f934"], "source_commits": ["c8329f934"], "source_entry_id": "9.6.1/changes/013", "db_id": "1953461365bff77eb10e05f6b4eef6da", "patch_ids": ["6e5a5ee1506bd3492da1a6854d295621"], "statement_hash": "548c5da096bd7ac5055abf5ddce51bb4c7220f0786d51a4320c3a10d0236da0e", "relations": [{"rule": 2, "type": "equivalent", "target": "06691e7afa92b25002b15fe22317c5c3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "548c5da096bd7ac5055abf5ddce51bb4c7220f0786d51a4320c3a10d0236da0e"}}], "version": "9.6.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "06691e7afa92b25002b15fe22317c5c3", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Preserve commit timestamps across server restart", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "548c5da096bd7ac5055abf5ddce51bb4c7220f0786d51a4320c3a10d0236da0e"}, "url": "/docs/compare/?release=9.5.5#9.5.5-63f49e1cd1bebb94", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.6.1-588c3e1995825d77", "cves": [], "html": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk (Andres Freund)
", "text": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk (Andres Freund)", "title": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "f6fb6f26440f6bca01f32e2bbb578ee5790d78210517c23629e8904c5c397548", "section_path": ["Changes"], "commit_groups": [["07172b20f", "61633f790", "76c0b73df", "ce603a34a"]], "identity_text": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk (Andres Freund)", "commit_aliases": ["07172b20f", "61633f790", "76c0b73df", "ce603a34a"], "source_commits": ["76c0b73df"], "source_entry_id": "9.6.1/changes/014", "db_id": "7fbb078e2be4bbd5ba0ce87dfe2ac2b2", "patch_ids": ["a6f377cf73f521524477669681b5d062"], "statement_hash": "fb79dd6fa77aee0939f4bd03a29e002dc5b2c387280a8afe3431ec8d2cdb5550", "relations": [{"rule": 2, "type": "equivalent", "target": "470a039e7a7d709e873acc07b7315fed", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fb79dd6fa77aee0939f4bd03a29e002dc5b2c387280a8afe3431ec8d2cdb5550"}}, {"rule": 2, "type": "equivalent", "target": "523527d73ae0b1bd4d93ce8d8679d2ff", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fb79dd6fa77aee0939f4bd03a29e002dc5b2c387280a8afe3431ec8d2cdb5550"}}], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "470a039e7a7d709e873acc07b7315fed", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fb79dd6fa77aee0939f4bd03a29e002dc5b2c387280a8afe3431ec8d2cdb5550"}, "url": "/docs/compare/?release=9.5.5#9.5.5-588c3e1995825d77", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "523527d73ae0b1bd4d93ce8d8679d2ff", "kind": "equivalent", "version": "9.4.10", "label": "9.4.10", "title": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fb79dd6fa77aee0939f4bd03a29e002dc5b2c387280a8afe3431ec8d2cdb5550"}, "url": "/docs/compare/?release=9.4.10#9.4.10-588c3e1995825d77", "source_url": "/docs/release/9.4.10/#AEN122083"}]}, {"id": "9.6.1-2ad5a023d17f9e9e", "cves": [], "html": "Fix dangling-pointer problem in logical WAL decoding (Stas Kelvich)
", "text": "Fix dangling-pointer problem in logical WAL decoding (Stas Kelvich)", "title": "Fix dangling-pointer problem in logical WAL decoding", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "6a0f187e1ee12aafb9542424d59ca8f3abd59a332159025e992ee824c10b28e6", "section_path": ["Changes"], "commit_groups": [["308985b0b", "32841fa32"]], "identity_text": "Fix dangling-pointer problem in logical WAL decoding (Stas Kelvich)", "commit_aliases": ["308985b0b", "32841fa32"], "source_commits": ["32841fa32"], "source_entry_id": "9.6.1/changes/015", "db_id": "d773713b8973e28cbff69d2411f617f2", "patch_ids": ["03b8b132f63fa097f8866093ec86daec"], "statement_hash": "8f99283977240483bd34c4b532bc8b56b64c78ef3ef2f9dac36f726156a52e07", "relations": [], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.6.1-6eb27c2c26383bc7", "cves": [], "html": "Round shared-memory allocation request to a multiple of the actual huge page size when attempting to use huge pages on Linux (Tom Lane)
\nThis avoids possible failures during munmap() on systems with atypical default huge page sizes. Except in crash-recovery cases, there were no ill effects other than a log message.
Don't try to share SSL contexts across multiple connections in libpq (Heikki Linnakangas)
\nThis led to assorted corner-case bugs, particularly when trying to use different SSL parameters for different connections.
", "text": "Don't try to share SSL contexts across multiple connections in libpq (Heikki Linnakangas) This led to assorted corner-case bugs, particularly when trying to use different SSL parameters for different connections.", "title": "Don't try to share SSL contexts across multiple connections in libpq", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "9a783fabe16a049fa9ace146697dd7e9af28990fb9fd36178132f7bd1bdffdd6", "section_path": ["Changes"], "commit_groups": [["275bf9860", "418cd758a", "4d3ecbfee", "5d5dc6f68", "b5afc6f67", "e84e4761f", "f0ca54037"], ["31895abd8", "341acf235", "8bb14cdd3", "cb38c056f", "e76d06d7f", "e7bb327e3", "fde92dc22"]], "identity_text": "Don't try to share SSL contexts across multiple connections in libpq (Heikki Linnakangas) This led to assorted corner-case bugs, particularly when trying to use different SSL parameters for different connections.", "commit_aliases": ["275bf9860", "31895abd8", "341acf235", "418cd758a", "4d3ecbfee", "5d5dc6f68", "8bb14cdd3", "b5afc6f67", "cb38c056f", "e76d06d7f", "e7bb327e3", "e84e4761f", "f0ca54037", "fde92dc22"], "source_commits": ["341acf235", "4d3ecbfee"], "source_entry_id": "9.6.1/changes/017", "db_id": "e4e858812dc39cda82cd0c879258e22e", "patch_ids": ["6d07f687a957bae95986b84853de4d75", "c0f9044dfee54804bcebcc33e87743a9"], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679", "relations": [{"rule": 2, "type": "equivalent", "target": "5797a86f9ccff5c9d9bc62cededb71ea", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}}, {"rule": 2, "type": "equivalent", "target": "6cf72552733f502b0431bb9d9b3679f7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}}, {"rule": 2, "type": "equivalent", "target": "78f23bf21615092d97ff903e3cbe4886", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}}, {"rule": 2, "type": "equivalent", "target": "8e470a25f92f8433de8ca041850612c3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}}, {"rule": 2, "type": "equivalent", "target": "dd8ac44910aec9313eac765230d29672", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}}], "version": "9.6.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "78f23bf21615092d97ff903e3cbe4886", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Don't try to share SSL contexts across multiple connections in libpq", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}, "url": "/docs/compare/?release=9.5.5#9.5.5-6d29334411af4cef", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "6cf72552733f502b0431bb9d9b3679f7", "kind": "equivalent", "version": "9.4.10", "label": "9.4.10", "title": "Don't try to share SSL contexts across multiple connections in libpq", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}, "url": "/docs/compare/?release=9.4.10#9.4.10-6d29334411af4cef", "source_url": "/docs/release/9.4.10/#AEN122083"}, {"db_id": "8e470a25f92f8433de8ca041850612c3", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Don't try to share SSL contexts across multiple connections in libpq", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}, "url": "/docs/compare/?release=9.3.15#9.3.15-6d29334411af4cef", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "dd8ac44910aec9313eac765230d29672", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Don't try to share SSL contexts across multiple connections in libpq", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}, "url": "/docs/compare/?release=9.2.19#9.2.19-6d29334411af4cef", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "5797a86f9ccff5c9d9bc62cededb71ea", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Don't try to share SSL contexts across multiple connections in libpq", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}, "url": "/docs/compare/?release=9.1.24#9.1.24-6d29334411af4cef", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.6.1-146da81fa7fafcdd", "cves": [], "html": "Avoid corner-case memory leak in libpq (Tom Lane)
\nThe reported problem involved leaking an error report during PQreset(), but there might be related cases.
In pg_upgrade, check library loadability in name order (Tom Lane)
\nThis is a workaround to deal with cross-extension dependencies from language transform modules to their base language and data type modules.
", "text": "In pg_upgrade, check library loadability in name order (Tom Lane) This is a workaround to deal with cross-extension dependencies from language transform modules to their base language and data type modules.", "title": "In pg_upgrade, check library loadability in name order", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "6b8b51700dfb19137611c4fc0074f4c5bd3db5da68ef6fb53f793897299ebd6c", "section_path": ["Changes"], "commit_groups": [["0f259bd17", "83c249200", "bac56dbe0"]], "identity_text": "In pg_upgrade, check library loadability in name order (Tom Lane) This is a workaround to deal with cross-extension dependencies from language transform modules to their base language and data type modules.", "commit_aliases": ["0f259bd17", "83c249200", "bac56dbe0"], "source_commits": ["bac56dbe0"], "source_entry_id": "9.6.1/changes/019", "db_id": "12de532a4d03ab8b387c350843f97d71", "patch_ids": ["143a51a4498ceaf187856219e2513b15"], "statement_hash": "f47bceb14c4d2e496af2425b01d3ae642b028c3177f543cea70359c0cc7cd392", "relations": [{"rule": 2, "type": "equivalent", "target": "57611a54226b885c63c5665a32fc0143", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f47bceb14c4d2e496af2425b01d3ae642b028c3177f543cea70359c0cc7cd392"}}], "version": "9.6.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "57611a54226b885c63c5665a32fc0143", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "In pg_upgrade, check library loadability in name order", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f47bceb14c4d2e496af2425b01d3ae642b028c3177f543cea70359c0cc7cd392"}, "url": "/docs/compare/?release=9.5.5#9.5.5-88f92a497ba1661b", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.6.1-9452120138fc24b2", "cves": [], "html": "Fix pg_upgrade to work correctly for extensions containing index access methods (Tom Lane)
\nTo allow this, the server has been extended to support ALTER EXTENSION ADD/DROP ACCESS METHOD. That functionality should have been included in the original patch to support dynamic creation of access methods, but it was overlooked.
", "text": "Fix pg_upgrade to work correctly for extensions containing index access methods (Tom Lane) To allow this, the server has been extended to support ALTER EXTENSION ADD/DROP ACCESS METHOD. That functionality should have been included in the original patch to support dynamic creation of access methods, but it was overlooked.", "title": "Fix pg_upgrade to work correctly for extensions containing index access methods", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "72252c4c7b4b39246dcfc84821516717a459b5d691f808cbe453b39881340ce4", "section_path": ["Changes"], "commit_groups": [["e8bdee277", "f40334b85"]], "identity_text": "Fix pg_upgrade to work correctly for extensions containing index access methods (Tom Lane) To allow this, the server has been extended to support ALTER EXTENSION ADD/DROP ACCESS METHOD. That functionality should have been included in the original patch to support dynamic creation of access methods, but it was overlooked.", "commit_aliases": ["e8bdee277", "f40334b85"], "source_commits": ["f40334b85"], "source_entry_id": "9.6.1/changes/020", "db_id": "518f006ecede4cc40514e319a50a7602", "patch_ids": ["66981347b5741768068a955da1862687"], "statement_hash": "c65dca63da7da38b8127977d82fc9825052dc39f8d1066a014947e1d9adfa035", "relations": [], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.6.1-1f5c31af96bc0fc1", "cves": [], "html": "Improve error reporting in pg_upgrade's file copying/linking/rewriting steps (Tom Lane, Álvaro Herrera)
", "text": "Improve error reporting in pg_upgrade's file copying/linking/rewriting steps (Tom Lane, Álvaro Herrera)", "title": "Improve error reporting in pg_upgrade's file copying/linking/rewriting steps", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "b1dbfb0dbf8cb68e0a8ea75abac24f532053c64f5bebf95bfae9969de5b6ce49", "section_path": ["Changes"], "commit_groups": [["53fbeed40", "f002ed2b8"]], "identity_text": "Improve error reporting in pg_upgrade's file copying/linking/rewriting steps (Tom Lane, Álvaro Herrera)", "commit_aliases": ["53fbeed40", "f002ed2b8"], "source_commits": ["53fbeed40"], "source_entry_id": "9.6.1/changes/021", "db_id": "fee3522ca1f71cd479dc03a5aaaf10c7", "patch_ids": ["0e093787fc6da0e946d7e7e75633446f"], "statement_hash": "88710a199795da7a78e56ab74a820a1d22ee8d5975e5d9a4ee7e16684f3d14f0", "relations": [], "version": "9.6.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.6.1-f7cb3fa02fa0a625", "cves": [], "html": "Fix pg_dump to work against pre-7.4 servers (Amit Langote, Tom Lane)
", "text": "Fix pg_dump to work against pre-7.4 servers (Amit Langote, Tom Lane)", "title": "Fix pg_dump to work against pre-7.4 servers", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "b93fc621b006268495152aaa9475c4e0337c5154c3bb450b8edf214b5e08f18c", "section_path": ["Changes"], "commit_groups": [["1749332ec", "4806f26f9"]], "identity_text": "Fix pg_dump to work against pre-7.4 servers (Amit Langote, Tom Lane)", "commit_aliases": ["1749332ec", "4806f26f9"], "source_commits": ["1749332ec"], "source_entry_id": "9.6.1/changes/022", "db_id": "31be2dc7eda2bbf9167d30a3204efd57", "patch_ids": ["52a026c5212c6166fd56570cbb9ab09d"], "statement_hash": "6b2038238e0e18770e36095e1d60ebff4cd1390cd171a2480c0e4ff799c31d04", "relations": [], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.6.1-bacd75fa3d39bf1c", "cves": [], "html": "Disallow specifying both --source-server and --source-target options to pg_rewind (Michael Banck)
", "text": "Disallow specifying both --source-server and --source-target options to pg_rewind (Michael Banck)", "title": "Disallow specifying both --source-server and --source-target options to pg_rewind", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "8da7250010fe643598baa146fff80d574a16231c06dd68c4bffe066fa130ac00", "section_path": ["Changes"], "commit_groups": [["010a1b561", "0d4d7d618", "2933ed036"]], "identity_text": "Disallow specifying both --source-server and --source-target options to pg_rewind (Michael Banck)", "commit_aliases": ["010a1b561", "0d4d7d618", "2933ed036"], "source_commits": ["2933ed036"], "source_entry_id": "9.6.1/changes/023", "db_id": "720aaed0b0fe82f4a1fe19af56f7f35b", "patch_ids": ["8c9a121091a8dd75709d26ae4de7eb74"], "statement_hash": "3678e4d3b7cfd2a84248583069e282d985c52f2ac862c42359d8931c0d2ad75a", "relations": [{"rule": 2, "type": "equivalent", "target": "cb5ee804d395c324d54e6742ab5e786d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3678e4d3b7cfd2a84248583069e282d985c52f2ac862c42359d8931c0d2ad75a"}}], "version": "9.6.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "cb5ee804d395c324d54e6742ab5e786d", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Disallow specifying both --source-server and --source-target options to pg_rewind", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3678e4d3b7cfd2a84248583069e282d985c52f2ac862c42359d8931c0d2ad75a"}, "url": "/docs/compare/?release=9.5.5#9.5.5-bacd75fa3d39bf1c", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.6.1-404ee9669eb60178", "cves": [], "html": "Make pg_rewind turn off synchronous_commit in its session on the source server (Michael Banck, Michael Paquier)
\nThis allows pg_rewind to work even when the source server is using synchronous replication that is not working for some reason.
", "text": "Make pg_rewind turn off synchronous_commit in its session on the source server (Michael Banck, Michael Paquier) This allows pg_rewind to work even when the source server is using synchronous replication that is not working for some reason.", "title": "Make pg_rewind turn off synchronous_commit in its session on the source server", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "8ab5a72c3c859063f7e84c09172eea9433b25b883cc61115063211e789eb822c", "section_path": ["Changes"], "commit_groups": [["69da71254", "aab809664", "d7eb76b90"]], "identity_text": "Make pg_rewind turn off synchronous_commit in its session on the source server (Michael Banck, Michael Paquier) This allows pg_rewind to work even when the source server is using synchronous replication that is not working for some reason.", "commit_aliases": ["69da71254", "aab809664", "d7eb76b90"], "source_commits": ["aab809664"], "source_entry_id": "9.6.1/changes/024", "db_id": "3d9d07da8611979828974a00f7d5e93c", "patch_ids": ["bb6525a8530a405fc406be369c4b5701"], "statement_hash": "176ffbc55a3881d1812fea12b4236f6ad61a4ed1550d0c96b66db74baf855119", "relations": [{"rule": 2, "type": "equivalent", "target": "7cdbd79a62155689cca1ba178c38ea83", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "176ffbc55a3881d1812fea12b4236f6ad61a4ed1550d0c96b66db74baf855119"}}], "version": "9.6.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "7cdbd79a62155689cca1ba178c38ea83", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Make pg_rewind turn off synchronous_commit in its session on the source server", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "176ffbc55a3881d1812fea12b4236f6ad61a4ed1550d0c96b66db74baf855119"}, "url": "/docs/compare/?release=9.5.5#9.5.5-404ee9669eb60178", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.6.1-d6c2b719b3c71ef8", "cves": [], "html": "In pg_xlogdump, retry opening new WAL segments when using --follow option (Magnus Hagander)
\nThis allows for a possible delay in the server's creation of the next segment.
", "text": "In pg_xlogdump, retry opening new WAL segments when using --follow option (Magnus Hagander) This allows for a possible delay in the server's creation of the next segment.", "title": "In pg_xlogdump, retry opening new WAL segments when using --follow option", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "b16041b4f315e4e2830e4d9d4ce39d834cec962b9f2d1c844c985034c5fa1c83", "section_path": ["Changes"], "commit_groups": [["3d39244e6", "41d58e97a", "4bff35cca", "d8b4c3490", "da3f71a08"]], "identity_text": "In pg_xlogdump, retry opening new WAL segments when using --follow option (Magnus Hagander) This allows for a possible delay in the server's creation of the next segment.", "commit_aliases": ["3d39244e6", "41d58e97a", "4bff35cca", "d8b4c3490", "da3f71a08"], "source_commits": ["41d58e97a"], "source_entry_id": "9.6.1/changes/025", "db_id": "76feb8e100587752206df4baba988197", "patch_ids": ["418ead167b9504a96b1556a13a9d1b27"], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a", "relations": [{"rule": 2, "type": "equivalent", "target": "2113e3ca11fc4e23dbedd995bafef047", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}}, {"rule": 2, "type": "equivalent", "target": "95a5bd12885de7f441144ce2c9527398", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}}, {"rule": 2, "type": "equivalent", "target": "f2af211971ec3653a813cd132d95e373", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}}], "version": "9.6.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "2113e3ca11fc4e23dbedd995bafef047", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "In pg_xlogdump, retry opening new WAL segments when using --follow option", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}, "url": "/docs/compare/?release=9.5.5#9.5.5-d6c2b719b3c71ef8", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "95a5bd12885de7f441144ce2c9527398", "kind": "equivalent", "version": "9.4.10", "label": "9.4.10", "title": "In pg_xlogdump, retry opening new WAL segments when using --follow option", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}, "url": "/docs/compare/?release=9.4.10#9.4.10-d6c2b719b3c71ef8", "source_url": "/docs/release/9.4.10/#AEN122083"}, {"db_id": "f2af211971ec3653a813cd132d95e373", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "In pg_xlogdump, retry opening new WAL segments when using --follow option", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}, "url": "/docs/compare/?release=9.3.15#9.3.15-d6c2b719b3c71ef8", "source_url": "/docs/release/9.3.15/#AEN116409"}]}, {"id": "9.6.1-66fefced16aac3f6", "cves": [], "html": "Fix contrib/pg_visibility to report the correct TID for a corrupt tuple that has been the subject of a rolled-back update (Tom Lane)
", "text": "Fix contrib/pg_visibility to report the correct TID for a corrupt tuple that has been the subject of a rolled-back update (Tom Lane)", "title": "Fix contrib/pg_visibility to report the correct TID for a corrupt tuple that has been the subject of a rolled-back update", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "df919fd6c492843c8fcf6b6b56d0ae1fcd4b12eb53b4efac6367c53553696a55", "section_path": ["Changes"], "commit_groups": [["9a109452d", "f4e787c82"]], "identity_text": "Fix contrib/pg_visibility to report the correct TID for a corrupt tuple that has been the subject of a rolled-back update (Tom Lane)", "commit_aliases": ["9a109452d", "f4e787c82"], "source_commits": ["f4e787c82"], "source_entry_id": "9.6.1/changes/026", "db_id": "0c2649d3d76573cd13e1ef3577805798", "patch_ids": ["0a67daf6c7dbd88647b1fcbd809db557"], "statement_hash": "dac0f72a0e66b3b4a8a732a79997163afe9f5027e5cf11dce37c04e8c7d1934b", "relations": [], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.6.1-e5718f978abd9258", "cves": [], "html": "Fix makefile dependencies so that parallel make of PL/Python by itself will succeed reliably (Pavel Raiskup)
", "text": "Fix makefile dependencies so that parallel make of PL/Python by itself will succeed reliably (Pavel Raiskup)", "title": "Fix makefile dependencies so that parallel make of PL/Python by itself will succeed reliably", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "2343dbb157474ba33513348513dcb3fb75bb3977c22081a5e458db5d555fbdac", "section_path": ["Changes"], "commit_groups": [["68fb75e10", "7107d58ec"]], "identity_text": "Fix makefile dependencies so that parallel make of PL/Python by itself will succeed reliably (Pavel Raiskup)", "commit_aliases": ["68fb75e10", "7107d58ec"], "source_commits": ["68fb75e10"], "source_entry_id": "9.6.1/changes/027", "db_id": "556b8d4b860a9c00df17e533a146a4f8", "patch_ids": ["e581315ac4f077aa3ca8b40204845cba"], "statement_hash": "81bd9b169a4990c987c4808435e1b86421c68f85203c6a47e072e2c0caa34d07", "relations": [], "version": "9.6.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.6.1-8f8c191547e6f04d", "cves": [], "html": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.
\nThe IANA time zone database previously provided textual abbreviations for all time zones, sometimes making up abbreviations that have little or no currency among the local population. They are in process of reversing that policy in favor of using numeric UTC offsets in zones where there is no evidence of real-world use of an English abbreviation. At least for the time being, PostgreSQL will continue to accept such removed abbreviations for timestamp input. But they will not be shown in the pg_timezone_names view nor used for output.
\nIn this update, AMT is no longer shown as being in use to mean Armenia Time. Therefore, we have changed the Default abbreviation set to interpret it as Amazon Time, thus UTC-4 not UTC+4.
", "text": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka. The IANA time zone database previously provided textual abbreviations for all time zones, sometimes making up abbreviations that have little or no currency among the local population. They are in process of reversing that policy in favor of using numeric UTC offsets in zones where there is no evidence of real-world use of an English abbreviation. At least for the time being, PostgreSQL will continue to accept such removed abbreviations for timestamp input. But they will not be shown in the pg_timezone_names view nor used for output. In this update, AMT is no longer shown as being in use to mean Armenia Time. Therefore, we have changed the Default abbreviation set to interpret it as Amazon Time, thus UTC-4 not UTC+4.", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.1/#AEN136022", "source_hash": "f56c53a55af7cc864afc603e943b32517cfcd9ffeca49ebfcf58ca78dcce6fba", "section_path": ["Changes"], "commit_groups": [["0c2f4c54c", "22cf97635", "5508d0c0b", "7abda82ef", "9727dac58", "a03339aef", "ecbac3e6e"], ["1d388ba2c", "3c5fae786", "80ba149b0", "8cddedc17", "9345bf08c", "d8fc45bd0", "ff68f434f"], ["2877b102e", "381c4b03b", "66adeefda", "7fec5e101", "ad6f67179", "bc59c1236", "f3094920a"], ["37ecf07d3", "5e21b6811", "845a8ea3e", "92da75278", "a8518738a", "aac898ac5", "b2aee4cb6"]], "identity_text": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka. The IANA time zone database previously provided textual abbreviations for all time zones, sometimes making up abbreviations that have little or no currency among the local population. They are in process of reversing that policy in favor of using numeric UTC offsets in zones where there is no evidence of real-world use of an English abbreviation. At least for the time being, PostgreSQL will continue to accept such removed abbreviations for timestamp input. But they will not be shown in the pg_timezone_names view nor used for output. In this update, AMT is no longer shown as being in use to mean Armenia Time. Therefore, we have changed the Default abbreviation set to interpret it as Amazon Time, thus UTC-4 not UTC+4.", "commit_aliases": ["0c2f4c54c", "1d388ba2c", "22cf97635", "2877b102e", "37ecf07d3", "381c4b03b", "3c5fae786", "5508d0c0b", "5e21b6811", "66adeefda", "7abda82ef", "7fec5e101", "80ba149b0", "845a8ea3e", "8cddedc17", "92da75278", "9345bf08c", "9727dac58", "a03339aef", "a8518738a", "aac898ac5", "ad6f67179", "b2aee4cb6", "bc59c1236", "d8fc45bd0", "ecbac3e6e", "f3094920a", "ff68f434f"], "source_commits": ["0c2f4c54c", "7fec5e101", "80ba149b0", "845a8ea3e"], "source_entry_id": "9.6.1/changes/028", "db_id": "48ce47c9c15ba40810e3bf5ec621c6e2", "patch_ids": ["62f78316a6a8ac4b51035e905dec4981", "ab082a2b2f54ac1c80cfcbf1b568c16d", "bb64e758074231f2c483fe7395b37dcc", "c7b68179d6d2cd8776c7a0b875e26d3a"], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc", "relations": [{"rule": 2, "type": "equivalent", "target": "0beb84d0b5ea7d442a7e372ee1f44a0f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}}, {"rule": 2, "type": "equivalent", "target": "22efdf8d456fcfa0566c2bec71378820", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}}, {"rule": 2, "type": "equivalent", "target": "649e25bc93cef830346c3561540e67e2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}}, {"rule": 2, "type": "equivalent", "target": "7dbf3562cb1733646d00e2c34c95c08d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}}, {"rule": 2, "type": "equivalent", "target": "acf105f7b3890b7ae360a1c91e091c35", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}}], "version": "9.6.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "649e25bc93cef830346c3561540e67e2", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}, "url": "/docs/compare/?release=9.5.5#9.5.5-8f8c191547e6f04d", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "22efdf8d456fcfa0566c2bec71378820", "kind": "equivalent", "version": "9.4.10", "label": "9.4.10", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}, "url": "/docs/compare/?release=9.4.10#9.4.10-8f8c191547e6f04d", "source_url": "/docs/release/9.4.10/#AEN122083"}, {"db_id": "7dbf3562cb1733646d00e2c34c95c08d", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}, "url": "/docs/compare/?release=9.3.15#9.3.15-8f8c191547e6f04d", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "0beb84d0b5ea7d442a7e372ee1f44a0f", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}, "url": "/docs/compare/?release=9.2.19#9.2.19-8f8c191547e6f04d", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "acf105f7b3890b7ae360a1c91e091c35", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}, "url": "/docs/compare/?release=9.1.24#9.1.24-8f8c191547e6f04d", "source_url": "/docs/release/9.1.24/#AEN106976"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 28}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 17}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 11}], "total": 28, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 28, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}