sticky-bear-14421
06/04/2021, 1:50 PMredshift_cluster = aws.redshift.cluster(..)
pg_provider = postgresql.Provider('redshift_cluster',
database=redshift_cluster.database_name,
host=redshift_cluster.dns_name,
port=redshift_cluster.port,
username=redshift_cluster.master_username,
password=redshift_cluster.master_password)
my_user = postgresql.Role('my_user',
name="my_user",
password="123456",
login=True,
create_database=False,
create_role=False,
superuser=False,
opts=pulumi.ResourceOptions(provider=pg_provider)
But, when I try to apply this code it will fail with an SQL error:
error: error creating role my_user: pq: syntax error at or near "ROLE"
Any ideas what is wrong with my Role() definition?enough-garden-22763
06/04/2021, 1:55 PMsticky-bear-14421
06/04/2021, 1:57 PMenough-garden-22763
06/04/2021, 2:10 PMsticky-bear-14421
06/04/2021, 2:11 PM