From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | "Thomas T(dot) Veldhouse" <veldy(at)veldy(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Bug in createlang? |
Date: | 2001-06-27 14:24:18 |
Message-ID: | 8129.993651858@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-patches |
Richard Huxton <dev(at)archonet(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2001-06-27 14:29:13 | Re: Red Hat to support PostgreSQL |
Previous Message | Feite Brekeveld | 2001-06-27 14:10:05 | vacuum job taking very long time to complete |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas T. Veldhouse | 2001-06-27 14:32:42 | Re: Bug in createlang? |
Previous Message | Thomas Lockhart | 2001-06-27 14:03:21 | Re: postgresql 7.1.1 and textout and textin |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas T. Veldhouse | 2001-06-27 14:32:42 | Re: Bug in createlang? |
Previous Message | Richard Huxton | 2001-06-27 07:00:01 | Re: Bug in createlang? |