Re: PGPASSWORD and client tools

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: PGPASSWORD and client tools
Дата
Msg-id 41240A8D.2040200@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: PGPASSWORD and client tools  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: PGPASSWORD and client tools  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список pgsql-hackers
> 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...

Chris



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_dump 'die_on_errors'
Следующее
От: Tom Lane
Дата:
Сообщение: More fun with dropped columns