oci_psql_db_system

This resource provides the Db System resource in Oracle Cloud Infrastructure Psql service. Api doc link for the resource: https://docs.oracle.com/iaas/api/#/en/postgresql/latest/DbSystem

Example terraform configs related to the resource : https://github.com/oracle/terraform-provider-oci/tree/master/examples/psql

Creates a new database system.

Example Usage

resource "oci_psql_db_system" "test_db_system" {
	#Required
	compartment_id = var.compartment_id
	db_version = var.db_system_db_version
	display_name = var.db_system_display_name
	network_details {
		#Required
		subnet_id = oci_core_subnet.test_subnet.id

		#Optional
		is_reader_endpoint_enabled = var.db_system_network_details_is_reader_endpoint_enabled
		nsg_ids = var.db_system_network_details_nsg_ids
		primary_db_endpoint_private_ip = var.db_system_network_details_primary_db_endpoint_private_ip
	}
	shape = var.db_system_shape
	storage_details {
		#Required
		is_regionally_durable = var.db_system_storage_details_is_regionally_durable
		system_type = var.db_system_storage_details_system_type

		#Optional
		availability_domain = var.db_system_storage_details_availability_domain
		iops = var.db_system_storage_details_iops
	}

	#Optional
	config_id = oci_apm_config_config.test_config.id
	credentials {
		#Required for stand alone dbsystem
		#Optional for standby dbsystem
		password_details {
			#Required
			password_type = var.db_system_credentials_password_details_password_type

			#Optional
			password = var.db_system_credentials_password_details_password
			secret_id = oci_vault_secret.test_secret.id
			secret_version = var.db_system_credentials_password_details_secret_version
		}
		username = var.db_system_credentials_username
	}
	defined_tags = {"foo-namespace.bar-key"= "value"}
	description = var.db_system_description
	freeform_tags = {"bar-key"= "value"}
	instance_count = var.db_system_instance_count
	instance_memory_size_in_gbs = var.db_system_instance_memory_size_in_gbs
	instance_ocpu_count = var.db_system_instance_ocpu_count
	instances_details {

		#Optional
		description = var.db_system_instances_details_description
		display_name = var.db_system_instances_details_display_name
		private_ip = var.db_system_instances_details_private_ip
	}
	management_policy {

		#Optional
		backup_policy {

			#Optional
			backup_start = var.db_system_management_policy_backup_policy_backup_start
			copy_policy {
				#Required
				compartment_id = var.compartment_id

				#Optional
				regions = var.db_system_management_policy_backup_policy_copy_policy_regions
				retention_period = var.db_system_management_policy_backup_policy_copy_policy_retention_period
			}
			days_of_the_month = var.db_system_management_policy_backup_policy_days_of_the_month
			days_of_the_week = var.db_system_management_policy_backup_policy_days_of_the_week
			kind = var.db_system_management_policy_backup_policy_kind
			retention_days = var.db_system_management_policy_backup_policy_retention_days
		}
		maintenance_window_start = var.db_system_management_policy_maintenance_window_start
	}
	odsp_insight_details {
		#Required
		kind = var.db_system_odsp_insight_details_kind

		#Optional
		odsp_insight_list {

			#Optional
			insight_type = var.db_system_odsp_insight_details_odsp_insight_list_insight_type
			retention_period_in_days = var.db_system_odsp_insight_details_odsp_insight_list_retention_period_in_days
		}
	}
	replication_config {

		#Optional
		is_rpo_enforced = var.db_system_replication_config_is_rpo_enforced
		rpo_in_seconds = var.db_system_replication_config_rpo_in_seconds
	}
	source {
		#Required
		source_type = var.db_system_source_source_type

		#Optional
		backup_id = oci_psql_backup.test_backup.id
		is_having_restore_config_overrides = var.db_system_source_is_having_restore_config_overrides
		primary_db_system_id = oci_psql_db_system.test_db_system.id
	}
	system_type = var.db_system_system_type

	# Optional
	patch_operations {
		#Required
		operation = var.db_system_patch_operations_operation
		selection = var.db_system_patch_operations_selection

		#Optional
		value = var.db_system_patch_operations_value
	}
}

Argument Reference

The following arguments are supported:

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

Attributes Reference

The following attributes are exported:

Timeouts

The timeouts block allows you to specify timeouts for certain operations: * create - (Defaults to 1 hour), when creating the Db System * update - (Defaults to 1 hour), when updating the Db System * delete - (Defaults to 1 hour), when destroying the Db System

Import

DbSystems can be imported using the id, e.g.

$ terraform import oci_psql_db_system.test_db_system "id"