Difference between revisions of "Gcloud sql instances describe YourInstance"

From wikieduonline
Jump to navigation Jump to search
(Created page with "{{lc}} == See also == * {{gcloud sql}} Category:GCP")
 
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{lc}}
 
{{lc}}
 +
 +
[[gcloud sql instances describe]] YourInstance
 +
 +
backendType: SECOND_GEN
 +
connectionName: yourproject:europe-west3:prod
 +
createTime: '2020-04-05T19:12:22.734Z'
 +
databaseInstalledVersion: [[POSTGRES_11_16]]
 +
databaseVersion: POSTGRES_11
 +
etag: 2e128ab6c656xxdsf53da41455d40259df8e05afdasf
 +
gceZone: europe-west3-b
 +
instanceType: CLOUD_SQL_INSTANCE
 +
ipAddresses:
 +
- ipAddress: 55.242.253.10
 +
  type: PRIMARY
 +
- ipAddress: 55.242.211.10
 +
  type: OUTGOING
 +
- ipAddress: 10.28.32.25
 +
  type: PRIVATE
 +
kind: sql#instance
 +
maintenanceVersion: POSTGRES_11_16.R20220710.01_08
 +
name: YourInstance
 +
project: yourproject
 +
region: [[europe-west3]]
 +
selfLink: https://sqladmin.googleapis.com/sql/v1beta4/projects/yourproject/instances/prod
 +
serverCaCert:
 +
  cert: |-
 +
    -----BEGIN CERTIFICATE-----
 +
    asdgaggdasgBAgIBADANBgkqhkiG9w0BAQsFADB3MS0wKwYDVQQuEyQ5MDc2
 +
    ODgyZS1kZjY4LTQ1YjUtYTJkNS1lOTBhN2ZiNTkxZTgxIzAhBgNVBAMTGkdvb2ds
 +
    .../...
 +
    FfAseyh9oS6phYpWcX+NWohEKO26f6FzuoMdWTXUNNasOvbpAQWOAqvYGh6Cqgxz
 +
    NMd5tvt8v/aIqDf1CvamNdCZHAfOavOlTAPZ0tdYP0XuRDzKiGma5tvgryDMyKqn
 +
    zdGtZqdPPe4ofx2fqUluDgu+EgZBX0RpUNEDe5upquaMoEGuHMSa+gtHfJA8CjoY
 +
    Oz/uBXnWUpOEbfq7poW/eB69Xadfasf
 +
    -----END CERTIFICATE-----
 +
  certSerialNumber: '0'
 +
  commonName: C=US,O=Google\, Inc,CN=Google Cloud SQL Server CA,dnQualifier=907asfadf-df68-45b5-a2d5-e90a7fb591e8
 +
  createTime: '2020-04-05T19:13:20.693Z'
 +
  expirationTime: '2030-04-03T19:14:20.693Z'
 +
  instance: YourInstance
 +
  kind: sql#sslCert
 +
  sha1Fingerprint: gasdfg14b9824aadfasfsdfg0ed7c0f4d7c4a06
 +
[[serviceAccountEmailAddress]]: [email protected]
 +
settings:
 +
  activationPolicy: ALWAYS
 +
  availabilityType: ZONAL
 +
  backupConfiguration:
 +
    backupRetentionSettings:
 +
      [[retainedBackups]]: 7
 +
      retentionUnit: COUNT
 +
    enabled: true
 +
    kind: sql#backupConfiguration
 +
    pointInTimeRecoveryEnabled: false
 +
    replicationLogArchivingEnabled: false
 +
    startTime: 04:00
 +
    transactionLogRetentionDays: 7
 +
  connectorEnforcement: NOT_REQUIRED
 +
  [[dataDiskSizeGb]]: '203'
 +
  dataDiskType: PD_SSD
 +
  ipConfiguration:
 +
    authorizedNetworks:
 +
    - kind: sql#aclEntry
 +
      name: ''
 +
      value: 55.246.195.10/32
 +
    - kind: sql#aclEntry
 +
      name: ''
 +
      value: 55.246.204.10/32
 +
    - kind: sql#aclEntry
 +
      name: ''
 +
      value: 55.246.243.10/32
 +
    ipv4Enabled: true
 +
    privateNetwork: projects/yourproject/global/networks/default
 +
  kind: sql#settings
 +
  locationPreference:
 +
    kind: sql#locationPreference
 +
    zone: europe-west3-b
 +
  maintenanceWindow:
 +
    day: 0
 +
    hour: 0
 +
    kind: sql#maintenanceWindow
 +
  pricingPlan: PER_USE
 +
  replicationType: SYNCHRONOUS
 +
  settingsVersion: '178'
 +
  storageAutoResize: true
 +
  storageAutoResizeLimit: '0'
 +
  tier: [[db-custom]]-8-30720
 +
state: RUNNABLE
 +
 +
  
 
== See also ==
 
== See also ==

Latest revision as of 05:49, 3 November 2022

gcloud sql instances describe YourInstance

backendType: SECOND_GEN
connectionName: yourproject:europe-west3:prod
createTime: '2020-04-05T19:12:22.734Z'
databaseInstalledVersion: POSTGRES_11_16
databaseVersion: POSTGRES_11
etag: 2e128ab6c656xxdsf53da41455d40259df8e05afdasf
gceZone: europe-west3-b
instanceType: CLOUD_SQL_INSTANCE
ipAddresses:
- ipAddress: 55.242.253.10
  type: PRIMARY
- ipAddress: 55.242.211.10
  type: OUTGOING
- ipAddress: 10.28.32.25
  type: PRIVATE
kind: sql#instance
maintenanceVersion: POSTGRES_11_16.R20220710.01_08
name: YourInstance
project: yourproject
region: europe-west3
selfLink: https://sqladmin.googleapis.com/sql/v1beta4/projects/yourproject/instances/prod
serverCaCert:
  cert: |-
    -----BEGIN CERTIFICATE-----
    asdgaggdasgBAgIBADANBgkqhkiG9w0BAQsFADB3MS0wKwYDVQQuEyQ5MDc2
    ODgyZS1kZjY4LTQ1YjUtYTJkNS1lOTBhN2ZiNTkxZTgxIzAhBgNVBAMTGkdvb2ds
    .../...
    FfAseyh9oS6phYpWcX+NWohEKO26f6FzuoMdWTXUNNasOvbpAQWOAqvYGh6Cqgxz
    NMd5tvt8v/aIqDf1CvamNdCZHAfOavOlTAPZ0tdYP0XuRDzKiGma5tvgryDMyKqn
    zdGtZqdPPe4ofx2fqUluDgu+EgZBX0RpUNEDe5upquaMoEGuHMSa+gtHfJA8CjoY
    Oz/uBXnWUpOEbfq7poW/eB69Xadfasf
    -----END CERTIFICATE-----
  certSerialNumber: '0'
  commonName: C=US,O=Google\, Inc,CN=Google Cloud SQL Server CA,dnQualifier=907asfadf-df68-45b5-a2d5-e90a7fb591e8
  createTime: '2020-04-05T19:13:20.693Z'
  expirationTime: '2030-04-03T19:14:20.693Z'
  instance: YourInstance
  kind: sql#sslCert
  sha1Fingerprint: gasdfg14b9824aadfasfsdfg0ed7c0f4d7c4a06
serviceAccountEmailAddress: [email protected]
settings:
  activationPolicy: ALWAYS
  availabilityType: ZONAL
  backupConfiguration:
    backupRetentionSettings:
      retainedBackups: 7
      retentionUnit: COUNT
    enabled: true
    kind: sql#backupConfiguration
    pointInTimeRecoveryEnabled: false
    replicationLogArchivingEnabled: false
    startTime: 04:00
    transactionLogRetentionDays: 7
  connectorEnforcement: NOT_REQUIRED
  dataDiskSizeGb: '203'
  dataDiskType: PD_SSD
  ipConfiguration:
    authorizedNetworks:
    - kind: sql#aclEntry
      name: 
      value: 55.246.195.10/32
    - kind: sql#aclEntry
      name: 
      value: 55.246.204.10/32
    - kind: sql#aclEntry
      name: 
      value: 55.246.243.10/32
    ipv4Enabled: true
    privateNetwork: projects/yourproject/global/networks/default
  kind: sql#settings
  locationPreference:
    kind: sql#locationPreference
    zone: europe-west3-b
  maintenanceWindow:
    day: 0
    hour: 0
    kind: sql#maintenanceWindow
  pricingPlan: PER_USE
  replicationType: SYNCHRONOUS
  settingsVersion: '178'
  storageAutoResize: true
  storageAutoResizeLimit: '0'
  tier: db-custom-8-30720
state: RUNNABLE


See also[edit]

Retrieved from "https://www.wikieduonline.com/index.php?title=Gcloud_sql_instances_describe_YourInstance&oldid=197019"

Advertising: