| From: | Ben Chobot <bench(at)silentmedia(dot)com> |
|---|---|
| To: | Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: .pgpass not working |
| Date: | 2012-05-04 17:35:57 |
| Message-ID: | D6535CDE-F01D-48CF-B066-D359A050701F@silentmedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On May 4, 2012, at 9:30 AM, Rebecca Clarke wrote:
> I do not want to touch the pg_hba.conf so I have generated the .pgpass file.
> The permissions is set to 600, and I have correctly inputted the details into .pgpass, there are no leading spaces.
>
> myhostname:myport:*:postgres:mypassword
>
> However I am still prompted for a password.
> I have tested pg_dump as well and it prompts also.
>
> Does anyone have any suggestions on what may be the culprit. Is there somewhere I need to specify to tell the system to look into the .pgpass file?
Where is the .pgpass file? If it's not in ~/.pgpass or doesn't have the right ownership (your permissions are good) then it won't be used. If it's in a different location, you might need to make use of the PGPASSFILE environment variable.
If you really get stuck, you can always strace psql or pg_dump and see if it has problems opening your .pgpass file.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2012-05-04 17:36:11 | Re: How to know there is any ODBC Driver installed in the Linux redhat 5.7 server? Thanks |
| Previous Message | Tom Lane | 2012-05-04 17:31:51 | Re: spanish locale question |