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