PostgreSQL has announced an update for all supported versions, which includes 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22. The update encompasses bug fixes and enhancements, including the restoration of ALTER ROLE functionality. Assign role and modify database settings. Implementing SET ROLE to restore compatibility for timescaledb and other PostgreSQL extensions developed prior to 2024-11-14, addressing issues with logical replication slot restart_lsn, preventing the deletion of WAL files during pg_rewind, and resolving race conditions.

PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 17.2, 16.6, 15.10, 14.15, and 13.18. Additionally, due to the nature of one of the issues in the  previous update release, the PostgreSQL Global Development Group is also releasing a 12.22 release for PostgreSQL 12. PostgreSQL 12 is now EOL and will not receive more fixes.

For the full list of changes, please review the  release notes.

Bug Fixes and Improvements

The issues listed below affect PostgreSQL 17. Some of these issues may also affect other supported versions of PostgreSQL.

• Restore functionality of  ALTER ROLE .. SET ROLE and  ALTER DATABASE .. SET ROLE. The fix for  CVE-2024-10978 accidentally caused settings for role to not be applied if they came from non-interactive sources, including previous ALTER {ROLE|DATABASE} commands and the  PGOPTIONS environment variable.
• Restore compatibility for the timescaledb and other PostgreSQL extensions built using PostgreSQL prior to the 2024-11-14 release (17.0, 16.4, 15.8, 14.13, 13.16, 12.20, and earlier). This fix restores struct ResultRelInfo to its previous size, so that affected extensions don't need to be rebuilt.
• Fix cases where a logical replication slot's restart_lsn could go backwards.
• Avoid deleting still-needed WAL files during  pg_rewind.
• Fix race conditions associated with dropping shared statistics entries, which could lead to loss of statistics data.
• Fix crash with ALTER TABLE when checking to see if an index's opclass options have changed if the table has an index with a non-default operator class.

PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!