Ravi Roy ravi.a...@gmail.com writes:
Using command line : psql -U superuser1 psql -U normaluser1 asks for
password and login successfully. - perfect. (We are only alloing local
connections, remote connections to database are disabled)
But if I try to connect using pgadmin (from the same
My bet is you have either another line
in the pg_hba that says trust
or you saved the password and forgot.
Sim
On 05/07/2014 05:33 PM, Ravi Roy wrote:
Hi,
I'm sorry if this question have been asked earlier,
Ravi Roy wrote
But if I try to connect using pgadmin (from the same machine) it gives
acess to database without password, i'm surprised as it does not seem to
respect pg_hba.conf or i'm terribly wrong in the configuration somewhere.
You likely told pgadmin to remember (store) passwords.
If
Thanks Sim, Tom David, i'm really amazed with quick answers and insight
provided by you all.
I found and was a password cache issue under
%APPDATA%\postgresql\pgpass.conf; I removed it and everything works as
expected.
Thank you again guys!
Regards,
Ravi.
On Wed, May 7, 2014 at 8:22 PM, David