Re: whats the deal with -u ? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: whats the deal with -u ?
Date
Msg-id 20071210020518.GB7240@alvh.no-ip.org
Whole thread Raw
In response to Re: whats the deal with -u ?  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark wrote:
> "Tom Lane" <tgl@sss.pgh.pa.us> writes:
> 
> > Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> >> I have never understood what's the point of having an option to force a
> >> password prompt.  I wonder why don't we deprecate -W?
> >
> > It's not *completely* useless, because you only need one connection
> > attempt not two --- normally, psql gets rejected once before figuring
> > out that it must ask for a password.  
> 
> Hm, I wonder if this fixes one of the annoyances of kerberos support. If you
> have kerberos tickets psql uses the principal name from them rather than your
> unix username. If you don't actually use kerberos authentication for your
> postgres server then that means you have to specify the user on the command
> line all the time.

Huh, isn't this solved by just setting PGUSER?  (In any case I doubt -W
has any effect on it.)

-- 
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"La vida es para el que se aventura"


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: whats the deal with -u ?
Next
From: Alvaro Herrera
Date:
Subject: Re: [BUGS] BUG #3799: csvlog skips some logs