Difference between revisions of "Terraform state show google sql database instance.MyINSTANCE"
Jump to navigation
Jump to search
(Created page with "{{lc}} == See also == * {{tf files}} * {{terraform state cmd}} Category:Terraform") |
|||
| Line 1: | Line 1: | ||
{{lc}} | {{lc}} | ||
| + | |||
| + | # google_sql_database_instance.data-lake-db-instance: | ||
| + | resource "google_sql_database_instance" "MyDBInstance" { | ||
| + | available_maintenance_versions = [] | ||
| + | connection_name = "project:[[europe-west3]]:MyDBInstance" | ||
| + | database_version = "POSTGRES_11" | ||
| + | [[deletion_protection]] = true | ||
| + | first_ip_address = "11.198.184.11" | ||
| + | id = "MyDBInstance" | ||
| + | ip_address = [ | ||
| + | { | ||
| + | ip_address = "11.198.184.11" | ||
| + | time_to_retire = "" | ||
| + | type = "PRIMARY" | ||
| + | }, | ||
| + | { | ||
| + | ip_address = "13.198.184.11" | ||
| + | time_to_retire = "" | ||
| + | type = "OUTGOING" | ||
| + | }, | ||
| + | ] | ||
| + | maintenance_version = "POSTGRES_11_16.R20220710.01_08" | ||
| + | name = "MyDBInstance" | ||
| + | project = "my-project" | ||
| + | public_ip_address = "11.198.184.11" | ||
| + | region = "europe-west3" | ||
| + | self_link = "https://sqladmin.googleapis.com/sql/v1beta4/projects/elucidate-co/instances/11.198.184.11" | ||
| + | server_ca_cert = [ | ||
| + | { | ||
| + | cert = <<-EOT | ||
| + | -----BEGIN CERTIFICATE----- | ||
| + | MIIDfzCCAmegAwIBAgIBADANBgkqhkiG9w0BAQsFADB3MS0wKwYDVQQuEyQ1N2Y0 | ||
| + | .../... | ||
| + | NUVv5c91zRP7h0oAGI/VH6g3ceLzu4a5yYU0+mhvl4vVYaw3afT48tGuTYcSBet6 | ||
| + | N1rRa3MOdyuRm0kzGR9CIfDPOFXNGl0P/jWATt9eCA0Q6Bo= | ||
| + | -----END CERTIFICATE----- | ||
| + | EOT | ||
| + | common_name = "C=US,O=Google\\, Inc,CN=Google Cloud SQL Server CA,dnQualifier=57f4a222-3168-4b28-937c-xxxxxxxx" | ||
| + | create_time = "2021-12-02T15:27:02.862Z" | ||
| + | expiration_time = "2031-11-30T15:28:02.862Z" | ||
| + | sha1_fingerprint = "0ae9axxxxxxxx" | ||
| + | }, | ||
| + | ] | ||
| + | service_account_email_address = "[email protected]" | ||
| + | |||
| + | settings { | ||
| + | activation_policy = "ALWAYS" | ||
| + | availability_type = "ZONAL" | ||
| + | disk_autoresize = true | ||
| + | disk_autoresize_limit = 0 | ||
| + | disk_size = 10 | ||
| + | disk_type = "PD_SSD" | ||
| + | pricing_plan = "PER_USE" | ||
| + | tier = "db-custom-2-12288" | ||
| + | user_labels = {} | ||
| + | version = 138 | ||
| + | |||
| + | backup_configuration { | ||
| + | binary_log_enabled = false | ||
| + | enabled = false | ||
| + | point_in_time_recovery_enabled = false | ||
| + | start_time = "02:00" | ||
| + | transaction_log_retention_days = 7 | ||
| + | |||
| + | backup_retention_settings { | ||
| + | retained_backups = 7 | ||
| + | retention_unit = "COUNT" | ||
| + | } | ||
| + | } | ||
| + | |||
| + | database_flags { | ||
| + | name = "temp_file_limit" | ||
| + | value = "2147483647" | ||
| + | } | ||
| + | |||
| + | ip_configuration { | ||
| + | ipv4_enabled = true | ||
| + | require_ssl = false | ||
| + | |||
| + | authorized_networks { | ||
| + | name = "11.198.184.11" | ||
| + | value = "34.198.184.34" | ||
| + | } | ||
| + | authorized_networks { | ||
| + | name = "xx.xx.xx.xx" | ||
| + | value = "xx.xx.xx.xx" | ||
| + | } | ||
| + | authorized_networks { | ||
| + | name = "xx.xx.xx.xx" | ||
| + | value = "xx.xx.xx.xx" | ||
| + | } | ||
| + | authorized_networks { | ||
| + | name = "xx.xx.xx.xx" | ||
| + | value = "xx.xx.xx.xx" | ||
| + | } | ||
| + | authorized_networks { | ||
| + | name = "xx.xx.xx.xx" | ||
| + | value = "xx.xx.xx.xx" | ||
| + | } | ||
| + | authorized_networks { | ||
| + | name = "xx.xx.xx.xx" | ||
| + | value = "xx.xx.xx.xx" | ||
| + | } | ||
| + | authorized_networks { | ||
| + | name = "xx.xx.xx.xx" | ||
| + | value = "xx.xx.xx.xx" | ||
| + | } | ||
| + | authorized_networks { | ||
| + | name = "xx.xx.xx.xx" | ||
| + | value = "xx.xx.xx.xx" | ||
| + | } | ||
| + | authorized_networks { | ||
| + | name = "xx.xx.xx.xx" | ||
| + | value = "xx.xx.xx.xx" | ||
| + | } | ||
| + | authorized_networks { | ||
| + | name = "35.198.96.150" | ||
| + | value = "35.198.96.150" | ||
| + | } | ||
| + | } | ||
| + | |||
| + | location_preference { | ||
| + | zone = "europe-west3-a" | ||
| + | } | ||
| + | } | ||
| + | } | ||
Revision as of 08:10, 27 October 2022
# google_sql_database_instance.data-lake-db-instance:
resource "google_sql_database_instance" "MyDBInstance" {
available_maintenance_versions = []
connection_name = "project:europe-west3:MyDBInstance"
database_version = "POSTGRES_11"
deletion_protection = true
first_ip_address = "11.198.184.11"
id = "MyDBInstance"
ip_address = [
{
ip_address = "11.198.184.11"
time_to_retire = ""
type = "PRIMARY"
},
{
ip_address = "13.198.184.11"
time_to_retire = ""
type = "OUTGOING"
},
]
maintenance_version = "POSTGRES_11_16.R20220710.01_08"
name = "MyDBInstance"
project = "my-project"
public_ip_address = "11.198.184.11"
region = "europe-west3"
self_link = "https://sqladmin.googleapis.com/sql/v1beta4/projects/elucidate-co/instances/11.198.184.11"
server_ca_cert = [
{
cert = <<-EOT
-----BEGIN CERTIFICATE-----
MIIDfzCCAmegAwIBAgIBADANBgkqhkiG9w0BAQsFADB3MS0wKwYDVQQuEyQ1N2Y0
.../...
NUVv5c91zRP7h0oAGI/VH6g3ceLzu4a5yYU0+mhvl4vVYaw3afT48tGuTYcSBet6
N1rRa3MOdyuRm0kzGR9CIfDPOFXNGl0P/jWATt9eCA0Q6Bo=
-----END CERTIFICATE-----
EOT
common_name = "C=US,O=Google\\, Inc,CN=Google Cloud SQL Server CA,dnQualifier=57f4a222-3168-4b28-937c-xxxxxxxx"
create_time = "2021-12-02T15:27:02.862Z"
expiration_time = "2031-11-30T15:28:02.862Z"
sha1_fingerprint = "0ae9axxxxxxxx"
},
]
service_account_email_address = "[email protected]"
settings {
activation_policy = "ALWAYS"
availability_type = "ZONAL"
disk_autoresize = true
disk_autoresize_limit = 0
disk_size = 10
disk_type = "PD_SSD"
pricing_plan = "PER_USE"
tier = "db-custom-2-12288"
user_labels = {}
version = 138
backup_configuration {
binary_log_enabled = false
enabled = false
point_in_time_recovery_enabled = false
start_time = "02:00"
transaction_log_retention_days = 7
backup_retention_settings {
retained_backups = 7
retention_unit = "COUNT"
}
}
database_flags {
name = "temp_file_limit"
value = "2147483647"
}
ip_configuration {
ipv4_enabled = true
require_ssl = false
authorized_networks {
name = "11.198.184.11"
value = "34.198.184.34"
}
authorized_networks {
name = "xx.xx.xx.xx"
value = "xx.xx.xx.xx"
}
authorized_networks {
name = "xx.xx.xx.xx"
value = "xx.xx.xx.xx"
}
authorized_networks {
name = "xx.xx.xx.xx"
value = "xx.xx.xx.xx"
}
authorized_networks {
name = "xx.xx.xx.xx"
value = "xx.xx.xx.xx"
}
authorized_networks {
name = "xx.xx.xx.xx"
value = "xx.xx.xx.xx"
}
authorized_networks {
name = "xx.xx.xx.xx"
value = "xx.xx.xx.xx"
}
authorized_networks {
name = "xx.xx.xx.xx"
value = "xx.xx.xx.xx"
}
authorized_networks {
name = "xx.xx.xx.xx"
value = "xx.xx.xx.xx"
}
authorized_networks {
name = "35.198.96.150"
value = "35.198.96.150"
}
}
location_preference {
zone = "europe-west3-a"
}
}
}
See also
- Terraform configuration files, Terraform state files:
.tf,.tfvars,main.tf, outputs.tf,variables.tf,.terraform.d/,terraform init,providers.tf,.terraform/,terraform.tfstate,.terraform.lock.hcl,terraform.tfstate.d, override.tf, versions.tf - Terraform state:
terraform state[list|mv|show|pull|push|rm|replace-provider],terraform state show module.alb.aws lb.this
Advertising:
