Re: .pgpass does not work for createlang - Mailing list pgsql-bugs

From Tom Lane
Subject Re: .pgpass does not work for createlang
Date
Msg-id 24175.1129066874@sss.pgh.pa.us
Whole thread Raw
In response to Re: .pgpass does not work for createlang  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
Michael Fuhr <mike@fuhr.org> writes:
> On Tue, Oct 11, 2005 at 11:16:40AM -0700, John Shin wrote:
>> Tried many diffent ways but nothing seems to stick for createlang.
>> .pgpass works for all others (createdb, dropdb, createuser, dropuser,
>> etc.)

>> -bash-3.00$ createdb test -h localhost -U postgres
>> CREATE DATABASE

> Hmmm...this command fails with "too many command-line arguments"
> on both FreeBSD and Solaris (8.0.4 built from source on both), so
> I wonder if your build is using a getopt_long() that behaves
> differently than what I'm using.  Might not matter, though.

That syntax does work for me on FC4, so probably the issue is GNU
getopt_long versus other implementations (likely, our own port/ code).
I don't think it's relevant though, since John exhibited a failure
even while using the "standard" command line syntax.

The whole thing is more than passing strange.  createlang uses exactly
the same connection code as the other "scripts" binaries, so there's
no obvious reason why it would behave differently.  I concur with the
suggestion to try strace'ing it and see where the behavior starts to
vary from, say, createdb.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: .pgpass does not work for createlang
Next
From: "Jim C. Nasby"
Date:
Subject: Re: My investigations of the postmaster Bus error