Upgrades

How PostgreSQL version upgrades work in ClickHouse Managed Postgres

Managed Postgres handles PostgreSQL version upgrades to keep your instances secure and up to date. Both minor and major version upgrades are supported with minimal disruption.

Maintenance updates

Regular maintenance in the PostgreSQL instances includes the following:

• Minor version upgrades (e.g., 17.4 to 17.5) include bug fixes and PostgreSQL engine security patches.
• Managed Service features. Improvements to native CDC, observability, pg_clickhouse, and other extensions.
• Operating system and system components patches. Including security fixes, efficiency, and other improvements.

These are performed via failover and typically result in only a brief disconnect, often lasting just a few seconds.

For instances with standbys enabled, the upgrade is applied to the standby first, followed by a failover to minimize downtime.

Maintenance windows

Default maintenance window is 14:00 to 16:00 UTC on Sunday. Expected downtime is less than 1 minute within the window.

For Enterprise Tier organizations, Managed Postgres supports maintenance windows so that upgrades and other maintenance operations can be scheduled at a time that’s least disruptive to your workload. UI and API support for configuring maintenance windows is coming soon. In the meantime, contact support to set up a maintenance window for your instance.

Major version upgrades

Major version upgrades (e.g., 17.x to 18.x) via UI and API are coming soon. In the meantime, contact support to upgrade your Managed Postgres instance.