Difference between revisions of "Terraform state show google sql database instance.MyINSTANCE"

From wikieduonline
Jump to navigation Jump to search
(Created page with "{{lc}} == See also == * {{tf files}} * {{terraform state cmd}} Category:Terraform")
 
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{lc}}
 
{{lc}}
  
 +
[[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 ==
 +
* <code>[[psql]]</code>
  
  

Latest revision as of 08:12, 27 October 2022

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[edit]


See also[edit]

Retrieved from "https://www.wikieduonline.com/index.php?title=Terraform_state_show_google_sql_database_instance.MyINSTANCE&oldid=194197"

Advertising: