No matter how you like to participate in developer communities, Pulumi wants to meet you there. If you want to meet other Pulumi users to share use-cases and best practices, contribute code or documentation, see us at an event, or just tell a story about something cool you did with Pulumi, you are part of our community.

Pulumi Community

Cannot destroy GCP Cloud SQL via `pulumi destroy`
```➜  ~/code/infra/pulumi/app git:(feat/pulumi-playground) ✗ pulumi state unprotect "urn:pulumi:staging::my-sample::gcp:sql/databaseInstance:DatabaseInstance::pulumi-postgres" 
 warning: This command will edit your stack's state directly. Confirm? Yes
Resource unprotected
➜  ~/code/infra/pulumi/app git:(feat/pulumi-playground) ✗ pulumi destroy --target "urn:pulumi:staging::eluve-sample::gcp:sql/databaseInstance:DatabaseInstance::pulumi-postgres"```

```Diagnostics:
  gcp:sql:DatabaseInstance (pulumi-postgres):
    error: deleting urn:pulumi:staging::my-sample::gcp:sql/databaseInstance:DatabaseInstance::pulumi-postgres: 1 error occurred:
        * Error, failed to delete instance because deletion_protection is set to true. Set it to false to proceed with instance deletion```

if I run it through the gcloud CLI, it works just fine
```$ gcloud sql instances delete pulumi-postgres-c407e1e```


I figured it out. There are 3 settings to prevent deletion on CloudSQL. More details here: <https://github.com/pulumi/pulumi-gcp/issues/1209#issuecomment-1725147154>