Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Bug in createlang?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Richard Huxton <dev(at)archonet(dot)com>, "Thomas T(dot) Veldhouse" <veldy(at)veldy(dot)net>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [GENERAL] Bug in createlang?
Date: 2001-07-11 20:33:37
Message-ID: 200107112033.f6BKXbv02864@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-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.)

I just applied a diff to better document the use of ident for localhost.
I think it is a good idea, and in some ways a better use of ident than
for remote machines.  If I missed a spot that could be better
documented, let me know.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-07-11 20:34:39
Subject: Re: I can't keep up
Previous:From: Tom LaneDate: 2001-07-11 20:33:00
Subject: Strangeness in xid allocation / snapshot setup

pgsql-patches by date

Next:From: Mark VolpeDate: 2001-07-11 20:46:32
Subject: Re: Re: [HACKERS] [PATCH] Re: Setuid functions
Previous:From: Bruce MomjianDate: 2001-07-11 20:26:20
Subject: Re: Re: [HACKERS] [PATCH] Re: Setuid functions

pgsql-general by date

Next:From: Adam ManockDate: 2001-07-11 20:42:16
Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?
Previous:From: dennis@zserve.comDate: 2001-07-11 19:47:44
Subject: Table Size/Performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group