[Документация Yandex Cloud](../../index.md) > [Terraform в Yandex Cloud](../index.md) > Справочник Terraform > Ресурсы (англ.) > Managed Service for SPQR > Resources > mdb_sharded_postgresql_shard

# yandex_mdb_sharded_postgresql_shard (Resource)

Manages a Sharded PostgreSQL shard within the Yandex.Cloud

## Example usage

```terraform
//
// 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"]
}
```

## Arguments & Attributes Reference

- `cluster_id` (**Required**)(String). ID of the Sharded PostgreSQL cluster. Provided by the client when the shard is created.
- `id` (*Read-Only*) (String). The resource identifier.
- `name` (**Required**)(String). Name of the Sharded PostgreSQL shard. Provided by the client when the shard is added.
- `shard_spec` [Block]. Shard specification required to add shard into cluster.
  - `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 it you can use Yandex Cloud [Web Console](https://console.yandex.cloud) or Yandex Cloud [CLI](../../cli/quickstart.md).

```shell
# terraform import yandex_mdb_sharded_postgresql_shard.<resource Name> <resource Id>
terraform import yandex_mdb_sharded_postgresql_shard.my_shard ...
```