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

From wikieduonline
Jump to navigation Jump to search
 
Line 130: Line 130:
 
  }
 
  }
  
 +
 +
== 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: