Postgres Minor Release Day!

The PGDG – PostgreSQL Global Development Group has released a Minor upgrade on all the supported versions of PostgreSQL 11 – 15.

There’re a few things that caught my attention and are worth mentioning…

Of course, the release fixes two security vulnerabilities:

  • CVE-2023-2454: CREATE SCHEMA … schema_element defeats protective search_path changes
  • CVE-2023-2455: Row security policies disregard user ID changes after inlining

A few other fixes I tested and am happy seeing them in this release are:

  • Fix partition pruning logic for partitioning on boolean columns (David Rowley)
    Pruning with a condition like boolcol IS NOT TRUE was done incorrectly, leading to possibly not returning rows in which boolcol is NULL. Also, the rather unlikely case of partitioning on NOT boolcol was handled incorrectly.
  • Fix pg_dump so that partitioned tables that are hash-partitioned on an enum-type column can be restored successfully (Tom Lane)
  • Restore support for sub-millisecond vacuum_cost_delay settings (Thomas Munro)

aaand the most important “Call Out” for the DBREs is the PostgreSQL 11 EOL Notice as PG 11 will stop receiving fixes on November 9, 2023

In the past, we’ve authored a blog post on Postgres Upgrades, hope that helps the folks to chalk out the Upgrade plan in the near future.

Feel free to reach out to us if you need any assistance to perform Postgres Major Upgrades.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>