postgresql windows external authentication

Question

I have to implement some safety authentication rules on postgresql DB ( with a windows server)like: users not used for a period longer than three months will be locked or postgres enforces account lockout after a set number of failed login attempts.....

Using authentication "standard" ( md5 on pg_hba.conf) I think is not possible..but I think that with PAM I could do but PAM does not exist on win. Any ideas? Thanks a lot Gian

If you don't mind writing a bit of C code, you could probably do this with an authentication hook — Nick Barnes
– Nick Barnes, Commented Jan 31, 2017 at 20:13
I still work on it, can you share somre info...? please, help me! — Frank N Stein
– Frank N Stein, Commented Feb 1, 2017 at 12:28

Curt Evans · Accepted Answer · 2017-01-31 19:48:00Z

1

This is not easy, but can be done with an LDAP interface to AD. Personally, I would load the whole mess into an Ubuntu or Centos vm

answered Jan 31, 2017 at 19:48

Curt Evans

3462 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gian Piero Over a year ago

Sorry I can not do this

Collectives™ on Stack Overflow

postgresql windows external authentication

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related