On June 17, 2026, the IvorySQL community officially released IvorySQL 5.4. As an Oracle-compatible open-source PostgreSQL database, IvorySQL 5.4 is built on PostgreSQL 18.4 and includes kernel updates, feature enhancements, and ecosystem expansion, further advancing AI, cloud-native deployment, and database management capabilities.

Full release notes: docs.ivorysql.org

PostgreSQL 18.4 Kernel Update

  1. Prevent unbounded recursion while processing startup packets
  2. Fix assorted integer overflows in memory-allocation calculations
  3. Properly quote subscription names in pg_createsubscriber
  4. Properly quote object names in logical replication origin checks
  5. Reject over-length options in ts_headline()
  6. Detect faulty input when restoring attribute MCV statistics

Key Enhancements

Upgrade to PG 18.4 kernel

PostgreSQL kernel upgraded to version 18.4 for improved stability, security and compatibility.

IvorySQL Skills

github.com/IvorySQL/skills

Empowering AI assistants to become IvorySQL database experts.

Online Experience

trial.ivorysql.org

An interactive, browser-based environment is now available, allowing users to explore and evaluate IvorySQL 5.4 in real time — no installation required.

Packaging for All Platforms

Provides multi-platform media packages for X86, ARM, MIPS, and LoongArch architectures.

Containerized Deployment Support

Supports one-click deployment of standalone or highly available IvorySQL 5.4 clusters via Docker Compose, Podman, Swarm, Helm, and the IvorySQL 5.4 Operator.

IvorySQL Cloud 5.4

A fully managed, graphical control plane that handles IvorySQL 5.4 database subscriptions, orchestrates end-to-end lifecycle operations, and integrates surrounding ecosystem services.

PostgreSQL Extensions

Added support for additional PostgreSQL extensions and tools:

  • AI & Vector: pg_ai_query, pgvector
  • Graph: AGE
  • GIS & Routing: PostGIS, pgRouting
  • Chinese text search: pg_jieba, Zhparser, pg_bigm
  • Full-text search: PGroonga, pg_textsearch
  • Scheduling: pg_cron, pgagent
  • Monitoring: system_stats, pg_stat_monitor, pg_show_plans
  • SQL tools: ddlx, plpgsql_check, pg_hint_plan
  • HTTP: pgsql-http, pg_curl
  • Connection pool: PgBouncer
  • Partitioning: pg_partman
  • WAL: wal2json
  • Foreign data: redis_fdw

SQL Compatibility

Enhanced the EXTRACT function support to accept additional syntax variations in SQL queries.

Source Code

Contributors

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

3296442201 · Adria0615 · anapplebeee · Cédric Villemain · Fawei Zhao · Ge Sui · Grant Zhou · hanjianqiao · jerome-peng · liketoochao · movead123 · msdnchina · Pierre Forstmann · Rophy Tsai · Shawn Yan · Shuntian Jiao · Steven Niu · tian1220A · xiaoyu509 · Xiaohui Liu · Xiangyu Liang · Xinjie LYU · Xueyu Gao · yes7rose · Yasir Hussain Shah · z20081120087 · Zhe Zhang · Zhenhao Pan · Zheng Tao · Zhuoyan Shi · zuinuan123

Try It Out

Complete Changelog

We welcome the community to download and try IvorySQL 5.4. If you encounter any issues, please submit an issue. Every reporter has a chance to receive exclusive IvorySQL community merchandise.