Re: [GENERAL] Doubts regarding postgres Security

2017-01-21 Thread John R Pierce
On 1/21/2017 1:37 PM, Stephen Frost wrote: * PAWAN SHARMA (er.pawanshr0...@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 qu

Re: [GENERAL] Doubts regarding postgres Security

2017-01-21 Thread Stephen Frost
* Thomas Kellerer (spam_ea...@gmx.net) wrote: > Stephen Frost schrieb am 21.01.2017 um 22:37: > >>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 u

Re: [GENERAL] Doubts regarding postgres Security

2017-01-21 Thread Thomas Kellerer
Stephen Frost schrieb am 21.01.2017 um 22:37: 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. What

Re: [GENERAL] Doubts regarding postgres Security

2017-01-21 Thread Stephen Frost
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.pawanshr0...@gmail.com) wrote: > So, there is no solution for my first question, we need if users enter t

Re: [GENERAL] Doubts regarding postgres Security

2017-01-21 Thread Stephen Frost
Pawan, * PAWAN SHARMA (er.pawanshr0...@gmail.com) wrote: > 1. How can we set user account block feature after max number of > invalid password entries? There are ways to accomplish this, but they're unfortunately complicated. In the past, I've implemented these kinds of requirments by using the

Re: [GENERAL] Doubts regarding postgres Security

2017-01-21 Thread Karsten Hilbert
On Sun, Jan 22, 2017 at 12:32:21AM +0530, PAWAN SHARMA wrote: > I have few question regarding Postgres security. > > 1. How can we set user account block feature after max number of > invalid password entries? > 2. How can we use SSL encryption in Postgres on Linux environment? > 3. How can we

[GENERAL] Doubts regarding postgres Security

2017-01-21 Thread PAWAN SHARMA
Hi All, I have few question regarding Postgres security. 1. How can we set user account block feature after max number of invalid password entries? 2. How can we use SSL encryption in Postgres on Linux environment? 3. How can we transparent data encryption in Postgres? Thanks