Re: probable pg_hba.conf configuration issues

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(dot)g(dot)johnston(at)gmail(dot)com
> wrote:

> 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 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>