Learn how to automatically rotate PostgreSQL/CockroachDB user passwords.
user-a
and user-b
.user-a
and user-b
. We’ll refer to this user as the admin
user.admin
user account.user-a
is updated with the new value.user-b
on the next rotation.Open Secret Rotation Page
Secret Rotation
in the left side barClick on PostgresSQL card
Provide the inputs
user-a
user-b
Configure the output secret mapping
Why can't we delete the other user when rotating?
Why do you need root user account?
user-a
and user-b
.You don’t need to grant all permission for your admin account but rather just the permissions to update both of the user’s passwords.