Re: .pgpass does not work for createlang

On Mon, Oct 10, 2005 at 06:25:59PM -0700, John Shin wrote:
> It seems that for v8.0.4 the createlang will not take .pgpass inputs and
> always prompts for password. Is this broken for the new version? Well,
> now I have to type in the password for my database script.
>
> -bash-3.00$ createdb test -h localhost -U postgres
> CREATE DATABASE

Is that the exact command you ran? As shown it should fail with a
syntax error because the options are in the wrong place:

% createdb test -h localhost -U postgres
createdb: too many command-line arguments (first is "localhost")
Try "createdb --help" for more information.

> -bash-3.00$ createlang plpgsql test -h localhost -U postgres
> Password:

Likewise:

% createlang plpgsql test -h localhost -U postgres
createlang: too many command-line arguments (first is "-h")
Try "createlang --help" for more information.

Use the --help option or consult the createlang documentation to see
the correct order of options and arguments. It works fine here with
.pgpass if the syntax is correct; have you run "createlang --version"
to verify that you're running the 8.0.4 version?

--
Michael Fuhr