Kevin Brannen wrote: > Bruce Momjian wrote: > ... > > > > 7.3 may remove PGPASSWORD, I think, and instead allow you to specify a > > file that contains the password. > > But do you know how many hours it took me to find out about PGPASSWORD > in the docs and now you want to change that? :-) > > How about all 4 approaches: on the command-line, from an env-var, from > a file, and finally prompting if there's a tty. Pick any order you want > on the first 3, but flexibility is important, and circumstances do > change over time that may make 1 more desireable then the others.
PGPASSWORD is a security problem on platforms that can show environment variables, mostly *BSD's, and most people don't know it is visible. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
