authentication log in

From: Pepe TD Vo <pepevo(at)yahoo(dot)com>
To: PgAdmin Support List <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: authentication log in
Date: 2020-11-25 14:20:28
Message-ID: 1832500647.912065.1606314028897@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Browse pgadmin-support by date

  From Date Subject
Next Message Zhiyu ZY13 Xu 2020-11-25 20:41:32 pgadmin--pgagent---the process hang by unknow reasons
Previous Message Dave Page 2020-11-23 09:14:46 Re: ValueError: unsupported format character 'D'