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