Horton

Re: Today's Postgres Releases break login roles

Matthew Woodcraft <matthew@woodcraft.me.uk>

View thread View on postgr.es
From: Matthew Woodcraft <matthew@woodcraft.me.uk>
To: pgsql-bugs@lists.postgresql.org
Cc: Etienne LAFARGE <etienne.lafarge@gmail.com>
Date: 2024-11-16T10:45:30Z
Lists: pgsql-bugs 
Etienne LAFARGE <etienne.lafarge@gmail.com> writes:

> 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.

I noticed one other change with the 14.14 point release, which I think
is likely to be related.

Previously a command like this would work to select a role immediately after
login:

psql "options='-crole=foo'"

With 14.14 as far as I can tell it has no effect.

-M-

Commits

  1. Test "options=-crole=" and "ALTER DATABASE SET role".

  2. Fix per-session activation of ALTER {ROLE|DATABASE} SET role.