The PostgreSQL Global Development Group has released updates for versions 18.3, 17.9, 16.13, 15.17, and 14.22, addressing multiple bugs, with a significant fix for the "standby-freeze" issue affecting hot standbys after minor failovers. Additional improvements include fixes for the substring() function and the strict_word_similarity operator, as well as restoring the immutability of json_strip_nulls(), which is crucial for teams using materialized views or JSON indexes. Upgrading to version 18.3 is straightforward, requiring only the replacement of binaries and a server restart without needing to dump data or perform a full migration. This update is essential for users relying on replicas and indexed JSON, as it eliminates issues that could delay operations and compromise data consistency

PostgreSQL 18.3, 17.9, 16.13, 15.17 and 14.22 Updates: Multiple Bugs Squashed

The PostgreSQL Global Development Group released PostgreSQL 18.3, 17.9, 16.13, 15.17, and 14.22, fixing several bugs that had been causing issues for users. The most notable fix addresses the "standby-freeze" bug that would cause hot standbys to freeze after a minor failover, and also corrects issues with substring() and strict_word_similarity operators. Additionally, the update makes json_strip_nulls() immutable again, which is important for teams using materialized views or indexes over JSON columns. To upgrade to version 18.3, users can simply replace their binaries with the new version and restart the server, without needing to dump data or run a full migration.

PostgreSQL 18.3, 17.9, 16.13, 15.17 and 14.22 Updates: Multiple Bugs Squashed @ Linux Compatible