PostgreSQL DBaaS

The e2e_dbaas_postgresql resource allows you to provision and manage PostgreSQL-based DBaaS (Database as a Service) clusters within your E2E cloud environment.

Applying this resource creates a new PostgreSQL DBaaS instance. Destroying it removes the instance.

Example Usage

resource "e2e_dbaas_postgresql" "db1" {
  location     = "Delhi"
  project_id   = 12345
  plan         = "DBS.16GB"
  version      = "15.0"
  name         = "mydbname"

  database {
    user         = "admin"
    password     = "SecurePasswordItis@123"
    name         = "mydb"
    dbaas_number = 1
  }

  vpcs = [e2e_vpc.VPC-TS-01.id]
}

resource "e2e_vpc" "VPC-TS-01" {
  location    = "Delhi"
  vpc_name    = "VPC-TS-01"
  project_id  = "your_project_id"
}

Schema

Required Attributes

• location (String): Region in which the DBaaS instance will be deployed.
• project_id (String): The project ID associated with the DBaaS.
• plan (String): The DBaaS plan (e.g., "DBS.16GB").
• version (String): Desired PostgreSQL version (e.g., "15.0").
• name (String): Name of the DBaaS instance.
• database (Block): Configuration block for the database (see Database Block).

Optional Attributes

• group (String): Group name for organizing resources. Defaults to "Default".
• parameter_group_id (Number): ID of the parameter group.
• public_ip_required (Boolean): Whether a public IP is required. Defaults to true.
• detach_public_ip (Boolean): Set to true or false to detach or reattach the public IP.
• power_status (String): Power control operation. Accepts: "start", "stop", "restart"
• size (Number): Disk size (in GB) for upgrades. Note: Instance must be stopped for upgrade.
• vpc_list (Set of Number): List of VPC IDs to attach. Remove an ID to detach a VPC.
• is_encryption_enabled (Boolean): Enable encryption. Defaults to false. Must be added only during creation of an instance.

Read-Only Attributes

• id (String): Unique ID of the DBaaS instance.
• status (String): Current status of the DBaaS.
• status_title (String): Human-readable status.
• status_actions (List of String): Permissible operations (e.g., delete, stop, restart).
• num_instances (Number): Number of database instances in the cluster.
• project_name (String): Name of the project.
• snapshot_exist (Boolean): Indicates if snapshots exist.
• connectivity_detail (String): Read/write connectivity information.
• vector_database_status (String): Status of the vector database feature.

Nested Block

Required Fields

• user (String): Username for the database.
• password (String): Password for the DB user.
• name (String): Name of the database.

Optional Fields

• dbaas_number (Number): Number of instances to provision. Defaults to 1.