Hello,
Today, when upgrading from Postgres 15.8 to 15.9, we realized that the login role set for a user (with
ALTER USER my_user SET ROLE my_role) was not automatically set upon login any more.
This is particularly problematic for users of HashiCorp Vault's dynamic users (like us), who often rely on
ALTER ROLE xxx SET ROLE yyy to make sure that dynamic & short-lived users created by vault create postgres resources as a long-lived role, and not as themselves.
We suspect
this commit to be the one that introduced this behavioral change.
I'm at your disposal if you have any questions.
Kind Regards,
-Étienne
