about .pgpass

Hi ,

I have question about.pgpass . I have been playing around with postgresql
privileges setting . I created a role user1 (not superuser) for the testing
. today with this role I can login to the database in which I have grant
without need enter password .

I found the culprit is .pgpass after I alter the role password
psql -d db1 -h 192.168.56.200 -U user1
psql: FATAL: password authentication failed for user "user1"
password retrieved from file "/home/myuser/.pgpass"

I open the file and found the user1 and password listed inside .
my question.
1. when is postgresql write role user1 inside the file. can I disable the
function?
2. on another machine that running pgadmin3 (windows) , when I try connect
using role user1 without password it also allow me , is this correct?

here my pg_hba setting

host all postgres 0.0.0.0/0 reject
# "local" is for Unix domain socket connections only
local all postgres peer
# IPv4 local connections:
host all all 192.168.56.0/24 md5
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5

rgds,
ccc

--
View this message in context: http://postgresql.1045698.n5.nabble.com/about-pgpass-tp5749805.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.