Re: whats the deal with -u ?

Gregory Stark wrote:
> "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>
> > Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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"