IvorySQL 4.4 Released

IvorySQL 4.4 was officially released on March 10, 2025. This new version offers full support for PostgreSQL 17.4, introduces a host of new features, and addresses known issues.

Enhanced Features

PostgreSQL 17.3 Enhancements

• Strengthened protection of PQescapeString and related functions against invalid encoding input strings.
• Restored automatic truncation of database and usernames occurring in connection requests.
• Excluded parallel workers from connection privilege checks and limits.
• Removed the "Lock" suffix from LWLock wait event names.
• Fixed an issue where stale results might be reused in window aggregations.
• Prevented checkpoints from starting during relation truncation.

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

PostgreSQL 17.4 Enhancements

• Improved libpq's quoting function behavior.
• Fixed a minor memory leak in pg_createsubscriber.
• Fixed the meson build system to correctly detect the availability of bsd_auth.h system headers.

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

New Features

1. ARM64 Architecture Full-Platform Media Packages

Provides full-platform media packages suitable for the ARM architecture, supporting mainstream operating systems at home and abroad, including Red Hat, Debian, Kylin, UOS, NSAR OS, etc.

2. X86 Architecture Full-Platform Media Packages

Provides full-platform media packages suitable for the X86 architecture, supporting mainstream operating systems at home and abroad, including Red Hat, Debian, Kylin, UOS, NSAR OS, etc.

3. New Kernel Architecture Design Column

Added a series of kernel architecture design documents, with the first theme being Oracle compatibility, deeply exploring the framework, design, and implementation principles of each module to help users understand the Oracle compatibility framework. Currently, architectural design documents for two modules have been released:

• Analysis of the Dual Parser Architecture Principle in the Oracle Compatibility Framework
• Analysis of the initdb Architecture Principle in the Oracle Compatibility Framework

4. IvorySQL Official Website Chatroom Feature

Added a chatroom feature to the official website, supporting intelligent interactions and Q&A sessions related to IvorySQL.

Resolved Issues

• Incomplete SQL when using invisible columns and pg_dump.
• EulerOS installation package issues.

For more details, see the IvorySQL 4.4 Release Notes.

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:

Alex Guo, Cary Huang, Denis Lussier, Fawei Zhao, Flyingbeecd, Grant Zhou, Imran Zaheer, Kang Wang, Lily Wang, Mingran Feng, Ruohang Feng, Shawn Yan, Shiji Niu, Shoubo Wang, Shuntian Jiao, Xiangyu Liang, Xinjie Lv, Xueyu Gao, Zhenhao Pan.