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 G Johnston <david.g.johnston@xxxxxxxxx> wrote:
Ravi Roy wrote
> But if I try to connect using pgadmin (from the same machine) it givesYou likely told pgadmin to remember (store) passwords.
> 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.
"If you select “Store password”, pgAdmin stores passwords you enter in the
~/.pgpass file under Unix or :file:%APPDATA%postgresqlpgpass.conf under
Win32 for later reuse. For details, see pgpass documentation. It will be
used for all libpq based tools. If you want the password removed, you can
select the server’s properties and uncheck the selection any time."
http://www.pgadmin.org/docs/1.18/connect.html
--
View this message in context: http://postgresql.1045698.n5.nabble.com/probable-pg-hba-conf-configuration-issues-tp5802949p5802954.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
