{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2015-06-12", "build": "9.0.22", "major": "9.0", "minor": 22, "manual": "9.0", "status": "stable", "doc_git": "", "version": "9.0.22", "eol_date": "2015-10-08", "date_text": "2015-06-12", "supported": false, "manual_url": "/docs/9.0/release-9-0-22.html", "source_url": "/docs/release/9.0.22/", "entry_count": 2, "placeholder": false, "content_hash": "143f55bf1553d0e286de7c479ab74255fe68d34831123aa2946ad6c720bbe1a8", "manual_build": "9.0.23", "source_as_of": "", "changes_count": 2, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "<p>A dump/restore is not required for those running 9.0.X.</p>\n<p>However, if you are upgrading from a version earlier than 9.0.18, see <a href=\"/docs/9.0/release-9-0-18.html\">Section E.6</a>.</p>", "compatibility_count": 0, "label": "9.0.22", "status_label": "Historical", "eol": "2015-10-08", "age_days": 4127, "support_days": -4009}, "groups": [{"date": "2015-06-12", "build": "9.0.22", "major": "9.0", "minor": 22, "manual": "9.0", "status": "stable", "doc_git": "", "version": "9.0.22", "eol_date": "2015-10-08", "date_text": "2015-06-12", "supported": false, "manual_url": "/docs/9.0/release-9-0-22.html", "source_url": "/docs/release/9.0.22/", "entry_count": 2, "placeholder": false, "content_hash": "143f55bf1553d0e286de7c479ab74255fe68d34831123aa2946ad6c720bbe1a8", "manual_build": "9.0.23", "source_as_of": "", "changes_count": 2, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "<p>A dump/restore is not required for those running 9.0.X.</p>\n<p>However, if you are upgrading from a version earlier than 9.0.18, see <a href=\"/docs/9.0/release-9-0-18.html\">Section E.6</a>.</p>", "compatibility_count": 0, "label": "9.0.22", "status_label": "Historical", "eol": "2015-10-08", "age_days": 4127, "support_days": -4009, "entries": [{"id": "9.0.22-7ead1e3f6e3426ab", "cves": [], "html": "<p>Fix rare failure to invalidate relation cache init file (Tom Lane)</p>\n<p>With just the wrong timing of concurrent activity, a VACUUM FULL on a system catalog might fail to update the <span>\"init file\"</span> that's used to avoid cache-loading work for new sessions. This would result in later sessions being unable to access that catalog at all. This is a very ancient bug, but it's so hard to trigger that no reproducible case had been seen until recently.</p>", "text": "Fix rare failure to invalidate relation cache init file (Tom Lane) With just the wrong timing of concurrent activity, a VACUUM FULL on a system catalog might fail to update the \"init file\" that's used to avoid cache-loading work for new sessions. This would result in later sessions being unable to access that catalog at all. This is a very ancient bug, but it's so hard to trigger that no reproducible case had been seen until recently.", "title": "Fix rare failure to invalidate relation cache init file", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.22/#AEN99533", "source_hash": "6bec1b27e4a7c93b00f27640abe8cfeea45f0bff3dcdb265af25580efcb2a989", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix rare failure to invalidate relation cache init file (Tom Lane) With just the wrong timing of concurrent activity, a VACUUM FULL on a system catalog might fail to update the init file that's used to avoid cache-loading work for new sessions. This would result in later sessions being unable to access that catalog at all. This is a very ancient bug, but it's so hard to trigger that no reproducible case had been seen until recently.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.22/changes/001", "db_id": "56559e80e5e318ceb4a1514c01179a96", "patch_ids": [], "statement_hash": "cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d", "relations": [{"rule": 2, "type": "equivalent", "target": "421f0e5f53c1b534c1a5d7e5c3ddaeb1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"}}, {"rule": 2, "type": "equivalent", "target": "62f6eb8f9354ed2084e2a04aba92b9a4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"}}, {"rule": 2, "type": "equivalent", "target": "d00ab3b80fd0fe3a84d1b02a94bfcd79", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"}}, {"rule": 2, "type": "equivalent", "target": "e08881035a5c62a2921de58daddb199c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"}}], "version": "9.0.22", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e08881035a5c62a2921de58daddb199c", "kind": "equivalent", "version": "9.4.4", "label": "9.4.4", "title": "Fix rare failure to invalidate relation cache init file", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"}, "url": "/docs/compare/?release=9.4.4#9.4.4-7ead1e3f6e3426ab", "source_url": "/docs/release/9.4.4/#AEN123224"}, {"db_id": "d00ab3b80fd0fe3a84d1b02a94bfcd79", "kind": "equivalent", "version": "9.3.9", "label": "9.3.9", "title": "Fix rare failure to invalidate relation cache init file", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"}, "url": "/docs/compare/?release=9.3.9#9.3.9-7ead1e3f6e3426ab", "source_url": "/docs/release/9.3.9/#AEN117410"}, {"db_id": "62f6eb8f9354ed2084e2a04aba92b9a4", "kind": "equivalent", "version": "9.2.13", "label": "9.2.13", "title": "Fix rare failure to invalidate relation cache init file", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"}, "url": "/docs/compare/?release=9.2.13#9.2.13-7ead1e3f6e3426ab", "source_url": "/docs/release/9.2.13/#AEN112268"}, {"db_id": "421f0e5f53c1b534c1a5d7e5c3ddaeb1", "kind": "equivalent", "version": "9.1.18", "label": "9.1.18", "title": "Fix rare failure to invalidate relation cache init file", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"}, "url": "/docs/compare/?release=9.1.18#9.1.18-7ead1e3f6e3426ab", "source_url": "/docs/release/9.1.18/#AEN107770"}]}, {"id": "9.0.22-9735af7d787af4cc", "cves": [], "html": "<p>Avoid deadlock between incoming sessions and CREATE/DROP DATABASE (Tom Lane)</p>\n<p>A new session starting in a database that is the target of a DROP DATABASE command, or is the template for a CREATE DATABASE command, could cause the command to wait for five seconds and then fail, even if the new session would have exited before that.</p>", "text": "Avoid deadlock between incoming sessions and CREATE/DROP DATABASE (Tom Lane) A new session starting in a database that is the target of a DROP DATABASE command, or is the template for a CREATE DATABASE command, could cause the command to wait for five seconds and then fail, even if the new session would have exited before that.", "title": "Avoid deadlock between incoming sessions and CREATE/DROP DATABASE", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.22/#AEN99533", "source_hash": "5955b77e7598b41a798cbf651d54231093f0a28da1857ce4d5be305b763ca703", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid deadlock between incoming sessions and CREATE/DROP DATABASE (Tom Lane) A new session starting in a database that is the target of a DROP DATABASE command, or is the template for a CREATE DATABASE command, could cause the command to wait for five seconds and then fail, even if the new session would have exited before that.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.22/changes/002", "db_id": "9bfc180a71dd7d167b27c33f605fed9e", "patch_ids": [], "statement_hash": "9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496", "relations": [{"rule": 2, "type": "equivalent", "target": "29b698d5466f021dc8611d5d25ef7a31", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"}}, {"rule": 2, "type": "equivalent", "target": "324abd755d98fe477c7962eab7502c58", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"}}, {"rule": 2, "type": "equivalent", "target": "7f208fa7a3abd0837b1466c4a8f65e61", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"}}, {"rule": 2, "type": "equivalent", "target": "c17918b133f9aac5297f7d0675245278", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"}}], "version": "9.0.22", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c17918b133f9aac5297f7d0675245278", "kind": "equivalent", "version": "9.4.4", "label": "9.4.4", "title": "Avoid deadlock between incoming sessions and CREATE/DROP DATABASE", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"}, "url": "/docs/compare/?release=9.4.4#9.4.4-9735af7d787af4cc", "source_url": "/docs/release/9.4.4/#AEN123224"}, {"db_id": "324abd755d98fe477c7962eab7502c58", "kind": "equivalent", "version": "9.3.9", "label": "9.3.9", "title": "Avoid deadlock between incoming sessions and CREATE/DROP DATABASE", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"}, "url": "/docs/compare/?release=9.3.9#9.3.9-9735af7d787af4cc", "source_url": "/docs/release/9.3.9/#AEN117410"}, {"db_id": "29b698d5466f021dc8611d5d25ef7a31", "kind": "equivalent", "version": "9.2.13", "label": "9.2.13", "title": "Avoid deadlock between incoming sessions and CREATE/DROP DATABASE", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"}, "url": "/docs/compare/?release=9.2.13#9.2.13-9735af7d787af4cc", "source_url": "/docs/release/9.2.13/#AEN112268"}, {"db_id": "7f208fa7a3abd0837b1466c4a8f65e61", "kind": "equivalent", "version": "9.1.18", "label": "9.1.18", "title": "Avoid deadlock between incoming sessions and CREATE/DROP DATABASE", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"}, "url": "/docs/compare/?release=9.1.18#9.1.18-9735af7d787af4cc", "source_url": "/docs/release/9.1.18/#AEN107770"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 2}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 2}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 0}], "total": 2, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 2, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}