search

pulumi / pulumi-postgresql

A Postgresql Pulumi resource package
Apache License 2.0
28 stars 9 forks source link

Add postrgesql.User #123

Open Comradin opened 3 years ago

Comradin commented 3 years ago

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 commented 3 years ago

This looks like it's tracked upstream in https://github.com/hashicorp/terraform-provider-postgresql/issues/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 commented 1 year ago

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