Re: createlang difficulty.

speedboy <speedboy(at)nomicrosoft(dot)org> writes:
> Ok, so it connects four times. From a users perspective that might be
> confusing. Is it possible to only prompt once for the password,

This would require replacing the createlang shell script with a
specialized C program. (Or, perhaps, adding conditional-execution
capability to psql scripts ... which would be very useful but an
awful lot of work.)

It's unlikely to get to the top of anyone's to-do list any time soon,
because the fact of the matter is that if you have Postgres configured
to demand passwords for administrator connections, you're going to have
lots of problems like this. createlang is not the only script that
invokes multiple programs --- pg_dumpall is another example that's
going to be even harder to work around.

The better answer is to arrange things so that local connections don't
need passwords. One fairly portable approach is to run an IDENTD daemon
and use ident auth for TCP connections through 127.0.0.1; then you just
say PGHOST=127.0.0.1 and you're home free.

regards, tom lane