Richard Huxton <dev@archonet.com> writes:
> "Thomas T. Veldhouse" wrote:
>> Why does it ask 4 times?
> createlang is just a script - it basically runs "/path/to/psql $QUERY" -
> each query connects a separate time.
Note that running a setup that requires password auth for the DBA will
also be a major pain in the rear when running pg_dumpall: one password
prompt per database, IIRC. We have other scripts that make more than
one database connection, too.
I'd counsel using a setup that avoids passwords for local connections.
One way to do this is to run an ident daemon and use IDENT authorization
for connections from 127.0.0.1. This allows "psql -h localhost" to work
without a password. (IDENT authorization is quite properly discouraged
for remote connections, but it's trustworthy enough on your own machine,
if you control the ident daemon or trust the person who does.)
regards, tom lane