The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 14.2, 13.6, 12.10, 11.15, and 10.20. This release fixes over 55 bugs reported over the last three months.
For the full list of changes, please review the release notes.
This update fixes over 55 bugs that were reported in the last several months. The issues listed below affect PostgreSQL 14. Some of these issues may also affect other supported versions of PostgreSQL.
Included in this release:
VACUUM. Encountering this issue is unlikely, but if you are concerned, please consider reindexing.
REINDEX CONCURRENTLYon TOAST table indexes to prevent corruption. You can fix any TOAST indexes by reindexing them again.
\passwordcommand now defaults to setting the password for the role defined by
CURRENT_USER. Additionally, the role name is now included in the password prompt.
ANALYZEon those tables. As
autovacuumcurrently does not process partitioned tables, you must periodically run
ANALYZEon any partitioned tables to update their statistics.
ALTER STATISTICSwhen the statistics object is dropped concurrently.
ALTER TABLE ... DROP NOT NULLfor a column that is part of a replica identity index.
REASSIGN OWNED BYoperations that reassign ownership of many objects.
INSERT ... VALUESrules.
\dcommand for identifying parent triggers.
\copycommand and using
--column-insertsmodes to handle tables that contain both generated and dropped columns.
postgres_fdwhandles asynchronous queries. These errors could lead to crashes or incorrect results when attempting to run parallel scans of foreign tables.
For the full list of changes available, please review the release notes.
All PostgreSQL update releases are cumulative. As with other minor releases,
users are not required to dump and reload their database or use
order to apply this update release; you may simply shutdown PostgreSQL and
update its binaries.
Users who have skipped one or more update releases may need to run additional, post-update steps; please see the release notes for earlier versions for details.
For more details, please see the release notes.