↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

DocumentationVersion comparison

POSTGRESQL · VERSION COMPARE

PostgreSQL 9.3.1 release changes

All features, fixes, and compatibility notes in this release, with related records from other versions.

All changes in this release
All changes in this release

Includes changes after the source version through the target. A major version name means its initial release.

From PostgreSQL 9.0 onward: 17 major branches and 352 release notes. Updated 2026-09-26.

Complete release changes

9.3.1

2013-10-10

Export JSON
8changesFeatures, fixes, improvements
1releaseGrouped by release
0CVEsVulnerability IDs mentioned in these notes

9.3.1 HistoricalSupport ends 2018-11-08

PostgreSQL 9.3.1

Migration and compatibility

A dump/restore is not required for those running 9.3.X.

However, if you use the hstore extension, see the first changelog entry.

ImprovementsEnsure new-in-9.3 JSON functionality is added to the hstore extension during an update

Changes

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.)

Bug fixesFix memory leak when creating B-tree indexes on range columns

Changes

Fix memory leak when creating B-tree indexes on range columns (Heikki Linnakangas)

Related records (1)

“Same change” requires complete matching evidence. “Related commits” can cover independent changes, a partial backport, or a follow-up correction; each release keeps its own explanation.

Bug fixesFix memory leak caused by lo_open() failure

Changes

Fix memory leak caused by lo_open() failure (Heikki Linnakangas)

Related records (3)

“Same change” requires complete matching evidence. “Related commits” can cover independent changes, a partial backport, or a follow-up correction; each release keeps its own explanation.

Bug fixesSerializable snapshot fixes

Changes

Serializable snapshot fixes (Kevin Grittner, Heikki Linnakangas)

Related records (2)

“Same change” requires complete matching evidence. “Related commits” can cover independent changes, a partial backport, or a follow-up correction; each release keeps its own explanation.

Bug fixesFix deadlock bug in libpq when using SSL

Changes

Fix deadlock bug in libpq when using SSL (Stephen Frost)

Related records (3)

“Same change” requires complete matching evidence. “Related commits” can cover independent changes, a partial backport, or a follow-up correction; each release keeps its own explanation.

Bug fixesFix timeline handling bugs in pg_receivexlog

Changes

Fix timeline handling bugs in pg_receivexlog (Heikki Linnakangas, Andrew Gierth)

ImprovementsPrevent CREATE FUNCTION from checking SET variables unless function body checking is enabled

Changes

Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled (Tom Lane)

Related records (3)

“Same change” requires complete matching evidence. “Related commits” can cover independent changes, a partial backport, or a follow-up correction; each release keeps its own explanation.

ImprovementsRemove rare inaccurate warning during vacuum of index-less tables

Changes

Remove rare inaccurate warning during vacuum of index-less tables (Heikki Linnakangas)

Related records (3)

“Same change” requires complete matching evidence. “Related commits” can cover independent changes, a partial backport, or a follow-up correction; each release keeps its own explanation.

How is this comparison generated?

The comparison follows PostgreSQL release notes from just after the source through the target version. For a major upgrade, maintenance releases from each older branch are included only up to the next major release date, and never after the target date. A major version such as 18 means its initial release, 18.0. Previews and development snapshots are labeled separately.

Entries come from the original English manuals. Release coverage and commit evidence are verified against upstream sources. Every entry retains its complete explanation and source link. Categories aid browsing; read the full notes for impact, conditions, and migration steps.

Fixes can be backported to several branches. Confirmed duplicates are merged conservatively, with every branch explanation retained. A note describing several independent fixes is excluded only when all are already present in the source. Major-release features remain distinct from related maintenance patches unless their complete original descriptions match. Uncertain matches are retained. This is a release-note history, not an exhaustive comparison of compiled binaries.

CVE results are calculated independently from the PostgreSQL security registry and vulnerability records. A CVE counts as gained protection only when the source is affected and the target is fixed or unaffected. Remaining vulnerabilities are listed separately. Security entries and distinct CVEs are counted separately.

Interaction inspired by pgversions.com and pgversionreport. Content comes from PostgreSQL release notes. See the release notes archive.