Hashicorp Vault and Postgres - how to assign users to group?

I use vault to generate users on Postgres, Redshift. In postgres and redshift I have predefined groups with permissions (ro/rw) and I want to add the users created by Vault to the corresponding group. I tried using

in postgres:

CREATE USER \"{{username}}\" WITH PASSWORD '{{password}}' IN GROUP {group_name}'

in redshift

'CREATE USER \"{{username}}\" WITH PASSWORD '{{password}}' VALID UNTIL '{{date}}'; ALTER GROUP {group_name} ADD USER \"{{username}}\";'

with out any luck… it generates error messages of encoding.

what’s the best practice for such case? as per the Vault instance - it’s a fargate cluster and I don’t have direct access to it… :confused:

Can you post the full error message?