Re: probable pg_hba.conf configuration issues - Mailing list pgsql-general

From Ravi Roy
Subject Re: probable pg_hba.conf configuration issues
Date
Msg-id CAFMBnF9Wg-biQCkHx+HGHd=zygc=G69g6V5uWAjz2FFZz+_t0w@mail.gmail.com
Whole thread Raw
In response to Re: probable pg_hba.conf configuration issues  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-general
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@gmail.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Server process crash - Segmentation fault
Next
From: Tom Lane
Date:
Subject: Re: How to fix lost synchronization with server