I'm trying to figure out a dependency issue and feel like I'm missing the right resource option to use. We're creating an RDS database with Pulumi and also configuring users/schemas/permissions. Since the latter all live inside the database, they need to be recreated if the db gets recreated, ie they are implicitly deleted on a db instance deletion.

depends_on

forces the correct ordering but Pulumi doesn't know to recreate them.

replace_on_changes

would work except its only for properties on the same resource.

maybe you want

delete_before_replace=True

?

https://www.pulumi.com/registry/packages/aws-native/api-docs/rds/dbinstance/ for the instance, and then yeah, that postgres package for configuring postgres itself. Provider that connects up to the ip grabbed from the dbinstance, and using

postgresql.Role

,

postgresql.Schema

,

postgresql.GrantRole

, etc. with that provider

In that case, maybe you want to try delete before replace as well?

no, that I think is the thing that's missing

Yes and https://www.pulumi.com/docs/intro/concepts/resources/options/dependson/

I have depends_on

@brave-motorcycle-67487 There’s a property called ‘deletedWith’ that I think you are looking for. Though it does not appear to be covered in the documentation 🤔

I've confirmed that parent and depends_on do not fix this