E.1. Release 13.18

E.1.1. Migration to Version 13.18
E.1.2. Changes

Release date: 2024-11-21

This release contains a few fixes from 13.17. For information about new features in major release 13, see Section E.19.

E.1.1. Migration to Version 13.18

A dump/restore is not required for those running 13.X.

However, if you are upgrading from a version earlier than 13.17, see Section E.2.

E.1.2. Changes

  • Restore functionality of ALTER {ROLE|DATABASE} SET role (Tom Lane, Noah Misch) §

    The fix for CVE-2024-10978 accidentally caused settings for role to not be applied if they come from non-interactive sources, including previous ALTER {ROLE|DATABASE} commands and the PGOPTIONS environment variable.

  • Fix cases where a logical replication slot's restart_lsn could go backwards (Masahiko Sawada) §

    Previously, restarting logical replication could sometimes cause the slot's restart point to be recomputed as an older value than had previously been advertised in pg_replication_slots. This is bad, since for example WAL files might have been removed on the basis of the later restart_lsn value, in which case replication would fail to restart.

  • Count index scans in contrib/bloom indexes in the statistics views, such as the pg_stat_user_indexes.idx_scan counter (Masahiro Ikeda) §

  • Fix crash when checking to see if an index's opclass options have changed (Alexander Korotkov) §

    Some forms of ALTER TABLE would fail if the table has an index with non-default operator class options.