> For the complete documentation index, see [llms.txt](https://docs.ionos.com/terraform-provider/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ionos.com/terraform-provider/resources/pg_cluster_v2.md). # ionoscloud\_pg\_cluster\_v2 Manages a DBaaS PostgreSQL v2 Cluster. ## Example Usage ```hcl locals { location = "de/txl" } data "ionoscloud_pg_backup_location_v2" "example" { location = local.location } resource "ionoscloud_datacenter" "example" { name = "example" location = local.location } resource "ionoscloud_lan" "example" { datacenter_id = ionoscloud_datacenter.example.id public = false name = "example" } resource "ionoscloud_pg_cluster_v2" "example" { name = "PostgreSQL_cluster" description = "Production PostgreSQL cluster" version = "17" location = local.location replication_mode = "ASYNCHRONOUS" backup = { location = "eu-central-3" retention_days = 7 } connection_pooler = "DISABLED" logs_enabled = true metrics_enabled = true instances = { count = 1 cores = 2 ram = 4 storage_size = 10 } connections = { datacenter_id = ionoscloud_datacenter.example.id lan_id = ionoscloud_lan.example.id primary_instance_address = "192.168.1.100/24" } maintenance_window = { time = "09:00:00" day_of_the_week = "Sunday" } credentials = { username = "username" password = ephemeral.random_password.cluster_password.result password_version = "1" database = "mydb" } timeouts { create = "60m" update = "60m" delete = "60m" } } ephemeral "random_password" "cluster_password" { length = 16 special = true override_special = "@$!%*?&" } ``` ## Argument reference * `name` - (Required)\[string] The name of the PostgreSQL cluster. * `description` - (Optional)\[string] Human-readable description for the cluster. * `version` - (Required)\[string] The PostgreSQL version of the cluster. * `location` - (Required, RequiresReplace)\[string] The location of the PostgreSQL cluster. This is used for routing to the regional API endpoint. Changing this value will destroy the existing cluster and create a new one in the specified location. Available locations: `de/fra`, `de/fra/2`, `de/txl`, `es/vit`, `fr/par`, `gb/bhx`, `gb/lhr`, `us/ewr`, `us/las`, `us/mci`. * `backup` - (Required)\[object] Backup location and retention configuration. * `location` - (Required)\[string] The Object Storage location where the backups will be created. Supported locations are provided by the `ionoscloud_pg_backup_location_v2` data source. Immutable — changing this forces a new cluster. * `retention_days` - (Required)\[int] How many days cluster backups are retained. * `replication_mode` - (Required)\[string] Replication mode across the instances. Possible values: `ASYNCHRONOUS`, `STRICTLY_SYNCHRONOUS`. * `connection_pooler` - (Optional)(Computed)\[string] Defines how database connections are managed and reused. Possible values: `DISABLED`, `TRANSACTION`, `SESSION`. * `logs_enabled` - (Optional)(Computed)\[bool] Enables or disables the collection and reporting of logs for observability of this cluster. * `metrics_enabled` - (Optional)(Computed)\[bool] Enables or disables the collection and reporting of metrics for observability of this cluster. * `instances` - (Required)\[object] The instance configuration for the PostgreSQL cluster. * `count` - (Required)\[int] The total number of instances in the cluster (one primary and n-1 secondary). * `cores` - (Required)\[int] The number of CPU cores per instance. * `ram` - (Required)\[int] The amount of memory per instance in gigabytes (GB). * `storage_size` - (Required)\[int] The amount of storage per instance in gigabytes (GB). * `connections` - (Required)\[object] Connection information of the PostgreSQL cluster. * `datacenter_id` - (Required)\[string] The datacenter to connect your instance to. * `lan_id` - (Required)\[string] The numeric LAN ID to connect your instance to. * `primary_instance_address` - (Required)\[string] The IP and netmask that will be assigned to the cluster primary instance. * `maintenance_window` - (Required)\[object] A weekly 4 hour-long window, during which maintenance might occur. * `time` - (Required)\[string] Start of the maintenance window in UTC time. * `day_of_the_week` - (Required)\[string] The name of the week day. * `credentials` - (Required)\[object] Credentials for the master database user to be created. * `username` - (Required)\[string] The username of the master database user. * `password` - (Required, Sensitive, WriteOnly)\[string] The password for the master database user. This value is never stored in Terraform state. Requires Terraform 1.11+. * `password_version` - (Required)\[string] An arbitrary string (e.g. `"1"`, `"2"`) stored in Terraform state solely to trigger password updates. Increment this value whenever the write-only `password` field changes so Terraform detects a diff and sends the new password to the API. * `database` - (Required)\[string] The name of the initial database to be created. * `restore_from_backup` - (Optional)\[object] Configures the cluster to be initialized with data from an existing backup. * `source_backup_id` - (Required)\[string] The UUID of the backup to restore data from. Immutable — changing this forces a new cluster. * `recovery_target_datetime` - (Optional)\[string] If supplied as ISO 8601 timestamp, the backup will be replayed up until the given timestamp. If empty, the backup will be applied completely. * `dns_name` - (Computed)\[string] The DNS name used to access the cluster. ## Timeouts This resource supports the following `Timeouts` configuration options: * `create` - (Default `60m`) Time to wait for the cluster to be provisioned. * `update` - (Default `60m`) Time to wait for the cluster to be updated. * `delete` - (Default `60m`) Time to wait for the cluster to be deleted. ## Import In Terraform v1.12.0 and later, the [`import` block](https://developer.hashicorp.com/terraform/language/import) can be used with the `identity` attribute. For example: ```hcl import { to = ionoscloud_pg_cluster_v2.example identity = { id = "cluster_uuid" location = "de/txl" } } resource "ionoscloud_pg_cluster_v2" "example" { ### Configuration omitted for brevity ### } ``` ### Identity Schema #### Required * `id` (String) The UUID of the cluster. * `location` (String) The location of the cluster (e.g. `de/txl`). *** A cluster can also be imported using the format `location:cluster_id`: ```shell terraform import ionoscloud_pg_cluster_v2.mycluster de/txl:cluster_uuid ``` ## Query (List Resource) PostgreSQL v2 clusters can be listed using `terraform query` (requires Terraform 1.14+). List blocks must be placed in a dedicated `tfquery.hcl` file. ```hcl list "ionoscloud_pg_cluster_v2" "all" { provider = ionoscloud include_resource = true } ``` Filter by name and location: ```hcl list "ionoscloud_pg_cluster_v2" "prod" { provider = ionoscloud include_resource = true config { filters = [ { field_name = "name", field_value = "my-cluster" }, { field_name = "location", field_value = "de/txl" }, ] } } ``` See the [ionoscloud\_pg\_cluster\_v2 list resource](/terraform-provider/list-resources/psql_cluster_v2.md) documentation for the full filter reference. --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.ionos.com/terraform-provider/resources/pg_cluster_v2.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.