liveBook · Manning

Minor release

As explained in PostgreSQL Mistakes and How to Avoid Them

A minor release is a PostgreSQL release that fixes bugs, security issues, or data-corruption problems without adding features or changing internal data formats.

A minor release is a PostgreSQL update that fixes bugs, security issues, and data-corruption problems without adding features or changing internal data formats. Minor releases arrive roughly quarterly and occupy the final part of the version number, such as 16.4. section 7.6

Treating a stable system as a reason to postpone minor upgrades is risky: latent bugs, new security vulnerabilities, changing workloads, and unexpected data-access patterns can expose problems later. The PostgreSQL community considers skipping these updates riskier than installing them. section 7.6 section 7.8

Keep the versioning distinction clear:

  • Use the final version component to identify a minor release, as in 16.4. section 7.6
  • Expect no new features or internal-format changes from a minor release. section 7.6
  • Distinguish major releases, which add thoroughly vetted features and may change system-table and data-file formats. section 7.6

The tempting “it works fine” decision

A team leaves its PostgreSQL installation unchanged because testing and monitoring show no current failures. That decision can still leave known bugs or security vulnerabilities unaddressed. Installing the appropriate minor release preserves the internal format while reducing those risks; avoiding it can produce the very instability the team hoped to avoid. section 7.6 section 7.8

How PostgreSQL Mistakes and How to Avoid Them covers it

How deep it goes
Defines release scope, cadence, numbering, and risks, but stops short of prescribing an upgrade procedure or commands.
Examples
Uses version 16.4, quarterly release timing, and the “it works fine now” upgrade-avoidance scenario.
What it assumes
Assumes basic PostgreSQL versioning knowledge and distinguishes minor releases from major releases and their compatibility implications.
What you can do after
Evaluate whether postponing a PostgreSQL minor upgrade creates greater risk than applying a compatibility-preserving corrective update.
How it connects
Connects minor releases to major releases, backward compatibility, security vulnerabilities, bugs, and data corruption.

Related concepts

This explainer was generated by Manning's knowledge graph from the text of PostgreSQL Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.