v.23.10Improvement
Allow Multiple MaterializedPostgreSQL Tables per Postgres Table
Allow to have severalMaterializedPostgreSQLtables following the same Postgres table. By default this behaviour is not enabled (for compatibility, because it is a backward-incompatible change), but can be turned on with settingmaterialized_postgresql_use_unique_replication_consumer_identifier. Closes #54918. #55145 (Kseniia Sumarokova).
Why it matters
This feature addresses the limitation where only oneMaterializedPostgreSQL table could replicate from a single PostgreSQL table, improving flexibility for users who need several independent materialized views of the same source table. It is an opt-in change to maintain backward compatibility.How to use it
Enable the feature by settingmaterialized_postgresql_use_unique_replication_consumer_identifier to true in the ClickHouse server settings. This allows multiple materialized tables to consume replication from the same PostgreSQL table independently.