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
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' |