IvorySQL 4.2 Released

IvorySQL 4.2 was officially released on January 13, 2025. This new version offers full support for PostgreSQL 17.2 and fixes several bugs.

Enhanced Features

PostgreSQL 17.1 Enhancements

• Ensured cached plans are marked as dependent on the calling role when RLS is applied to non-top-level table references.
• Made libpq discard error messages received during SSL or GSS protocol negotiation.
• Fixed unexpected interactions between SET SESSION AUTHORIZATION and SET ROLE.
• Prevented trusted PL/Perl code from modifying environment variables.
• Fixed catalog state update issues for foreign key constraints when attaching or detaching table partitions.

For more details, please visit the PostgreSQL 17.1 Release Notes.

PostgreSQL 17.2 Enhancements

• Fixed ABI breakage for extensions used with struct ResultRelInfo.
• Restored ALTER {ROLE|DATABASE} SET role functionality.
• Fixed cases where the restart_lsn of a logical replication slot could move backward.
• Avoided deleting WAL files still needed when running pg_rewind.
• Fixed race conditions related to deleting shared statistics entries.

For more details, please visit the PostgreSQL 17.2 Release Notes.

IvorySQL 4.2 Resolved Issues

• Fixed pg_upgrade issues; IvorySQL can now be upgraded using pg_upgrade.
• Provided Rocky9 installation packages; IvorySQL 4.x can now be installed on Rocky Linux 9.
• Corrected English grammar errors in ivorysql_docs.

Source Code

IvorySQL primarily consists of two code repositories:

• IvorySQL Database Source Code: https://github.com/IvorySQL/IvorySQL
• IvorySQL Official Website: https://github.com/IvorySQL/Ivory-www

Contributors

The following individuals (listed in alphabetical order) contributed to this release as patch authors, committers, reviewers, testers, or issue reporters:

Cary Huang, Denis Lussier, Fawei Zhao, Grant Zhou, Hope Gao, Lily Wang, Shawn Yan, Shiji Niu, Shoubo Wang, Shuntian Jiao, Xiangyu Liang, Xinjie Lv, Zhibin Wang.