From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PGPASSWORD and client tools |
Date: | 2004-08-19 02:24:13 |
Message-ID: | 41240F4D.5040303@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Tom Lane wrote:
>Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>
>>How about an environment variable that points to a .pgpass type file.
>>
>>
>
>You can do that today: point $HOME at some temp directory or other.
>AFAIR pg_dump doesn't make any other use of $HOME ...
>
>
>
>>Or we could even play games with PGPASSWORD - if it names an existing file
>>that satisfies the .pgpass criteria then it will be taken as the
>>location of the .pgpass file instead of $HOME/.pgpass - otherwise its
>>value will be considered to be the password itself.
>>
>>
>
>Gaack... if you want a separate variable, we can talk about that, but
>let's not overload PGPASSWORD like that. Consider even just the
>implications of whether libpq error messages should echo back the
>"filename" ...
>
>
>
>
Yeah. as usual you're right :-)
So let's go woth PGPASSFILE
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-08-19 02:36:35 | Re: COPY with column headings |
Previous Message | Bruce Momjian | 2004-08-19 02:12:53 | Re: Open items |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-08-19 02:45:42 | Re: 7.4.3 & 8.0.0beta1 + Solaris 9: default pg_hba.conf breaks |
Previous Message | Tom Lane | 2004-08-19 02:07:20 | Re: PGPASSWORD and client tools |