| 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: | Whole Thread | Raw Message | 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? |