terraform state show google sql database instance.MyINSTANCE
Jump to navigation
Jump to search
terraform state show google sql database instance.MyINSTANCE terraform state show google sql database instance.MyINSTANCE | grep first_ip_address
# 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"
}
}
}
Related
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:
