ClickHouse Managed Postgres: RBAC, Terraform, and More

Unified Data Platform Evolution

ClickHouse's aggressive expansion into managed Postgres is a strategic play to position ClickHouse Cloud as a comprehensive data platform, bridging the gap between OLTP and OLAP workloads. The raft of recent updates, including fine-grained RBAC, a polished console, and Terraform provider (albeit in alpha), demonstrates a clear commitment to enterprise readiness and developer experience. The integration of Stripe for provisioning and ClickPipes for seamless Postgres-to-Postgres migrations with automated schema handling are particularly noteworthy, addressing common pain points in data infrastructure management. Furthermore, the proactive capacity reservation on AWS to combat AI-driven compute demand is a prescient move, aiming to ensure reliability for users. The optimization of extensions like pg_clickhouse and pg_stat_ch using a leaner C library is a testament to their focus on performance and stability.

However, the alpha status of the Terraform provider means it's not yet production-ready for all use cases, which might delay adoption for teams heavily invested in Infrastructure as Code. While the unified billing and usage metering are excellent steps towards transparency, the initial beta pricing needs to be competitive to attract and retain users against established managed Postgres providers. The article highlights the push towards a unified platform, but the actual depth of this unification, especially in terms of cross-service query optimization and transactional consistency between Postgres and ClickHouse, warrants deeper technical exploration. The success of this strategy will hinge on how seamlessly these disparate services (OLTP Postgres and OLAP ClickHouse) can operate together, beyond just data ingestion and basic query layering.

Key Points

• ClickHouse Cloud is enhancing its managed Postgres offering to become a unified OLTP + OLAP data platform.
• Key new features include fine-grained Role-Based Access Control (RBAC) for per-service permissions.
• A redesigned console provides a more intuitive user experience with at-a-glance service health and resource usage.
• An alpha Terraform provider allows for managing Postgres instances as code, integrating with existing ClickHouse Cloud infrastructure.
• ClickPipes now support Postgres-to-Postgres migrations with automated schema migration, and PeerDB is handling post-migration steps.
• Usage metering and billing for Postgres services are integrated into the existing ClickHouse Cloud billing pipeline for a consolidated view.
• Proactive dynamic capacity reservations on AWS are implemented to ensure instance availability, especially for larger types, mitigating AI demand impact.
• Extensions like pg_clickhouse and pg_stat_ch have been optimized for stability and performance by moving to a leaner C library.

---

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