.pgpass not working
| От | Birchall, Austen |
|---|---|
| Тема | .pgpass not working |
| Дата | |
| Msg-id | 4E154FB60786D74BB4DFDC97BF991CAC076DB1@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk обсуждение исходный текст |
| Ответ на | Re: Running psql commands from a remote location & pg_hba.conf? (Luca Ferrari <fluca1978@infinito.it>) |
| Ответы |
Re: .pgpass not working
|
| Список | 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 по дате отправления: