What's new in Postgres Managed by ClickHouse: RBAC, Terraform, ClickPipes, extensions, and more

Postgres managed by ClickHouse entered public beta in May, offering a fully managed, NVMe-backed Postgres service integrated with ClickHouse, and has since introduced numerous enhancements. These updates include fine-grained access control, a redesigned console, Terraform provider, Stripe integration, and usage metering, all aiming to position ClickHouse Cloud as a leading data platform for both OLTP and OLAP workloads. The redesigned console provides a consolidated view of service information and usage metrics, while the introduction of fine-grained access control allows for more tailored permissions. Infrastructure management is facilitated through a new Terraform provider, enabling infrastructure as code, and Stripe integration simplifies payment processes for managed Postgres services. Additionally, Postgres to Postgres migrations are automated with ClickPipes, and the billing system now incorporates usage metering with detailed breakdowns for better cost management. The platform also employs dynamic capacity reservations on AWS to address increased demand, ensuring reliable service provisioning. Furthermore, Postgres extensions such as pg_clickhouse, pg_re2, and pg_stat_ch have been optimized for better performance and stability. These developments underscore a commitment to enhancing capabilities and integrating seamlessly into existing workflows.