From: Michael Schmidt <michaelmschmidt@msn.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL General <pgsql-general@postgresql.org>
Subject: Re: Password issue revisited
Date: Sun, 28 Jan 2007 10:06:58 -0700
Message-ID: <BAY114-DAV5242830F3831850FF3E41A3A00@phx.gbl> (raw)
References: <BAY114-DAV1235968436BFC871B4AEB7A3A00@phx.gbl>
<26015.1169948793@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: michaelmschmidt@msn.com, tgl@sss.pgh.pa.us, pgsql-general@postgresql.org
Subject: Re: Password issue revisited
In-Reply-To: <BAY114-DAV5242830F3831850FF3E41A3A00@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox