Recently need to complete a function on PostgreSQL, after a user login failed n consecutive, lock the account for a period of time, is the function of feasible? Concrete implementation approach is feasible? Please advice

CodePudding user response:

In the database without this function, the mechanism general design in the application.

CodePudding user response:

In the application design can, for example? ODBC can be used to implement this function?

CodePudding user response:

Can use auth_delay configuration authentication failure, delay return messages;
Also can extract pg_log log, added to the pg_hba. Conf, directly related to IP