authentication log in

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
bvo
Reply | Threaded
Open this post in threaded view
|

authentication log in

bvo
good morning,

I want to secure a password when using the pgAdmin client to logon to the PostgreSQL DB.  No matter what passwords I put for connection with pgAdmin, all connected fine.  I have configured pg_hba.conf with md5, it works to prompt me for a password in the DB server as use psql.  If the password is not corrected, psql will prompt me an error but it's ok with pgAdmin.

pg_hba.conf:

  
host      all                 all                127.0.0.1/32   md5
host      all                 all                localhost         md5
host      postgres        postgres       ip.0/24           ident
host      cidr               username1    ip.0/24            password
host      cidr               username2    ip.0/24            password

would you please point me to what method should I use to authentication the log-in from the client?  It works find in AWS DB but not with Linux DB.

thank you.



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.EmojiEmojiEmoji
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