Re: PGPASSWORD and client tools

Christopher Kings-Lynne wrote:
>> It's deprecated because it's insecure, on platforms where other users can
>> see the environment variables passed to pg_dump (which apparently is
>> quite a few variants of Unix).  You wouldn't pass the password on the
>> command line either ...
>>
>> Painful as .pgpass may be for an admin tool, I do not know of any other
>> method I'd recommend on a multiuser machine.
> 
> 
> OK, but say you have a phpPgAdmin installation that's servicing 20 
> users.  Then you have to put a .pgpass file in the www home dir (if 
> there is one) with the usernames and passwords of all those users - 
> pretty damn annoying...

Even worse, if you have a server registered more than once with 
different credentials...
I tried redirecting pg_dump's stdin but that locked up under win32.

Regards,
Andreas