v.23.11Improvement

Fix PostgreSQL replication error in MaterializedPostgreSQL

Official CH changelog text
Fix possible postgresql logical replication conversion error when using experimental MaterializedPostgreSQL. #53721 (takakawa).
Fixes a potential error in logical replication data type conversion when using the experimental MaterializedPostgreSQL engine in ClickHouse.

Why it matters

The fix addresses issues that could occur during PostgreSQL logical replication, specifically conversion errors while using the experimental MaterializedPostgreSQL feature. This ensures more reliable and accurate data replication from PostgreSQL to ClickHouse.

How to use it

Use the experimental MaterializedPostgreSQL engine as usual for logical replication from PostgreSQL. This update automatically resolves the conversion error; no additional configuration is needed.

Related resources

PreviousNext