Re: Password issue revisited

Поиск
Список
Период
Сортировка
От Michael Schmidt
Тема Re: Password issue revisited
Дата
Msg-id BAY114-DAV5242830F3831850FF3E41A3A00@phx.gbl
обсуждение исходный текст
Ответ на Password issue revisited  ("Michael Schmidt" <michaelmschmidt@msn.com>)
Ответы Re: Password issue revisited  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Mr. Lane and Mr. Momjian,
Well, I asked and I got an answer.  So be it.  Regarding how I concluded that PGPASSFILE was deprecated for pg_dump, I offer the following.
 
1.  The documentation for pg_dump in the manual (Section VI) includes a section labeled "Environment".  This lists PGDATABASE, PGHOST, PGPORT, and PGUSER.  It also says "default connection parameters" but there is no hyperlink or reference to another manual section to explain/define this term. 
 
2.  Neither the Index nor the Table of Contents has an entry for "connection parameters" or "default connection parameters". 
 
3.  The application help (pg_dump --help) provides no further information.
 
4.  The pg_dump documentation in Section VI has a "See Also" section, with a link to 29.12.  In 29.12 there is a list of variables that "can be used to select default connection parameters" for PQconnectdb, PQsetdbLogin, and PQsetdb (no mention of pg_dump).  The list includes those mentioned in the pg_dump documentation () see 1 above) along with several others (including PGPASSFILE).  I was left wondering why would some of these be mentioned in the pg_dump section and not the others?  Perhaps those not mentioned can't be used by pg_dump? 
 
Given the above ambiguities, I was not able to conclude that pg_dump would accept the PGPASSFILE environment variable.
 
Michael Schmidt
 

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: virtual (COMPUTED BY) columns?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: "explain analyse" much slower than actual query