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

CloudSQL Postgres Roles - is it possible to create these with Pulumi?

I've created three different database users:
• migration user (IAM user for db migrations)
• server user (IAM user for server connections)
• dev user (Built-in user for debugging etc)
I'd like to give all three users a postgres role (e.g. 'my_org') that all operations occur under (e.g. tables creation, data CRUD, manual login to debug).

I did find someone doing this via pulumi (<https://stackoverflow.com/questions/66678471/how-to-deploy-postgresql-schema-to-google-cloud-sql-database-using-pulumi>), but it seems like quite a hack (commenting / uncommenting code) - in which case, I figure I may as well create a custom script and run that separately.

Is it possible to add postgers roles as part of the `pulumi up` process, or scripted in such a way that after a `pulumi up`  no other manual process needs to be run?

It's also possible that I'm thinking of this in the wrong way, so I'm curious to hear if there's a better solution to this problem.