Add postrgesql.User

[Comradin]

We tried to add a Role() to our AWS Redshift cluster and this resulted in a SQL error message:

error: error creating role my_user: pq: syntax error at or near "ROLE"

@t0yv0 pointed out in the Pulumi Slack, that Redshift in particular does not support the more modern CREATE ROLE and instead still uses the older CREATE USER construct, but the pulumi PostgreSQL provider does not support this.

Affected feature

Adding the User() would help to use the Pulumi PostgreSQL provider with older or forked versions of PostreSQL.

[lukehoban]

This looks like it's tracked upstream in hashicorp/terraform-provider-postgresql#147. When that is addressed, we'll pick up the fix here. It might be necessary to port that issue over to the new github.com/cyrilgdn/terraform-provider-postgresql repo to track there as well since that is where active development is happening now.

[bombillazo]

Any alternative on how to provision users to a PostgreSQL DB using Pulumi?