The documentation provides incorrect examples for removing overrides or changing the maximum number of failed logins for a role.
The correct example for removing the overrides for the maximum number of failed logins for all roles is:
alter role "all overrides" set max failed_logins -1
The correct example for changing the maximum failed logins allowed for “physician_role” to 5 is:
alter role physician_role set max failed_logins 5