Hello, when using Azure postgres db, anyone know how I would go about replicating this in Pulumi?

GRANT azure_pg_admin TO <new_user>;

Are you on Single or Flexible server?

Found it.

postgresql.GrantRole("grant role azure_pg_admin",
                     grant_role="azure_pg_admin",
                     role=role.name,
                     opts=ResourceOptions(
                         provider=pg_provider
                     )
                     )

If i'm not mistaken, this approach only works if your server is connected to the internet. If your postgres server (flexible in my case) is only accessable within a vpc, then you can't use the pulumi postgresql library.