"Tom Lane" <[EMAIL PROTECTED]> writes: > Alvaro Herrera <[EMAIL PROTECTED]> 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! ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate