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 md5host all all localhost md5host 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.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
