v.25.7Improvement

Allow backups

Official CH changelog text
Allow backups for PostgreSQL, MySQL and DataLake databases. A backup of such a database would only save the definition and not the data inside of it. #79982 (Nikolay Degterinsky).
Enable backups for external database engines like PostgreSQL, MySQL, and DataLake in ClickHouse, saving only their definitions without data.

Why it matters

This feature allows users to include external database objects (PostgreSQL, MySQL, DataLake) in ClickHouse backup operations, ensuring that the database schema or definitions are preserved. It addresses the limitation where previously these external databases could not be backed up, improving backup completeness for environments integrating multiple database systems.

How to use it

When performing backups in ClickHouse, these external database objects are included automatically, but only their definitions (not the data) are saved. No specific additional user action is required beyond using the standard backup command.

Related resources

PreviousNext