Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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


  • From: John DeSoi <desoi(at)pgedit(dot)com>
  • To: "Steve - DND" <postgres(at)digitalnothing(dot)com>
  • Cc: postgres-win32 <pgsql-hackers-win32(at)postgresql(dot)org>
  • Subject: Re: Ugh...createlang won't prompt for password
  • Date: Tue, 19 Apr 2005 19:39:27 -0400
  • Message-id: <4482CF76-B12C-11D9-B27F-000A95B03262(at)pgedit(dot)com>


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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group