Contact UsTry it for free
© 2026 Direct Cursus Technology L.L.C.

Managing Sharded PostgreSQL shards

Written by
Updated at January 22, 2026

Note

The service is at the Preview stage.

Creating a shard

Yandex Managed Service for PostgreSQL shards are based on existing Managed Service for PostgreSQL clusters residing in the same folder and cloud network as the Sharded PostgreSQL cluster.

  1. Navigate to the folder dashboard and select Yandex Managed Service for Sharded PostgreSQL.
  2. Click the name of your cluster and select the Shards tab.
  3. Click Create shard.
  4. Specify a shard name and select the PostgreSQL cluster whose hosts will serve as data hosts in the Sharded PostgreSQL cluster.
  5. Click Create.

  1. Get an IAM token for API authentication and put it into an environment variable:

    export IAM_TOKEN="<IAM_token>"

  2. Call the Cluster.AddShard method, e.g., via the following cURL request:

    curl \
  --request POST \
  --header "Authorization: Bearer $IAM_TOKEN" \
  --header "Content-Type: application/json" \
  --url 'https://mdb.api.cloud.yandex.net/managed-spqr/v1/clusters/<cluster_ID>/shards' \
  --data '{
            "shardSpec": {
              "shardName": "<shard_name>",
              "mdbPostgresql": {
                "clusterId": "<PostgreSQL_cluster_ID>"
              }
            }
          }'

    Where mdbPostgresql.clusterId is the Managed Service for PostgreSQL cluster ID within the shard.

  3. View the server response to make sure your request was successful.

  1. Get an IAM token for API authentication and put it into an environment variable:

    export IAM_TOKEN="<IAM_token>"

  2. Clone the cloudapi repository:

    cd ~/ && git clone --depth=1 https://github.com/yandex-cloud/cloudapi

    Below, we assume that the repository contents reside in the ~/cloudapi/ directory.

  3. Call the ClusterService.AddShard method, e.g., via the following gRPCurl request:

    grpcurl \
  -format json \
  -import-path ~/cloudapi/ \
  -import-path ~/cloudapi/third_party/googleapis/ \
  -proto ~/cloudapi/yandex/cloud/mdb/spqr/v1/cluster_service.proto \
  -rpc-header "Authorization: Bearer $IAM_TOKEN" \
  -d '{
        "cluster_id": <cluster_ID>
        "shard_spec": {
          "shard_name": "<shard_name>",
          "mdb_postgresql": {
            "cluster_id": "<PostgreSQL_cluster_ID>"
          }
        }
      }' \
  mdb.api.cloud.yandex.net:443 \
  yandex.cloud.mdb.spqr.v1.ClusterService.AddShard

    Where mdb_postgresql.cluster_id is the Managed Service for PostgreSQL cluster ID within the shard.

Deleting a shard

Deleting a Sharded PostgreSQL shard does not affect the Managed Service for PostgreSQL cluster.

  1. Navigate to the folder dashboard and select Yandex Managed Service for Sharded PostgreSQL.
  2. Click the name of your cluster and select the Shards tab.
  3. Click the icon in the shard row and select Delete.
  4. In the window that opens, click Delete.

  1. Get an IAM token for API authentication and put it into an environment variable:

    export IAM_TOKEN="<IAM_token>"

  2. Call the Cluster.DeleteShard method, e.g., via the following cURL request:

    curl \
  --request DELETE \
  --header "Authorization: Bearer $IAM_TOKEN" \
  --header "Content-Type: application/json" \
  --url 'https://mdb.api.cloud.yandex.net/managed-spqr/v1/clusters/<cluster_ID>/shards/<shard_name>'

  3. View the server response to make sure your request was successful.

  1. Get an IAM token for API authentication and put it into an environment variable:

    export IAM_TOKEN="<IAM_token>"

  2. Clone the cloudapi repository:

    cd ~/ && git clone --depth=1 https://github.com/yandex-cloud/cloudapi

    Below, we assume that the repository contents reside in the ~/cloudapi/ directory.

  3. Call the ClusterService.DeleteShard method, e.g., via the following gRPCurl request:

    grpcurl \
  -format json \
  -import-path ~/cloudapi/ \
  -import-path ~/cloudapi/third_party/googleapis/ \
  -proto ~/cloudapi/yandex/cloud/mdb/spqr/v1/cluster_service.proto \
  -rpc-header "Authorization: Bearer $IAM_TOKEN" \
  -d '{
        "cluster_id": <cluster_ID>,
        "shard_name": "<shard_name>"
      }' \
  mdb.api.cloud.yandex.net:443 \
  yandex.cloud.mdb.spqr.v1.ClusterService.DeleteShard

  4. View the server response to make sure your request was successful.

Previous
Updating a cluster
Next
Deleting a cluster