Building an enterprise Postgres service in ClickHouse Cloud

The Postgres managed by ClickHouse service offers a robust, NVMe-backed Postgres database that is seamlessly integrated with ClickHouse, focusing on high availability, reliability, and operational observability for OLTP workloads. This enterprise-grade service features cross-availability zone high availability with synchronous standbys, ensuring durability and failover capabilities, along with a native integration for Change Data Capture (CDC) to replicate data into ClickHouse for real-time analytics. The service includes automatic backups with point-in-time recovery and employs WAL-G for efficient data archiving and retrieval. Security is prioritized through dedicated VPCs for network isolation, ensuring encrypted data both in transit and at rest, along with certificate-based client verification. Furthermore, the platform provides comprehensive monitoring and metrics, with plans to enhance performance insights and expand support for additional cloud providers. As part of its roadmap, the service aims to improve platform maturity with features like storage autoscaling, Terraform support, and seamless Postgres-to-Postgres migrations, reinforcing its position as a unified data stack for scalable applications.