Re: Password complexities in Postgres v14.6

[Pepe TD Vo <pepevo@xxxxxxxxx>]

you can configure the password policy plugin in postgresql.conf.

p_policy.min_password_len = 8       # Set minimum Password length

p_policy.min_special_chars = 2      # Set minimum number of special characters

p_policy.min_numbers = 2            # Set minimum number of numeric characters

p_policy.min_uppercase_letter = 2   # Set minimum number of upper case letters

p_policy.min_lowercase_letter = 2   # Set minimum number of lower case letters

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love, and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

On Friday, December 16, 2022 at 07:28:05 AM EST, Daulat <daulat.dba@xxxxxxxxx> wrote:

Hello Team,

Any idea, how we can set some Password complexities in postgres for user password. Like, we can create profiles in Oracle.

I am looking to set the Password complexities  (one parameter from each line item has to be complied to):

Default password age for users: 90 days.

Password first letter will be alphabetic in uppercase.

English uppercase characters (A through Z)

English lowercase characters (a through z)

Base 10 digits (0 through 9)

Non-alphabetic characters ~" &_-+='! (){}[):;"'<>,.?/ !@#$%*

Password Minimum Length 8 character

Thanks,