Version Overview
[Release Date: Mar 12, 2026]
IvorySQL 5.3 is built on PostgreSQL 18.3 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.
Enhancements
-
PostgreSQL 18.3
-
Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version.
- Avoid incorrect complaint of invalid encoding when substring() is applied to "toasted" data.
- Fix oversight in the fix for CVE-2026-2007.
- Fix the volatility marking of json_strip_nulls() and jsonb_strip_nulls().
- Fix computation of the set of potentially-nulling outer joins for the output of a LATERAL UNION ALL subquery.
For further details, visit PostgreSQL’s release notes.
-
PostgreSQL 18.2
-
Guard against unexpected dimensions of oidvector/int2vector.
- Harden selectivity estimators against being attached to operators that accept unexpected data types.
- Fix buffer overrun in contrib/pgcrypto's PGP decryption functions.
- Fix inadequate validation of multibyte character lengths.
- Harden contrib/pg_trgm against changes in string lowercasing behavior.
For further details, visit PostgreSQL’s release notes.
Key Features
-
Upgrade to PG 18.3 kernel: Feature [#1199] PostgreSQL kernel upgraded to version 18.3.
-
Upgrade to PG 18.2 kernel: Feature [#1195] PostgreSQL kernel upgraded to version 18.2.
-
IvorySQL 5.3 Online Experience: Feature #7 An interactive, browser-based environment will be launched to allow users to explore and evaluate IvorySQL 5.3 in real time — no installation required.
-
Packaging for All Platforms Provides multi-platform media packages for X86, ARM, MIPS, LoongArch architecture.
-
Containerized Deployment Support Supports one-click deployment of standalone or highly available IvorySQL 5.3 clusters via Docker Compose, Podman, Swarm, Helm, and the IvorySQL 5.3 Operator.
-
IvorySQL Cloud 5.3 released (Visual Database Lifecycle Management Platform) Offers a fully managed, graphical control plane that handles IvorySQL 5.3 database subscriptions, orchestrates end-to-end lifecycle operations, and integrates surrounding ecosystem services.
-
PostgreSQL Extensions Support for 10 Additional PostgreSQL Extensions: pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check, pgvector.
Fixed Issues
- Clear build warnings: PR [#1190]
- Fix raw_expression_tree_walker for ColumnRefOrFuncCall: Issue [#1182]
- Fix the issue where upgrading from PostgreSQL to IvorySQL fails: Issue [#1130]
- Improved error message about plisql usage is ivorysql.compatible_mode = 'pg': PR [#1178]
- Fix array out-of-bounds read in token_is_col_id() - liboracle_parser.c: Issue [#1159]
- Fix psql tab-completion showing INVISIBLEINCREMENT: Issue [#1135]
- Fix variable reset bug in nested function expressions: Issue [#1124]
- Fix type coercion failure with mixed positional/named parameters in packages and subprocedures: Issue [#1006]
- Fix segfault when package procedure initializes local variable from parameter: Issue [#1005]
- Fix regression failures caused by the new year: PR [#1146]
Source Code
IvorySQL's development is maintained across four main repositories:
- IvorySQL database source code: https://github.com/IvorySQL/IvorySQL
- IvorySQL official website: https://github.com/IvorySQL/Ivory-www
- IvorySQL documentation: https://github.com/IvorySQL/IvorySQL_docs
- IvorySQL Docker: https://github.com/IvorySQL/docker_library
Contributors
The following individuals (in alphabetical order) have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.
- Cédric Villemain
- Fawei Zhao
- Ge Sui
- Grant Zhou
- Oreo Yang
- Pierre Forstmann
- Rophy Tsai
- Shuntian Jiao
- Steven Niu
- Xiangyu Liang
- Xiaohui Liu
- Xinjie LYU
- Xueyu Gao
- Yasir Hussain Shah
- Yuan Li
- Zheng Tao
- Zhenhao Pan
- Zhe Zhang
- Zhuoyan Shi