Setting Configuration Parameters for a Role

[jcarvalho]

Hi.

We're looking to set per-role configuration parameters (as specified in https://www.postgresql.org/docs/11/sql-alterrole.html).

Is there a native way to do this with the provider? Couldn't find anything about it so far.

[wimi]

Hi there, a few of role parameters can be setup using properties of role resource directly, but general approach to specify any parameter per role is not natively available.
I've started similar discussion some time ago (#86) and even had some POC code implementing that (links in discussion), but it seems that generally it's not widely looked for feature.

At the end we've implemented our own dynamic provider in Pulumi to workaround this.