PostgreSQL has released versions 18.7, 17.12, 16.16, 15.20 and 14.25, alongside PostgreSQL 19 RC 2. The project says the November 12 updates fix 52 security vulnerabilities and more than 140 other bugs.
Administrators should review the post-update instructions for certain indexes, backups and partitioned tables.
Users of pg_trgm GiST indexes should rebuild indexes using gist_trgm_ops. Reindexing is also advised for suspect GIN indexes, tables showing missing chunk number errors, and B-tree indexes on lengthless bpchar columns. Incremental-backup users should take a fresh full backup after updating and use it as their next baseline.
Version 14.25 is PostgreSQL 14’s final release. That branch now receives no further security or bug fixes, making migration to a supported major version necessary for continued maintenance.
PostgreSQL 19 RC 2 is still a release candidate. The announcement does not report active exploitation of the repaired security flaws.
