CODEWITHSUNDEEP
google-cloud-platformgoogle-cloud-sql
Raiyan
Raiyan

Reputation: 1697

How to get the size of an on demand backup in Google Cloud SQL?

I'm taking daily on demand backup of my cloud SQL instance in GCP. It's a PostgreSQL 9.6 instance.

I would like to know the size (in GB or MB) of each backup. How can I get this information using gcloud CLI or the console (web UI)?

Upvotes: 5

Views: 1702

Answers (1)

dany L
dany L

Reputation: 2654

This is not possible at this moment. There is already a Feature request in that regards, please star it. Another one.

Also official documentation states the following about backup size:

Cloud SQL backups are incremental. They contain only data that changed after the previous backup was taken. Your oldest backup is a similar size to your database, but the sizes of subsequent backups depend on the rate of change of your data. When the oldest backup is deleted, the size of the next oldest backup increases so that a full backup still exists.

I have also tried gcloud sql backups describe [ID] --instance=[instancename] and that does not give us the required information.

Update FYI Feature was released

https://cloud.google.com/sql/docs/release-notes#November_04_2024

Upvotes: 6

Related Questions