Перейти к основному содержимому
selectel_dbaas_extension_v1
Последнее изменение:

selectel_dbaas_extension_v1

Creates and manages a PostgreSQL extension using public API v1. Applicable to PostgreSQL, PostgreSQL for 1C, and PostgreSQL TimescaleDB datastores. For more information about extensions, see the official Selectel documentation for PostgreSQL, PostgreSQL for 1C, and PostgreSQL TimescaleDB.

Example usage⁠

resource "selectel_dbaas_postgresql_extension_v1" "extension_1" {
  project_id             = selectel_vpc_project_v2.project_1.id
  region                 = "ru-3"
  datastore_id           = selectel_dbaas_postgresql_datastore_v1.datastore_1.id
  database_id            = selectel_dbaas_postgresql_database_v1.database_1.id
  available_extension_id = data.selectel_dbaas_available_extension_v1.ae.available_extensions[0].id
}

Argument Reference⁠

  • project_id - (Required) Unique identifier of the associated Cloud Platform project. Changing this creates a new extension. Retrieved from the selectel_vpc_project_v2 resource. Learn more about Cloud Platform projects.

  • region - (Required) Pool where the database is located, for example, ru-3. Changing this creates a new extension. Learn more about available pools in the Availability matrix.

  • datastore_id - (Required) Unique identifier of the associated datastore. Changing this creates a new extension. Retrieved from the selectel_dbaas_postgresql_datastore_v1.

  • database_id - (Required) Unique identifier of the associated database. Changing this creates a new extension. Retrieved from the selectel_dbaas_postgresql_database_v1 resource.

  • available_extension_id - (Required) Unique identifier of the available extension that you want to create. Changing this creates a new extension. Retrieved from the selectel_dbaas_available_extension_v1 data source.

Attributes Reference⁠

  • status - Status of the extension.

Import⁠

You can import an extension:

export OS_DOMAIN_NAME=<account_id>
export OS_USERNAME=<username>
export OS_PASSWORD=<password>
export SEL_PROJECT_ID=<selectel_project_id>
export SEL_REGION=<selectel_pool>
terraform import selectel_dbaas_postgresql_extension_v1.extension_1 <extension_id>

where:

  • <account_id> — Selectel account ID. The account ID is in the top right corner of the Control panel. Learn more about Registration.

  • <username> — Name of the service user. To get the name, in the top right corner of the Control panel, go to the account menu ⟶ Profile and Settings ⟶ User management ⟶ the Service users tab ⟶ copy the name of the required user. Learn more about Service users.

  • <password> — Password of the service user.

  • <selectel_project_id> — Unique identifier of the associated Cloud Platform project. To get the project ID, in the Control panel, go to Cloud Platform ⟶ project name ⟶ copy the ID of the required project. Learn more about Cloud Platform projects.

  • <selectel_pool> — Pool where the cluster is located, for example, ru-3. To get information about the pool, in the Control panel, go to Cloud Platform ⟶ Managed Databases. The pool is in the Pool column.

  • <extension_id> — Unique identifier of the extension, for example, b311ce58-2658-46b5-b733-7a0f418703f2. To get the extension ID, use Selectel Cloud Management API.