Re: Password complexities in Postgres v14.6 - Mailing list pgsql-admin
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.
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@gmail.com> 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,
pgsql-admin by date: