v.21.10Improvements

Support Reconnection on Failover for MaterializedPostgreSQL Tables

Support reconnections on failover for MaterializedPostgreSQL tables. Closes #28529. #28614 (Kseniia Sumarokova).
Support automatic reconnections on failover for MaterializedPostgreSQL tables in ClickHouse.

Why it matters

This feature addresses the issue of MaterializedPostgreSQL tables losing connection during PostgreSQL failover events. It enhances reliability by enabling automatic reconnections, ensuring continuous data replication and minimizing downtime for users.

How to use it

The reconnection functionality is integrated into the existing MaterializedPostgreSQL table engine. Users do not need to change table definitions; the system will automatically attempt to reconnect upon failover scenarios without additional configuration.