Unable to remove postgresql_role from state without working DB provider

[jimbutler]

I am working in a DR recovery scenario and I want to be able to remove DB items from TF state when they no longer exist or are corrupt.

I want to remove a postgresql_role from the state only, but I cannot do this without referencing the provider. However, because this is a DR scenario, the provider is not able to connect to the DB, so the plan fails. Note that I am using lifecycle=false, to indicate that I only want the state to be affected, i.e. there is no need to talk to the DB.

Remove:
`removed {
lifecycle {
destroy = false
}

from = postgresql_role.postgres_iam_user
}`

[steveliakakos-dstl]

I find myself in the same situation, but in this case, i'm renaming the rds instance which requires replacing the resource. terraform got as far as deleting the instance before complaining about delete protection on the cluster. Removing the protection and re-running generated the same issue as @jimbutler as the postgresql resources still existed (they weren't flagged for replacement as they weren't impacted by the name change), but the database had gone.