Version Overview

[ Release Date: September 18, 2026 ]

IvorySQL 5.6 updates the PostgreSQL core to version 18.6 and delivers fixes for Oracle compatibility, memory safety, client interfaces, and extension builds. For a comprehensive list of updates, please visit our documentation site.

Upstream Updates

PostgreSQL 18.5 was not released because a regression was discovered during release preparation.

• PostgreSQL 18.6

1. Restrict logical decoding output plugins to the set specified by a new server parameter output_plugin_libraries.
2. Fix contrib/pgcrypto's PGP encryption to detect unsupported ciphers.
3. Fix psql to skip in-line data following a scripted COPY ... FROM STDIN command, even if the COPY fails before sending PGRES_COPY_IN.
4. Check for USAGE privilege on data types in places that formerly failed to check that.
5. Invalidate role-dependent cached plans after role changes.
6. Ensure that parallel GIN index builds update the table's pg_class.reltuples value correctly.

For further details, visit PostgreSQL 18.6 release notes.

Enhancements

• Upgrade to PG 18.6 kernel: Feature #1719
  PostgreSQL kernel upgraded to version 18.6.

• PGNexus Now Supports IvorySQL 5.6
  PGNexus is now fully compatible with IvorySQL 5.6, bringing a zero-barrier, cloud-based AI-assisted experimentation experience! As a one-stop knowledge and experimentation platform for a wide range of scenarios, PGNexus now supports the latest IvorySQL 5.6. No local installation is required—you can build an environment with one click through the online sandbox. It supports patch application and testing and validation, covering multiple topology architectures including standalone, streaming replication, logical replication, and high-availability clusters. Ready to use out of the box, PGNexus helps universities, enterprises, and developers collaborate efficiently and rapidly explore new version features.

  Learn more about PGNexus or try the IvorySQL 5.6 sandbox.

• IvorySQL 5.6 Online Experience: Feature #12
  An interactive, browser-based environment is now available, allowing users to explore and evaluate IvorySQL 5.6 in real time — no installation required.

• AI-assisted contribution guidelines: Feature #1473
  Establish guidelines covering licensing compliance, human review and sign-off responsibilities, AI tool attribution, disclosure of AI-generated code percentages, and responsible participation in code reviews.

• Packaging for All Platforms
  Provides multi-platform media packages for X86, ARM, MIPS, and LoongArch architectures.

• Containerized Deployment Support
  Supports quick deployment of standalone or highly available IvorySQL 5.6 clusters via Docker Compose, Podman, Swarm, Helm, and the IvorySQL 5.6 Operator.

• IvorySQL Cloud 5.6 released (Visual Database Lifecycle Management Platform)
  Offers a fully managed, graphical control plane that handles IvorySQL 5.6 database subscriptions, orchestrates end-to-end lifecycle operations, and integrates surrounding ecosystem services.

• Extensions
  Support for 34 Extensions and Tools: AGE, ddlx, pg_ai_query, pg_bigm, pg_bulkload, pg_cron, pg_curl, pg_hint_plan, pg_jieba, pg_partman, pg_profile, pg_readonly, pg_repack, pg_show_plans, pg_stat_monitor, pg_textsearch, pgagent, pgaudit, pgBackRest, pgBouncer, PgDog, pgnodemx, PGroonga, pgRouting, pgsql-http, pgtt, pgvector, plpgsql_check, PostGIS, redis_fdw, set_user, system_stats, wal2json, zhparser.

Fixed Issues

• Fix potential overflow and NaN mishandling in Oracle-compatible interval multiplication and division: PR #1211
• Disallow persisting ivorysql.compatible_mode through ALTER USER/ROLE/DATABASE SET, and close the SET ... TO DEFAULT and parameter-specific RESET bypasses: PR #1372
• Fix package-qualified variable references resolving to unrelated local variables during expression evaluation: PR #1381
• Fix build failures with GCC 14 and later: PR #1385
• Fix validation of conflicting or repeated SHARD options on sequences: PR #1401
• Fix build failures of third-party PostgreSQL extensions against IvorySQL: PR #1448
• Make ivorysql.enable_case_switch visible in SHOW ALL and configurable in configuration files: PR #1450
• Fix missing package names and wrong schema qualification in DBMS_UTILITY backtrace and call-stack output: PR #1471
• Fix incorrect newline handling and m/n option behavior in REGEXP_COUNT, REGEXP_SUBSTR, REGEXP_INSTR, and REGEXP_REPLACE: PR #1489
• Fix Ivyresult memory leaks on early-return paths: PR #1556
• Fix heap buffer overruns in psql named-bind query escaping and \bind handling: PR #1569
• Fix heap buffer overflows when long namespace prefixes or URLs are used in XML functions: PR #1827

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.

• 123123213weqw
• Aias00
• ai-yang
• btlqql
• Cédric Villemain
• db-nikhil
• digoal
• enkilee
• Fawei Zhao
• Ge Sui
• goeason-world
• Grant Zhou
• hanjianqiao
• jerome-peng
• Kang Wang
• lispking
• messere1
• NotHimmel
• Shuntian Jiao
• Steven Niu
• tian1220A
• Xiangyu Liang
• Xiaohui Liu
• Xinjie LYU
• Xueyu Gao
• xuhuicai
• yaozichen2025
• Yasir Hussain Shah
• yyqdbngt
• Z95-cmyk
• Zhe Zhang
• Zheng Tao
• Zhenhao Pan
• Zhuoyan Shi

Complete Changelog: IvorySQL 5.4 → 5.6

Version Overview

[Release Date: July 27, 2026]

IvorySQL 1.23, based on PostgreSQL 14.23 and includes a variety of bug fixes.

Enhancements

• PostgreSQL 14.23 Enhancements

1. Prevent unbounded recursion while processing startup packets.
2. Fix assorted integer overflows in memory-allocation calculations.
3. Reject over-length options in ts_headline().
4. Guard against malicious time zone names in timeofday() and pg_strftime().
5. When creating a multirange type, ensure the user has CREATE privilege on the schema specified for the multirange type.
6. Use timing-safe string comparisons in authentication code.
7. Mark PQfn() as unsafe, and avoid using it within libpq.
8. Prevent path traversal in pg_basebackup and pg_rewind.
9. Guard against field overflow within contrib/intarray's query_int type and contrib/ltree's ltxtquery type.
10. Prevent SQL injection and buffer overruns in contrib/spi.
    For further details, visit link: PostgreSQL's release notes.

Key Features

• Upgrade to PG 14.23 kernel: Feature #1361
  PostgreSQL kernel upgraded to version 14.23.

• Packaging for All Platforms
  Provides multi-platform media packages for X86, ARM, MIPS, LoongArch architecture.

• PostgreSQL Extensions
  Support for 7 Additional PostgreSQL Extensions: PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, pgvector, pgvectorscale.

Source Code

IvorySQL's development is maintained across two main repositories:

• IvorySQL database source code: https://github.com/IvorySQL/IvorySQL
• IvorySQL official website: https://github.com/IvorySQL/Ivory-www

Contributors

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

• Chao Li
• David Zhang
• Grant Zhou
• Jianqiao Han
• Shuntian Jiao
• Steven Niu
• Xiaohui Liu
• Xinjie LYU
• Xueyu Gao
• Zheng Tao
• Zhenhao Pan

Complete Changelog

Version Overview

[Release Date: June 17, 2026]

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

Upstream Updates

• PostgreSQL 18.4

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.

For further details, visit PostgreSQL's release notes.

Enhancements

• Upgrade to PG 18.4 kernel: Feature #1344
  PostgreSQL kernel upgraded to version 18.4.

• IvorySQL Skills
  Empowering AI assistants to become IvorySQL database experts.

• IvorySQL 5.4 Online Experience: Feature #10
  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 released (Visual Database Lifecycle Management Platform)
  Offers 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
  Support for Additional PostgreSQL Extensions and Tools: AGE, ddlx, pg_ai_query, pg_bigm, pg_cron, pg_curl, pg_hint_plan, pg_jieba, pg_partman, pg_show_plans, pg_stat_monitor, pg_textsearch, PgBouncer, pgRouting, pgagent, PGroonga, pgsql-http, pgvector, plpgsql_check, PostGIS, redis_fdw, system_stats, wal2json, Zhparser.

• Enhanced the EXTRACT function support to accept additional syntax variations in SQL queries: PR #1222

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.

• 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

Complete Changelog

Version Overview

[Release Date: Apr 21, 2026]

IvorySQL 1.22, based on PostgreSQL 14.22 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

• PostgreSQL 14.18-14.22 Enhancements

1. Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding.
2. Handle self-referential foreign keys on partitioned tables correctly.
3. Tighten security checks in planner estimation functions.
4. Prevent pg_dump scripts from being used to attack the user running the restore.
5. Check for CREATE privileges on the schema in CREATE STATISTICS.
6. Avoid integer overflow in allocation-size calculations within libpq.
7. Guard against unexpected dimensions of oidvector/int2vector.
8. Harden selectivity estimators against being attached to operators that accept unexpected data types.
9. Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version.
10. Avoid incorrect complaint of invalid encoding when substring() is applied to “toasted” data.
    For further details, visit PostgreSQL’s release notes.

Key Features

• Upgrade to PG 14.22 kernel: Feature #1223
  PostgreSQL kernel upgraded to version 14.22.

• Packaging for All Platforms
  Provides multi-platform media packages for X86, ARM, MIPS, LoongArch architecture.

• PostgreSQL Extensions
  Support for 7 Additional PostgreSQL Extensions: PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, pgvector, pgvectorscale.

• Global Unique Index: Feature #1230
  Offers a partition-table unique index that ensures cross-partition uniqueness using non-partition keys, available in both Postgres and Oracle compatibility modes, and supports create, attach, detach, insert, and update operations.

• Rebuild view when column type changed in base table: Feature #1224
  When a column type change is executed, the database automatically saves the definitions of all dependent views and after completing the type change, rebuilds those views in the correct dependency order.

• Logical Replication Fallback to FULL IDENTITY for Tables Without Primary Keys: Feature #1227
  Introduces a new GUC parameter logical_replication_fallback_to_full_identity that allows logical replication to automatically fall back to REPLICA IDENTITY FULL for tables configured with DEFAULT identity but lacking a primary key.

Source Code

IvorySQL's development is maintained across two main repositories:

• IvorySQL database source code: https://github.com/IvorySQL/IvorySQL
• IvorySQL official website: https://github.com/IvorySQL/Ivory-www

Contributors

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

• Chao Li
• David Zhang
• Grant Zhou
• Oreo Yang
• Shuntian Jiao
• Steven Niu
• Xiaohui Liu
• Xinjie LYU
• Xueyu Gao
• Zheng Tao
• Zhenhao Pan

Complete Changelog

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

1. Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version.
2. Avoid incorrect complaint of invalid encoding when substring() is applied to "toasted" data.
3. Fix oversight in the fix for CVE-2026-2007.
4. Fix the volatility marking of json_strip_nulls() and jsonb_strip_nulls().
5. 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

1. Guard against unexpected dimensions of oidvector/int2vector.
2. Harden selectivity estimators against being attached to operators that accept unexpected data types.
3. Fix buffer overrun in contrib/pgcrypto's PGP decryption functions.
4. Fix inadequate validation of multibyte character lengths.
5. 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

Complete Changelog

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

1. Check for CREATE privileges on the schema in CREATE STATISTICS.
2. Avoid integer overflow in allocation-size calculations within libpq.
3. Prevent “unrecognized node type” errors when a SQL/JSON function such as JSON_VALUE has a DEFAULT clause containing a COLLATE expression.
4. Avoid incorrect optimization of variable-free HAVING clauses with grouping sets.
5. Do not use parallelism in hash right semi joins.
6. Avoid possible division-by-zero when creating ordered-append plans.
7. 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

Version Overview

[Release Date: Nov 25, 2025]

IvorySQL 5.0 is built on PostgreSQL 18.0 and introduces major upgrades in Oracle compatibility, ecosystem component integration, and cloud-native capabilities. It also significantly enhances usability by providing mainstream full-platform installation packages and a smooth, seamless online experience. For a comprehensive list of updates, please visit our documentation site.

Enhancements

• PostgreSQL 18.0

1. An asynchronous I/O (AIO) subsystem that can improve performance of sequential scans, bitmap heap scans, vacuums, and other operations.
2. pg_upgrade now retains optimizer statistics.
3. Support for "skip scan" lookups that allow using multicolumn B-tree indexes in more cases.
4. uuidv7() function for generating timestamp-ordered UUIDs.
5. Virtual generated columns that compute their values during read operations. This is now the default for generated columns.
6. OAuth authentication support.
7. OLD and NEW support for RETURNING clauses in INSERT, UPDATE, DELETE, and MERGE commands.
8. Temporal constraints, or constraints over ranges, for PRIMARY KEY, UNIQUE, and FOREIGN KEY constraints.
   For further details, visit PostgreSQL’s release notes.

New Features

21 New Oracle Compatibility Features

• Oracle-compatible ROWID support: Feature #126
  Ensures IvorySQL row identifiers align with Oracle semantics for seamless cross-database tooling.

• PL/iSQL CALL invocation syntax: Feature #764
  Adds the Oracle-style CALL entry point so stored procedures can be invoked consistently.

• PL/iSQL %ROWTYPE support: Feature #765
  Allows variables to mirror entire table or cursor rows for concise PL/iSQL coding.

• PL/iSQL %TYPE support: Feature #766
  Enables variables to adopt the data type of existing columns or variables to reduce drift.

• Case-sensitive compatibility switch: Feature #767
  Preserves identifier case to match Oracle behavior when required.

• NLS parameter compatibility: Feature #768
  Honors Oracle-style NLS settings such as NLS_DATE_FORMAT and NLS_TIMESTAMP_FORMAT.

• Empty string to NULL translation: Feature #769
  Converts zero-length strings to NULL to match Oracle compatibility rules.

• Parser switching capability: Feature #770
  Adds toggles between Oracle and PostgreSQL parsers for per-session flexibility.

• GB18030 database encoding: Feature #771
  Provides GB18030 initialization and create-database options for full Chinese market coverage.

• Oracle-compatible SYS_GUID: Feature #773
  Implements the Oracle SYS_GUID function to generate RAW-based GUIDs.

• Oracle-compatible SYS_CONTEXT: Feature #774
  Delivers the Oracle SYS_CONTEXT API for querying session and environment metadata.

• Oracle-compatible USERENV: Feature #775
  Adds the USERENV function so sessions can inspect Oracle-style contextual details.

• Oracle-compatible function syntax: Feature #776
  Supports Oracle constructs such as EDITIONABLE/NONEDITIONABLE, RETURN, IS, and OUT ... NOCOPY options.

• Oracle-compatible procedure syntax: Feature #777
  Enables procedure DDL with Oracle options, EXEC invocation, and ALTER PROCEDURE support.

• libpq OUT parameter plumbing: Feature #778
  Extends client protocol handling so OUT parameters can be consumed like OCI.

• Procedure OUT parameter support: Feature #779
  Allows stored procedures to declare IN, OUT, and IN OUT modes per Oracle conventions.

• Function OUT parameter support: Feature #780
  Permits Oracle-style OUT parameters within functions, including IN OUT combinations.

• Nested subprograms: Feature #781
  Introduces support for declaring functions or procedures within other subprograms, including overloading.

• Oracle-compatible INSTR: Feature #782
  Matches Oracle INSTR behavior for substring searches and position checks.

• Oracle-compatible FORCE VIEW: Feature #783
  Lets views be created even when referenced objects do not yet exist, mirroring Oracle's FORCE option.

• Oracle-compatible LIKE operator: Feature #784
  Aligns pattern-matching semantics with Oracle for predictable wildcard behavior.

Online Trial and Multi-Platform Distribution Packages

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

• Packaging for All Platforms: Feature #949
  Provides multi-platform media packages for X86, ARM, MIPS, LoongArch architecture.

Cloud-Native & Containerized

• Containerized Deployment Support (Docker Compose & podman & Docker Swarm):
  Supports deployment of standalone IvorySQL databases and high-availability clusters in Docker Compose , podman and Docker Swarm environments.

• Containerized Deployment Support (Kubernetes):
  Supports deployment of standalone IvorySQL databases and high-availability clusters on Kubernetes (K8s) using Helm.

• IvorySQL Operator 5 released (Kubernetes):
  The IvorySQL Operator 5.0 has been adapted to support IvorySQL 5.0, with upgrades to system component versions and database extension versions.

• IvorySQL Cloud 5.0 released (Visual Database Lifecycle Management Platform):
  Offers a fully managed, graphical control plane that handles IvorySQL 5.0 database subscriptions, orchestrates end-to-end lifecycle operations, and integrates surrounding ecosystem services.

Support for 10 Additional PostgreSQL Extensions

• pg_cron: Feature #882
  Scheduled job execution within the database layer will be available through pg_cron integration.

• pgAudit: Feature #929
  Provides detailed session and/or object audit logging via the standard PostgreSQL logging facility.

• PostGIS: Feature #880
  Spatial data processing and geospatial analytics will be enabled through PostGIS compatibility.

• pgRouting: Feature #881
  Network and routing analysis features will be introduced with pgRouting support.

• PGroonga: Feature #879
  Full-text search capabilities will be enhanced via planned PGroonga support.

• ddlx: Feature #877
  Support for ddlx to enable advanced schema introspection and automated DDL generation.

• pgsql-http: Feature #883
  Allow the database to initiate HTTP/HTTPS requests internally, enabling seamless communication between the database and external web services.

• system_stats: Feature #946
  System level statistics will be provided by system_stats support.

• plpgsql_check: Feature #915
  Static code analysis on PL/pgSQL functions to identify errors, warnings, and potential issues before runtime execution.

• pgvector: Feature #878
  Integration with pgvector to empower AI/ML workloads through native vector similarity search.

Fixed Issues

• Repaired unused_oids and duplicate_oids catalog tooling so header scans correctly detect conflicts without false positives: Issue #841
• Added .gitignore coverage for libpq/ivytest artifacts to prevent generated binaries and logs from polluting developer trees: Issue #843
• Extended GitHub workflow regression runs to cover builds configured with --with-libnuma, preventing future breakages on NUMA-enabled hosts: Issue #869
• Eliminated the MainLoop dangling-pointer scenario that triggered intermittent segmentation faults under concurrency stress: Issue #898
• Re-enabled oracle_test/modules/*/sql cases by fixing harness assumptions so Oracle-compatibility suites execute end-to-end again: Issue #897
• Updated README.md and README_CN.md to reflect IvorySQL 5.0 feature set, packaging, and onboarding instructions: Issue #896
• Corrected globally unique index enforcement so related regression tests now pass reliably across supported platforms: Issue #894

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.

• Carlos Chong
• ccwxl
• Cédric Villemain
• Fu Bei
• Fawei Zhao
• Ge Sui
• Grant Zhou
• Imran Zaheer
• jerome-peng
• Jiaoshun Tian
• luss
• Martin Gerhardy
• Mingran Feng
• omstack
• otegami
• Ruike Sun
• rophy
• Shaolin Chu
• Shawn Yan
• Shihua Yang
• shlei6067
• Shuisen Tong
• Shuntian Jiao
• Steven Niu
• sjw1933
• Xiangyu Liang
• Xiaohui Liu
• Xinjie Lv
• xuexiaoganghs
• Xueyu Gao
• yangchunwanwusheng
• Yanliang Lei
• Yasir Hussain Shah
• Yuan Li
• Zhe Zhang
• Zheng Tao
• Zhenhao Pan
• Zhuoyan Shi

Complete Changelog

Version Overview

[Release Date: Sep 10, 2025]

IvorySQL 4.6, based on PostgreSQL 17.6 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

• PostgreSQL 17.6 Enhancements

1. Tighten security checks in planner estimation functions.
2. Prevent pg_dump scripts from being used to attack the user running the restore.
3. Convert newlines to spaces in names included in comments in pg_dump output.
4. Fix incorrect distance calculation in BRIN numeric_minmax_multi_ops support function.
5. Avoid regression in the size of XML input that we will accept.
   For further details, visit PostgreSQL’s release notes.

New Features

• Upgrade to PG 17.6 kernel: Feature #859

• MongoDB-compatible solution: Feature #860
  Provide a MongoDB-compatible solution using FerretDB and DocumentDB.

• LoongArch Packaging for All Platforms: Feature #738 #829
  Provides multi-platform media packages for LoongArch architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc. It also supports x86, ARM, and MIPS architectures.

• IvorySQL Online trail: Feature #4
  Provide users with a web-based platform to experience IvorySQL V4.6 in an online environment, enabling database interaction directly through a browser interface.

• Containerized Deployment Support (Docker Swarm):
  Supports deployment of standalone IvorySQL databases and high-availability clusters in Docker Swarm environments.

• Containerized Deployment Support (Kubernetes):
  Supports deployment of standalone IvorySQL databases and high-availability clusters on Kubernetes (K8s) using Helm.

• IvorySQL Cloud v4.0 released
  The IvorySQL Cloud platform currently supports subscription management for IvorySQL v4 databases, as well as comprehensive management of its surrounding ecosystem.

Fixed Issues

• Missing libcrypt on aarch64 platform: Issue #826
• prefix test_ extension are wrongly compiled and installed while exec make and make install:Issue #836
• Doc:fix some typos: Issue #143
• Doc:Fix document errors in the installation section: Issue #142
• Doc:Update the community contribution process: Issue #130

Source Code

IvorySQL's development is maintained across two main repositories:

• IvorySQL database source code: https://github.com/IvorySQL/IvorySQL
• IvorySQL official website: https://github.com/IvorySQL/Ivory-www

Contributors

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

• caffiendo
• Cédric Villemain
• Fawei Zhao
• flyingbeecd
• Ge Sui
• Grant Zhou
• huchangqiqi
• Pedro Lopez
• RRRRhl
• Ruohang Feng
• shangwei007
• Shawn Yan
• Shaolin Chu
• Shihua Yang
• Shiji Niu
• Shuntian Jiao
• tiankongbuqi
• Xiangyu Liang
• Xinjie Lv
• Xueyu Gao
• Yanliang Lei
• Yasir Hussain Shah
• Yuan Li
• Zheng Tao
• Zhenhao Pan
• Zhuoyan Shi

Complete Changelog

Version Overview

[Release Date: Jun 4, 2025]

IvorySQL 4.5, based on PostgreSQL 17.5 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

• PostgreSQL 17.5 Enhancements

1. Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding.
2. Handle self-referential foreign keys on partitioned tables correctly.
3. Avoid data loss when merging compressed BRIN summaries in brin_bloom_union().
4. Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that's inside WITH.
5. Fix ALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default.
   For further details, visit PostgreSQL’s release notes.

New Features

• Upgrade to PG 17.5 kernel: Feature #807

• MIPS Packaging for All Platforms: Feature #736
  Provides multi-platform media packages for MIPS architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc.

• IvorySQL Online trail: Feature #1
  Provide users with a web-based platform to experience IvorySQL V4.5 in an online environment, enabling database interaction directly through a browser interface.

• Add code of conduct: Feature #808

• Update the community contribution guide: Feature #121

• Automate Documentation Build and Website Update via Pull Requests: Feature #115

• Enhanced Contributor Workflow: Self-Assign Issues by using the '/assign' command: Feature #109

• IvorySQL Operator V4 has been adapted to support IvorySQL 4.5, with upgrades to system component versions and database extension versions : Feature #79

Fixed Issues

• Wrong enum value in check_compatible_mode and assign_compatible_mode: Issue #763
• Wrong test result in GUC Framework: Issue #111
• Update oracle compatibility parameters: Issue #74
• Update README path to a hyperlink: PR #156
• Force the search_path to be re-computed when compatible_mode is changed: Issue #760
• Rename ModifyTableContext and UpdateContext for better compatibility: PR #794
• Set identifier_case_switch to value in pg_control file so that configure file value can take effect : Issue #797

Source Code

IvorySQL's development is maintained across two main repositories:

• IvorySQL database source code: https://github.com/IvorySQL/IvorySQL
• IvorySQL official website: https://github.com/IvorySQL/Ivory-www

Contributors

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

• Cary Huang
• Cédric Villemain
• Denis Lussier
• Fawei Zhao
• Flyingbeecd
• Ge Sui
• Grant Zhou
• Hulin Ji
• Hope Gao
• Lily Wang
• Renli Zou
• Shawn Yan
• Shihua Yang
• Shiji Niu
• Shoubo Wang
• Shuntian Jiao
• Xiangyu Liang
• Xinjie Lv
• Zheng Tao
• Zhenhao Pan
• Zhuoyan Shi

Complete Changelog

Version Overview

[Release Date: Mar 26, 2025]

IvorySQL 1.17, based on PostgreSQL 14.17 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

• PostgreSQL 14.8-14.17 Enhancements

1. Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign.
2. Fix handling of unknown-type arguments in DISTINCT "any" aggregate functions.
3. Tighten security restrictions within REFRESH MATERIALIZED VIEW CONCURRENTLY.
4. Restrict visibility of pg_stats_ext and pg_stats_ext_exprs entries to the table owner.
5. Prevent unauthorized code execution during pg_dump.
6. Ensure cached plans are marked as dependent on the calling role when RLS applies to a non-top-level table reference.
7. Repair ABI break for extensions that work with struct ResultRelInfo.
8. Harden PQescapeString and allied functions against invalidly-encoded input strings.
9. Improve behavior of libpq's quoting functions.
   For further details, visit PostgreSQL’s release notes.

New Features

• ARM64 Packaging for All Platforms
  Provides multi-platform media packages for ARM architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc.

• X86 Packaging for All Platforms
  Provides multi-platform media packages for X86 architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc.

• Support for more open source plugins
  Such as ddlx0.20, pgvector v0.8.0, PGroonga 3.0.0, PostGIS 3.4.0 and pgRouting3.5.1.

Source Code

IvorySQL's development is maintained across two main repositories:

• IvorySQL database source code: https://github.com/IvorySQL/IvorySQL
• IvorySQL official website: https://github.com/IvorySQL/Ivory-www

Contributors

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

• Dapeng Wang
• Grant Zhou
• Shiji Niu
• Shuntian Jiao
• Xinjie Lv
• Xueyu Gao
• Zhenhao Pan
• Zheng Tao

Complete Changelog