Praneel Devisetty <devisettypraneel@gmail.com> writes:
> We have a requirement , where we require a user to get locked after three
> wrong login attempts.
The usual recommendation is to configure Postgres to use PAM
authentication; then you can set up any weird requirements like
this one in the PAM configuration.
regards, tom lane