# Instaclustr PostgreSQL Operations API

**Canonical:** https://apis.io/apis/instaclustr/instaclustr-postgresql-operations-api/  
**Provider:** Instaclustr — https://apis.io/providers/instaclustr/  
**Base URL:** https://api.instaclustr.com  
**Documentation:** https://instaclustr.redoc.ly/Current/

Instaclustr PostgreSQL Operations API is one of 93 APIs that [Instaclustr](https://apis.io/providers/instaclustr/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. This API exposes 12 JSON Schema definitions. Tagged areas include PostgreSQL Operations. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, and 12 JSON Schemas.

Operations related to PostgreSQL.

## Operations (10)

| Method | Path | Summary |
|---|---|---|
| GET | `/cluster-management/v2/operations/applications/postgresql/clusters/v2/{clusterId}/reload` | Get cluster reload operations |
| PUT | `/cluster-management/v2/operations/applications/postgresql/clusters/v2/{clusterId}/update-default-user-password` | Update the default PostgreSQL user password |
| GET | `/cluster-management/v2/operations/applications/postgresql/clusters/{clusterId}/certificate/v3/` | Download PostgreSQL cluster X.509 Certificate Authority certificates |
| POST | `/cluster-management/v2/operations/applications/postgresql/clusters/{clusterId}/extensions/create/{extensionName}/v1` | Trigger an extension instantiate operation |
| POST | `/cluster-management/v2/operations/applications/postgresql/clusters/{clusterId}/extensions/drop/{extensionName}/v1` | Trigger an extension drop operation |
| DELETE | `/cluster-management/v2/operations/applications/postgresql/clusters/{clusterId}/snapshots/{clusterSnapshotId}/v1` | Delete an ad-hoc PostgreSQL cluster snapshot |
| POST | `/cluster-management/v2/operations/applications/postgresql/clusters/{clusterId}/trigger-backup/v3/` | Manually trigger cluster backup |
| GET | `/cluster-management/v2/operations/applications/postgresql/nodes/v2/{nodeId}/reload` | Get node reload operation |
| POST | `/cluster-management/v2/operations/applications/postgresql/nodes/v2/{nodeId}/reload` | Trigger a node reload operation |
| POST | `/cluster-management/v2/operations/applications/postgresql/restore/v3` | Trigger a PostgreSQL Cluster Restore |

## Machine-readable artifacts (14)

- **OpenAPI** — https://artifacts.apis.io/instaclustr/openapi/instaclustr-postgresql-operations-api-openapi.yml
- **Documentation** — https://www.instaclustr.com/support/documentation/
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-open-search-cluster-v2-schema.json
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-kafka-cluster-v3-schema.json
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-cadence-cluster-v2-schema.json
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-cassandra-cluster-v2-schema.json
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-postgresql-cluster-v2-schema.json
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-click-house-integration-s3-fsxn-schema.json
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-cluster-provisioning-request-schema.json
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-data-centre-request-schema.json
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-kafka-cluster-v2-schema.json
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-cluster-details-response-for-terraform-import-schema.json
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-bundle-compatibility-response-schema-schema.json
- **JSONSchema** — https://artifacts.apis.io/instaclustr/json-schema/instaclustr-kafka-topic-v2-schema.json

## Other Instaclustr APIs (12)

- [Instaclustr Account Cluster List V2 API](https://apis.io/apis/instaclustr/instaclustr-account-cluster-list-v2-api/)
- [Instaclustr Apache Cassandra Provisioning V2 API](https://apis.io/apis/instaclustr/instaclustr-apache-cassandra-provisioning-v2-api/)
- [Instaclustr Apache Kafka ACL V2 API](https://apis.io/apis/instaclustr/instaclustr-apache-kafka-acl-v2-api/)
- [Instaclustr Apache Kafka ACL V3 API](https://apis.io/apis/instaclustr/instaclustr-apache-kafka-acl-v3-api/)
- [Instaclustr Apache Kafka Connect Mirror V2 API](https://apis.io/apis/instaclustr/instaclustr-apache-kafka-connect-mirror-v2-api/)
- [Instaclustr Apache Kafka Connect Provisioning V2 API](https://apis.io/apis/instaclustr/instaclustr-apache-kafka-connect-provisioning-v2-api/)
- [Instaclustr Apache Kafka Provisioning V2 API](https://apis.io/apis/instaclustr/instaclustr-apache-kafka-provisioning-v2-api/)
- [Instaclustr Apache Kafka Provisioning V3 API](https://apis.io/apis/instaclustr/instaclustr-apache-kafka-provisioning-v3-api/)
- [Instaclustr Apache Kafka Rest Proxy User API](https://apis.io/apis/instaclustr/instaclustr-apache-kafka-rest-proxy-user-api/)
- [Instaclustr Apache Kafka Schema Registry User API](https://apis.io/apis/instaclustr/instaclustr-apache-kafka-schema-registry-user-api/)
- [Instaclustr Apache Kafka Tiered Storage API](https://apis.io/apis/instaclustr/instaclustr-apache-kafka-tiered-storage-api/)
- [Instaclustr Apache Kafka Topic V2 API](https://apis.io/apis/instaclustr/instaclustr-apache-kafka-topic-v2-api/)

## Tags

PostgreSQL Operations

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/instaclustr/instaclustr-postgresql-operations-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/instaclustr/.