Re: whats the deal with -u ?

"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.

Don't actually have a psql built with kerberos authentication handy but I'll
try to remember to test this the next time I do.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!