IvorySQL Files

Version Overview

[Release Date: Dec 18, 2025]

IvorySQL 5.1 is built on PostgreSQL 18.1 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

• PostgreSQL 18.1

• Check for CREATE privileges on the schema in CREATE STATISTICS.

• Avoid integer overflow in allocation-size calculations within libpq.
• Prevent “unrecognized node type” errors when a SQL/JSON function such as JSON_VALUE has a DEFAULT clause containing a COLLATE expression.
• Avoid incorrect optimization of variable-free HAVING clauses with grouping sets.
• Do not use parallelism in hash right semi joins.
• Avoid possible division-by-zero when creating ordered-append plans.
• Fix planner failure with index types that can do ordered access but not index-only scans.

For further details, visit PostgreSQL’s release notes.

New Features

• Upgrade to PG 18.1 kernel: Feature [#1004] PostgreSQL kernel upgraded to version 18.1.

• Online Experience: IvorySQL 5.1: Feature #6 An interactive, browser-based environment will be launched to allow users to explore and evaluate IvorySQL 5.1 in real time — no installation required.

• Packaging for All Platforms: Feature [#1136] 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.1 clusters via Docker Compose, Podman, Swarm, Helm, and the IvorySQL 5.1 Operator.

• IvorySQL Cloud 5.1 released (Visual Database Lifecycle Management Platform) Offers a fully managed, graphical control plane that handles IvorySQL 5.1 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: Issue [#996]
• PL/iSQL Parser Rejects Parentheses in SELECT INTO Expression: Issue [#981]
• Doc:Fix reports missing uuid-ossp during source installation: Issue #198

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.

• Amberwww1
• Cédric Villemain
• Fawei Zhao
• Ge Sui
• Grant Zhou
• Oreo Yang
• Rophy Tsai
• Shuntian Jiao
• Steven Niu
• Xiangyu Liang
• Xiaohui Liu
• Xinjie Lv
• Xueyu Gao
• Yasir Hussain Shah
• Yuan Li
• Zheng Tao
• Zhenhao Pan
• Zhe Zhang
• Zhibin Wang
• Zhuoyan Shi

Complete Changelog