Reset a role's password
postgres roles & traffic
// what it does
Generates a new password for an existing role — same role name and privileges, fresh secret. This is your rotation primitive: reset, update the secret in your deploy pipeline, done.
// shell
$ pscale role reset mydb main <role-id>// gotcha
The old password dies the moment reset succeeds, so coordinate with deployment: reset during a maintenance moment or have the app retry with the new secret. --force skips the confirmation prompt for scripts.