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

Summary

Postgres managed by ClickHouse, which entered public beta in May, received a broad update covering console operations, per-service RBAC, Terraform, Stripe provisioning, ClickPipes migrations, billing, capacity reservations, and extensions. The redesigned console adds service health, resource, and query views, while RBAC provides View and Manage roles across the console and public REST API; the alpha Terraform provider covers lifecycle operations including resizing, HA, replicas, restore, and password rotation. Postgres-to-Postgres ClickPipes now automate schema migration, usage is integrated into ClickHouse Cloud’s metering and billing, and AWS capacity reservations are allocated dynamically across availability zones. Underneath, pg_clickhouse and pg_stat_ch moved to the header-only clickhouse-c library, removing a C++ exception conflict, using Postgres memory contexts, and reducing the x86-64 Linux extension binary from 4.9 MB to 1.4 MB; the update shipped less than a month after beta, with Terraform and extensions still evolving.

Takeaways

1. 1

   Managed Postgres RBAC has View and Manage roles, and list endpoints show users only services they can view; sensitive fields such as connection passwords are hidden from view-only users.

2. 2

   The alpha Terraform provider manages instance creation, resizing, HA changes, configuration, password rotation, streaming read replicas, and point-in-time restore; existing services and CA certificates are exposed as data sources.

3. 3

   Moving pg_clickhouse and pg_stat_ch to clickhouse-c removes the C++ exception-handling conflict, enables direct use of Postgres memory contexts, and reduces the pg_clickhouse binary from 4.9 MB to 1.4 MB on x86-64 Linux.