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
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
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 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 machine) it gives
>
Hi,
I'm sorry if this question have been asked earlier, but i could not find
any valid result through googling.
I'm running postgresql 9.1 on Windows 7 (64 bit) and i've following
configuration in pg_hba.conf.
host all superuser1127.0.0.1/32 password
host all
