Generate a new PostgreSQL password for roles in case of restoration #227
Description
Hi provider-sql maintainers,
What problem are you facing?
When I recreate an orphaned role or in case of cluster restoration, if I haven't backed up the secrets containing the PostgreSQL passwords of the roles, I am unable to reuse these roles for my deployments.
I saw that the problem is due to the encryption of the passwords into the database so we can't retrieve them after creation.
How could Crossplane help solve your problem?
It could be great to implement a behaviour like in the Postgres-operator (if not already done) that generate a new password and replaces the previous one into the database so there is no need to keep the old secrets in a safe location to be able to restore the user later.
Thank you for your help