HomeFreeBSD

databases/postgresql??-*: Update to latest version

Description

databases/postgresql??-*: Update to latest version

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.

Security: 12e3feab-a29f-11ef-af48-6cc21735f730

Details

Provenance
girgenAuthored on Nov 21 2024, 2:20 PM
Parents
R11:4fbf489f56e6: mail/py-pyspf: Add lifetime argument back
Branches
Unknown
Tags
Unknown