Managing Sharded PostgreSQL shards

Written by

Updated at February 13, 2026

Creating a shard
Deleting a shard

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.

Warning

For the router to be able to connect to your shard hosts, the Managed Service for Sharded PostgreSQL cluster and the shards and must be in the same security group that allows incoming and outgoing TCP connections to port 6432.

Management console

REST API

gRPC API

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

Get an IAM token for API authentication and place it in an environment variable:
```
export IAM_TOKEN="<IAM_token>"
```

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.

Check the server response to make sure your request was successful.

Get an IAM token for API authentication and place it in an environment variable:
```
export IAM_TOKEN="<IAM_token>"
```
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.

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.

Management console

REST API

gRPC API

Navigate to the folder dashboard and select Yandex Managed Service for Sharded PostgreSQL.
Click the name of your cluster and select the Shards tab.
Find the shard you need in the list, click in its row, and select Delete.
In the window that opens, click Delete.

Get an IAM token for API authentication and place it in an environment variable:
```
export IAM_TOKEN="<IAM_token>"
```

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>'

Check the server response to make sure your request was successful.

Get an IAM token for API authentication and place it in an environment variable:
```
export IAM_TOKEN="<IAM_token>"
```
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.

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

Check the server response to make sure your request was successful.

Managing Sharded PostgreSQL shards

Creating a shardCreating a shard

Deleting a shardDeleting a shard

Was the article helpful?

Creating a shard

Deleting a shard