Re: Ugh...createlang won't prompt for password - Mailing list pgsql-hackers-win32

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