alicloud_gpdb_account

Provides a GPDB Account resource.

For information about GPDB Account and how to use it, see What is Account.

-> NOTE: Available since v1.142.0.

Example Usage

Basic Usage

provider "alicloud" {
  region = "cn-hangzhou"
}

variable "name" {
  default = "terraform-example"
}

data "alicloud_gpdb_zones" "default" {}

data "alicloud_vpcs" "default" {
  name_regex = "^default-NODELETING$"
}
data "alicloud_vswitches" "default" {
  vpc_id  = data.alicloud_vpcs.default.ids.0
  zone_id = data.alicloud_gpdb_zones.default.ids.0
}

resource "alicloud_gpdb_instance" "default" {
  db_instance_category  = "HighAvailability"
  db_instance_class     = "gpdb.group.segsdx1"
  db_instance_mode      = "StorageElastic"
  description           = var.name
  engine                = "gpdb"
  engine_version        = "6.0"
  zone_id               = data.alicloud_gpdb_zones.default.ids.0
  instance_network_type = "VPC"
  instance_spec         = "2C16G"
  payment_type          = "PayAsYouGo"
  seg_storage_type      = "cloud_essd"
  seg_node_num          = 4
  storage_size          = 50
  vpc_id                = data.alicloud_vpcs.default.ids.0
  vswitch_id            = data.alicloud_vswitches.default.ids[0]
  ip_whitelist {
    security_ip_list = "127.0.0.1"
  }
}

resource "alicloud_gpdb_account" "default" {
  account_name        = "tf_example"
  db_instance_id      = alicloud_gpdb_instance.default.id
  account_password    = "Example1234"
  account_description = "tf_example"
}

Argument Reference

The following arguments are supported:

• account_description - (Optional) The description of the account.

• account_name - (Required, ForceNew) The account name.

• account_password - (Required) AccountPassword

• account_type - (Optional, ForceNew, Available since v1.230.0) Account type. The value range is as follows:

  Normal: Normal account number.

  Super: a high-privilege account.

• db_instance_id - (Required, ForceNew) The Adb pg instance ID.

• database_name - (Optional, Available since v1.230.0) Database name, with the following restrictions:

  • Can only contain letters, numbers and underscores.
  • Must start with a letter.
  • Length cannot exceed 63 characters.

Attributes Reference

The following attributes are exported:

• id - The ID of the resource supplied above.The value is formulated as <db_instance_id>:<account_name>.
• status - The status of the resource

Timeouts

The timeouts block allows you to specify timeouts for certain actions:

• create - (Defaults to 5 mins) Used when create the Account.
• delete - (Defaults to 5 mins) Used when delete the Account.
• update - (Defaults to 5 mins) Used when update the Account.

Import

GPDB Account can be imported using the id, e.g.

$ terraform import alicloud_gpdb_account.example <db_instance_id>:<account_name>