Re: createlang difficulty.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: speedboy <speedboy(at)nomicrosoft(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: createlang difficulty.
Date: 2001-10-22 23:54:39
Message-ID: 28233.1003794879@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2001-10-23 00:32:29 Re: [GENERAL] To Postgres Devs : Wouldn't changing the select
Previous Message Bruce Momjian 2001-10-22 23:48:04 Re: createlang difficulty.