capabilities.work

Restart, promote or switch over a Postgres service

One step with ClickHouse. We can help you get access.

Get something done

Restart, promote or switch over a Postgres service

with ClickHouse · IT Infrastructure Management

Use ClickHouse: its OpenAPI spec for ClickHouse Cloud Postgres API lets you restart, promote or switch over a Postgres service in a single step (PATCH /v1/organizations/{organizationId}/postgres/{postgresId}/state). capabilities.work can help you get signed up and connected.

  • How do I restart a managed Postgres database?
  • Can I promote a Postgres read replica to become the primary?
  • How do I switch a primary over to its standby?
Say it to your AI assistant
  • Restart Postgres service {postgres} in org {org}.
  • Run command {command} on PostgreSQL service {postgres} in organization {org}.
For your developer

PATCH /v1/organizations/{organizationId}/postgres/{postgresId}/state in OpenAPI spec for ClickHouse Cloud Postgres API. Full spec on APIs.io.

More you can do with ClickHouse

List managed Postgres servicesCreate a managed Postgres serviceGet a Postgres service's detailsDelete a Postgres serviceRename or resize a Postgres serviceDownload a Postgres service's CA certificatesRestore a Postgres service to a new serviceReset a Postgres superuser passwordCreate a read replica of a Postgres serviceGet Postgres and PgBouncer configurationReplace all Postgres and PgBouncer configurationChange some Postgres or PgBouncer settings