Setting up database backup and export

Question

Setting up database backup and export

Opened this issue 4 years ago · 1 comments

Looks like there's no database backup nor export in the config.

Note the "backup" feature from CloudSQL is misnamed IMO. It's more like a "snapshot" of your database instance. If you accidentally deleted your database instance, all the backups are gone.

For exporting data to GCS you can set up a Cloud Scheduler job and send POST request: https://cloud.google.com/sql/docs/postgres/import-export/exporting#rest-v1beta4

Answer 1 · 2021-01-12T03:56:29.000Z

Can you make a PR? Make sure that this new Terraform setup works given the instructions in README and is able to be torn down with terraform destroy.