yandex_mdb_sharded_postgresql_shard (Resource)
Written by
Updated at September 11, 2025
Manages a Sharded PostgreSQL shard within the Yandex.Cloud
Example usage
//
// Create a new MDB Sharded PostgreSQL database User.
//
resource "yandex_mdb_sharded_postgresql_shard" "shard1" {
cluster_id = yandex_mdb_sharded_postgresql_cluster.default.id
name = "shard1"
shard_spec = {
mdb_postgresql = yandex_mdb_postgresql_cluster_v2.shard1.id
}
}
resource "yandex_mdb_sharded_postgresql_cluster" "default" {
name = "test"
environment = "PRESTABLE"
network_id = yandex_vpc_network.foo.id
config = {
sharded_postgresql_config = {
common = {
console_password = "P@ssw0rd"
}
router = {
resources = {
resource_preset_id = "s2.micro"
disk_type_id = "network-ssd"
disk_size = 32
}
}
}
}
hosts = {
"router1" = {
zone = "ru-central1-a"
subnet_id = yandex_vpc_subnet.foo.id
assign_public_ip = false
type = "ROUTER"
}
}
}
resource "yandex_mdb_postgresql_cluster_v2" "shard1" {
name = "shard1"
environment = "PRESTABLE"
network_id = yandex_vpc_network.foo.id
config {
version = 17
resources {
resource_preset_id = "s2.micro"
disk_type_id = "network-ssd"
disk_size = 16
}
}
hosts = {
"first" = {
zone = "ru-central1-a"
subnet_id = yandex_vpc_subnet.foo.id
}
}
}
// Auxiliary resources
resource "yandex_vpc_network" "foo" {}
resource "yandex_vpc_subnet" "foo" {
zone = "ru-central1-d"
network_id = yandex_vpc_network.foo.id
v4_cidr_blocks = ["10.5.0.0/24"]
}
Schema
Required
cluster_id(String) ID of the Sharded PostgreSQL cluster. Provided by the client when the shard is created.name(String) Name of the Sharded PostgreSQL shard. Provided by the client when the shard is added.shard_spec(Attributes) Shard specification required to add shard into cluster. (see below for nested schema)
Read-Only
id(String) The resource identifier.
Nested Schema for shard_spec
Optional:
mdb_postgresql(String) ID of the Managed PostgreSQL cluster in Yandex Cloud. Provided by the client when the shard is added.
Import
The resource can be imported by using their resource ID. For getting the resource ID you can use Yandex Cloud Web Console or YC CLI.
# terraform import yandex_mdb_sharded_postgresql_shard.<resource Name> <resource Id>
terraform import yandex_mdb_sharded_postgresql_shard.my_shard ...