1min.

1MIN · DATABASES

PostgreSQL security updates require some work after installation

PostgreSQL released security and bug fixes for supported database versions, but installing new binaries is only part of the update. Some installations need indexes rebuilt, while users of incremental backups should take a new full backup before continuing that chain. Version 14.25 is the final PostgreSQL 14 release, making migration planning a separate task for those users.

PostgreSQL Global Development Group · Nov 12, 2026

Why it matters

An upgrade checklist must include data structures and backup continuity, not just the installed version.

More context

The stable updates are 18.7, 17.12, 16.16, 15.20 and 14.25. Matching-major minor updates do not require pg_upgrade. Review the announcement’s conditional repair steps, including GiST indexes using pg_trgm and affected GIN or character indexes.

Keep in mind

Follow the instructions matching the installation; not every index needs rebuilding. PostgreSQL 19 RC 2 is a prerelease, not a stable substitute for these updates.

Original read

More engineering ideas, one minute at a time.

Explore more stories