Re: [GENERAL] Doubts regarding postgres Security - Mailing list pgsql-general

From Stephen Frost
Subject Re: [GENERAL] Doubts regarding postgres Security
Date
Msg-id 20170121213755.GX18360@tamriel.snowman.net
Whole thread Raw
In response to [GENERAL] Doubts regarding postgres Security  (PAWAN SHARMA <er.pawanshr0963@gmail.com>)
List pgsql-general
Pawan,

Please be sure to include the mailing list on replies, so others can
benefit from the discussion.  Also, please reply in-line, as I do below,
instead of top-posting.

* PAWAN SHARMA (er.pawanshr0963@gmail.com) wrote:
> So, there is no solution for my first question, we need if users enter the
> wrong password more than 5 times than their account gets locked and then
> only DBA will unlock this account.

I understood the question and there is an answer- use PAM.

The other option is to not use password-based authentication with PG and
instead use a better method such as certificate-based auth or GSSAPI.

Thanks!

Stephen

Attachment

pgsql-general by date:

Previous
From: Simon Windsor
Date:
Subject: Re: [GENERAL] PgPool or alternatives
Next
From: Thomas Kellerer
Date:
Subject: Re: [GENERAL] PgPool or alternatives