Re: Ugh...createlang won't prompt for password

On Apr 19, 2005, at 7:28 PM, Steve - DND wrote:

>>
>> Is it possible that createlang is getting a (wrong) password from
>> someplace?  Say, a PGPASSWORD environment setting, or a .pgpass
>> config file.
>
> I can't find any PGPASSWORD environment variable, nor could I find a 
> .pgpass
> config file. Where would the config file be located? in data/?
>
> Would it be possible to use such a file for a temporary fix? If so, 
> what is
> the format of the file?


You can use the pgpass file to avoid any password prompting. The 
details are here:

http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [email protected]