How can I Specifies the number of failed login attempts in PostgreSQL before the role or user is locked and unlock after a time that I want?

What about blocking IP not user. If I want ban IP after n login attempt fail, what is your suggestion and solution?

Can anyone help me?

CodePudding user response：

PostgreSQL has no built-in capabilities to avoid brute force password attacks, except for auth_delay.