Version 4.5.0

Released on 2021-03-23.


If you are upgrading a cluster, you must be running CrateDB 4.0.2 or higher before you upgrade to 4.5.0.

We recommend that you upgrade to the latest 4.3 release before moving to 4.5.0.

A rolling upgrade from 4.3.x to 4.5.0 is supported.

Before upgrading, you should back up your data.

Table of Contents


  • The table setting soft_deletes.enabled has been marked as deprecated and will be removed in a future version. Soft deletes will become mandatory in CrateDB 5.0.



Performance improvements

  • Optimized how NULL values are stored, reducing the amount of disk space required. This can also improve the performance of value lookups on tables with a lot of null values.

SQL and PostgreSQL compatibility improvements

  • Added the regclass data type for improved compatibility with PostgreSQL tools.

  • Added an empty pg_tablespace table in the pg_catalog schema for improved support for PostgreSQL tools.

  • Improved the error messages for cast errors for values of type object.

  • Added support for the CREATE TABLE AS statement.

Administration and Operations

  • Added support for restoring metadata and settings from snapshots. If ALL is used, everything (tables, settings, views, etc.) will be restored. On the other hand, using TABLES will only restore tables. In previous releases, only tables could be restored, even if ALL was used.

  • Improved language selection, translations and general usability at the Admin UI.

  • Updated the bundled JDK to 16+36