From: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | .pgpass not working |
Date: | 2013-08-07 14:03:07 |
Message-ID: | 4E154FB60786D74BB4DFDC97BF991CAC076DB1@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
psql (8.4.13) on Red Hat 6
I am trying to setup .pgpass and testing it I get:
[postgres(at)myhost:~]$ whoami
postgres
[postgres(at)myhost:~]$ echo $HOME
/var/lib/pgsql
[postgres(at)myhost:~]$ pwd
/var/lib/pgsql
[postgres(at)myhost:~]$ ls -la .pgpass
-rw-------. 1 postgres postgres 20 Aug 7 13:52 .pgpass
[postgres(at)myhost:~]$ view .pgpass
*:*:*:austen:austen
[postgres(at)myhost:~]$ psql -U austen -d mudb
psql: FATAL: Ident authentication failed for user "austen"
[postgres(at)myhost:~]$
Can anybody see what I am doing wrong?
Thanks
Austen
Austen Birchall Senior Database Administrator
Met Office
From | Date | Subject | |
---|---|---|---|
Next Message | Athanasios Kostopoulos | 2013-08-07 14:12:53 | Re: .pgpass not working |
Previous Message | Luca Ferrari | 2013-08-06 06:11:31 | Re: Running psql commands from a remote location & pg_hba.conf? |