I will add documentation for it. Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --------------------------------------------------------------------------- Andrew Dunstan wrote: > > Here's a patch that I think (hope) does this right, by using the file > pointed to by the environment var PGPASSFILE, if set, in preference to > $HOME/.pgpass. I assume that at this stage it would be held over for 8.1 > as a new feature - if not I'll put together some docco in a hurry. > > cheers > > andrew > > > > Andrew Dunstan wrote: > > > > > > > Tom Lane wrote: > > > >> Andrew Dunstan <[EMAIL PROTECTED]> writes: > >> > >> > >>> How about an environment variable that points to a .pgpass type file. > >>> > >> > >> > >> You can do that today: point $HOME at some temp directory or other. > >> AFAIR pg_dump doesn't make any other use of $HOME ... > >> > >> > >> > >>> Or we could even play games with PGPASSWORD - if it names an > >>> existing file that satisfies the .pgpass criteria then it will be > >>> taken as the location of the .pgpass file instead of $HOME/.pgpass - > >>> otherwise its value will be considered to be the password itself. > >>> > >> > >> > >> Gaack... if you want a separate variable, we can talk about that, but > >> let's not overload PGPASSWORD like that. Consider even just the > >> implications of whether libpq error messages should echo back the > >> "filename" ... > >> > >> > >> > >> > > > > Yeah. as usual you're right :-) > > > > So let's go woth PGPASSFILE > > > > cheers > > > > andrew > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]