A dump/restore is not required for those running 9.3.X.
\nHowever, if you use the hstore extension, see the first changelog entry.
", "compatibility_count": 0, "label": "9.3.1", "status_label": "Historical", "eol": "2018-11-08", "age_days": 4737, "support_days": -2882}, "groups": [{"date": "2013-10-10", "build": "9.3.1", "major": "9.3", "minor": 1, "manual": "9.3", "status": "stable", "doc_git": "", "version": "9.3.1", "eol_date": "2018-11-08", "date_text": "2013-10-10", "supported": false, "manual_url": "/docs/9.3/release-9-3-1.html", "source_url": "/docs/release/9.3.1/", "entry_count": 8, "placeholder": false, "content_hash": "d24c8fc50c75e5476c9c76f1dd5720b251210788352ac7c6dcc195c33e2ee22c", "manual_build": "9.3.25", "source_as_of": "", "changes_count": 8, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.3.X.
\nHowever, if you use the hstore extension, see the first changelog entry.
", "compatibility_count": 0, "label": "9.3.1", "status_label": "Historical", "eol": "2018-11-08", "age_days": 4737, "support_days": -2882, "entries": [{"id": "9.3.1-6901fdb914aae475", "cves": [], "html": "Ensure new-in-9.3 JSON functionality is added to the hstore extension during an update (Andrew Dunstan)
\nUsers who upgraded a pre-9.3 database containing hstore should execute
\nALTER EXTENSION hstore UPDATE;\n\n
after installing 9.3.1, to add two new JSON functions and a cast. (If hstore is already up to date, this command does nothing.)
", "text": "Ensure new-in-9.3 JSON functionality is added to the hstore extension during an update (Andrew Dunstan) Users who upgraded a pre-9.3 database containing hstore should execute ALTER EXTENSION hstore UPDATE; after installing 9.3.1, to add two new JSON functions and a cast. (If hstore is already up to date, this command does nothing.)", "title": "Ensure new-in-9.3 JSON functionality is added to the hstore extension during an update", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.1/#AEN118992", "source_hash": "c578fcb2f9e9d6fa4fb97f1cb926753d2843268531369a99b10bbe576eed3d40", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure new-in-9.3 JSON functionality is added to the hstore extension during an update (Andrew Dunstan) Users who upgraded a pre-9.3 database containing hstore should execute ALTER EXTENSION hstore UPDATE; after installing 9.3.1, to add two new JSON functions and a cast. (If hstore is already up to date, this command does nothing.)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.1/changes/001", "db_id": "c29f133a6596c9048bd94659340a51ce", "patch_ids": [], "statement_hash": "00cbf51dbeb91563bccc19a37fb71fbd4336c977cfaffa7c8206407e8962c487", "relations": [], "version": "9.3.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.1-d33472600a0d5e25", "cves": [], "html": "Fix memory leak when creating B-tree indexes on range columns (Heikki Linnakangas)
", "text": "Fix memory leak when creating B-tree indexes on range columns (Heikki Linnakangas)", "title": "Fix memory leak when creating B-tree indexes on range columns", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.1/#AEN118992", "source_hash": "0e0cfdc1bbeb766aa2bbc3609b71180f5da2163473f6b8b0ddc5794196fb717f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix memory leak when creating B-tree indexes on range columns (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.1/changes/002", "db_id": "2513f131636c21eb942f2bf780e749a9", "patch_ids": [], "statement_hash": "5d71edb6c117e3ed525a9cf9012f6622f03441f87135bdea2cfd5500a2751182", "relations": [{"rule": 2, "type": "equivalent", "target": "08dcfe98e8e4e602b81b94709a7d46ac", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5d71edb6c117e3ed525a9cf9012f6622f03441f87135bdea2cfd5500a2751182"}}], "version": "9.3.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "08dcfe98e8e4e602b81b94709a7d46ac", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix memory leak when creating B-tree indexes on range columns", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5d71edb6c117e3ed525a9cf9012f6622f03441f87135bdea2cfd5500a2751182"}, "url": "/docs/compare/?release=9.2.5#9.2.5-d33472600a0d5e25", "source_url": "/docs/release/9.2.5/#AEN113495"}]}, {"id": "9.3.1-f03d995dadb45be3", "cves": [], "html": "Fix memory leak caused by lo_open() failure (Heikki Linnakangas)
Serializable snapshot fixes (Kevin Grittner, Heikki Linnakangas)
", "text": "Serializable snapshot fixes (Kevin Grittner, Heikki Linnakangas)", "title": "Serializable snapshot fixes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.1/#AEN118992", "source_hash": "06c0672c2ca5b74cb4cbc4517aa8302c265202a4a11f323a65a0d89b385ce957", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Serializable snapshot fixes (Kevin Grittner, Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.1/changes/004", "db_id": "0be7518a9a031397b4027916ef082f87", "patch_ids": [], "statement_hash": "8f9d721afe753664d0ab612ed292b89077e5d231d41eab0eaf4fef39152baa02", "relations": [{"rule": 2, "type": "equivalent", "target": "275f818d6e6cf3843e9171c90c4de2ef", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8f9d721afe753664d0ab612ed292b89077e5d231d41eab0eaf4fef39152baa02"}}, {"rule": 2, "type": "equivalent", "target": "ec78808cba11d2e17321444345e909b6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8f9d721afe753664d0ab612ed292b89077e5d231d41eab0eaf4fef39152baa02"}}], "version": "9.3.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "275f818d6e6cf3843e9171c90c4de2ef", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Serializable snapshot fixes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8f9d721afe753664d0ab612ed292b89077e5d231d41eab0eaf4fef39152baa02"}, "url": "/docs/compare/?release=9.2.5#9.2.5-3223cdf07e0f6997", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "ec78808cba11d2e17321444345e909b6", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Serializable snapshot fixes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8f9d721afe753664d0ab612ed292b89077e5d231d41eab0eaf4fef39152baa02"}, "url": "/docs/compare/?release=9.1.10#9.1.10-3223cdf07e0f6997", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.3.1-f5f890101162d2d4", "cves": [], "html": "Fix deadlock bug in libpq when using SSL (Stephen Frost)
", "text": "Fix deadlock bug in libpq when using SSL (Stephen Frost)", "title": "Fix deadlock bug in libpq when using SSL", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.1/#AEN118992", "source_hash": "3fba32b17ef4948a36223661c41e75f719ceb04594bb4256366df0b16a443229", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix deadlock bug in libpq when using SSL (Stephen Frost)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.1/changes/005", "db_id": "6aa0428b6fdf47b0a1bcf5230033bf4d", "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f", "relations": [{"rule": 2, "type": "equivalent", "target": "237ecc0fb2de96e0467467b4a6ddc257", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}}, {"rule": 2, "type": "equivalent", "target": "57c1c2b14328df07d1fff5b5855231d5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}}, {"rule": 2, "type": "equivalent", "target": "9c82054ba2b8bff7fe6cbd12ce8ce608", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}}], "version": "9.3.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9c82054ba2b8bff7fe6cbd12ce8ce608", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix deadlock bug in libpq when using SSL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}, "url": "/docs/compare/?release=9.2.5#9.2.5-f5f890101162d2d4", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "237ecc0fb2de96e0467467b4a6ddc257", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Fix deadlock bug in libpq when using SSL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}, "url": "/docs/compare/?release=9.1.10#9.1.10-f5f890101162d2d4", "source_url": "/docs/release/9.1.10/#AEN108834"}, {"db_id": "57c1c2b14328df07d1fff5b5855231d5", "kind": "equivalent", "version": "9.0.14", "label": "9.0.14", "title": "Fix deadlock bug in libpq when using SSL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}, "url": "/docs/compare/?release=9.0.14#9.0.14-f5f890101162d2d4", "source_url": "/docs/release/9.0.14/#AEN100480"}]}, {"id": "9.3.1-a3cda3b75dabe81e", "cves": [], "html": "Fix timeline handling bugs in pg_receivexlog (Heikki Linnakangas, Andrew Gierth)
", "text": "Fix timeline handling bugs in pg_receivexlog (Heikki Linnakangas, Andrew Gierth)", "title": "Fix timeline handling bugs in pg_receivexlog", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.1/#AEN118992", "source_hash": "236dcc9ba7b2a53ac65d7110b57e72ac163529f0694d66716f34e735298032f9", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix timeline handling bugs in pg_receivexlog (Heikki Linnakangas, Andrew Gierth)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.1/changes/006", "db_id": "56cc8ae9a28689330355255f740df02e", "patch_ids": [], "statement_hash": "191234b5fac76abf4ab8a2b34e991ab61aeaadbfe61ab2c950aae60b5996f14e", "relations": [], "version": "9.3.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.1-b03405d9f39f9186", "cves": [], "html": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled (Tom Lane)
", "text": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled (Tom Lane)", "title": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.1/#AEN118992", "source_hash": "bd9e8c215fa2f75455ad26ec6fb8e733df68be9a3245d6d918a74a3c473a4128", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.1/changes/007", "db_id": "952098d7106adf07d8708504ded36cdc", "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2", "relations": [{"rule": 2, "type": "equivalent", "target": "0cc8abd693ef1496bda0846c2a0be99d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}}, {"rule": 2, "type": "equivalent", "target": "4b7ff29db9a4dd18c6378a2775cece9c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}}, {"rule": 2, "type": "equivalent", "target": "bab837642eb334b82c387136f2b5db7a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}}], "version": "9.3.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "4b7ff29db9a4dd18c6378a2775cece9c", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}, "url": "/docs/compare/?release=9.2.5#9.2.5-b03405d9f39f9186", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "bab837642eb334b82c387136f2b5db7a", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}, "url": "/docs/compare/?release=9.1.10#9.1.10-b03405d9f39f9186", "source_url": "/docs/release/9.1.10/#AEN108834"}, {"db_id": "0cc8abd693ef1496bda0846c2a0be99d", "kind": "equivalent", "version": "9.0.14", "label": "9.0.14", "title": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}, "url": "/docs/compare/?release=9.0.14#9.0.14-b03405d9f39f9186", "source_url": "/docs/release/9.0.14/#AEN100480"}]}, {"id": "9.3.1-36de488529f17611", "cves": [], "html": "Remove rare inaccurate warning during vacuum of index-less tables (Heikki Linnakangas)
", "text": "Remove rare inaccurate warning during vacuum of index-less tables (Heikki Linnakangas)", "title": "Remove rare inaccurate warning during vacuum of index-less tables", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.1/#AEN118992", "source_hash": "7aa5eb89f3c6a0ec137fcbd5c9f38f57c97d7957ebc7569bce7ae77132ce0c3d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Remove rare inaccurate warning during vacuum of index-less tables (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.1/changes/008", "db_id": "35fa6bf292d6d773149d2968283feee6", "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39", "relations": [{"rule": 2, "type": "equivalent", "target": "1cd4e08d8d8118ced058999f7694a5df", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}}, {"rule": 2, "type": "equivalent", "target": "b693deb5d849d6fa745ce608ef1c7b19", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}}, {"rule": 2, "type": "equivalent", "target": "f19dec60ba95d259d851bea1ba274eb5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}}], "version": "9.3.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "1cd4e08d8d8118ced058999f7694a5df", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Remove rare inaccurate warning during vacuum of index-less tables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}, "url": "/docs/compare/?release=9.2.5#9.2.5-36de488529f17611", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "b693deb5d849d6fa745ce608ef1c7b19", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Remove rare inaccurate warning during vacuum of index-less tables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}, "url": "/docs/compare/?release=9.1.10#9.1.10-36de488529f17611", "source_url": "/docs/release/9.1.10/#AEN108834"}, {"db_id": "f19dec60ba95d259d851bea1ba274eb5", "kind": "equivalent", "version": "9.0.14", "label": "9.0.14", "title": "Remove rare inaccurate warning during vacuum of index-less tables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}, "url": "/docs/compare/?release=9.0.14#9.0.14-36de488529f17611", "source_url": "/docs/release/9.0.14/#AEN100480"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 8}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 5}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 3}], "total": 8, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 8, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}