.pgpass not working - Mailing list pgsql-novice

From Birchall, Austen
Subject .pgpass not working
Date
Msg-id 4E154FB60786D74BB4DFDC97BF991CAC076DB1@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk
Whole thread Raw
In response to Re: Running psql commands from a remote location & pg_hba.conf?  (Luca Ferrari <fluca1978@infinito.it>)
Responses Re: .pgpass not working
List pgsql-novice
psql (8.4.13) on Red Hat 6

I am trying to setup .pgpass and testing it I get:


[postgres@myhost:~]$ whoami
postgres
[postgres@myhost:~]$ echo $HOME
/var/lib/pgsql
[postgres@myhost:~]$ pwd
/var/lib/pgsql
[postgres@myhost:~]$ ls -la .pgpass
-rw-------. 1 postgres postgres 20 Aug  7 13:52 .pgpass
[postgres@myhost:~]$ view .pgpass
*:*:*:austen:austen

[postgres@myhost:~]$ psql -U austen -d mudb
psql: FATAL:  Ident authentication failed for user "austen"
[postgres@myhost:~]$

Can anybody see what I am doing wrong?

Thanks

Austen


Austen Birchall  Senior Database Administrator
Met Office



pgsql-novice by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: Running psql commands from a remote location & pg_hba.conf?
Next
From: Athanasios Kostopoulos
Date:
Subject: Re: .pgpass not working