Reset role password

Resets the password for the specified Postgres role. Returns the new password in the response.