PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> We have identified an issue where predefined roles are not modifiable,
> however a Dept. of VA security checklist requires that no roles have
> unlimited connections. The Predefined roles have unlimited connections, is
> there a way to modify these?
Solution 1: explain to your compliance department that it's pointless
to worry about the connection limit for a role that can't log in.
Solution 2: do a manual UPDATE on pg_authid. This would have to
be done over after any major-version upgrade, though.
regards, tom lane