Re: BUG #2000: psql does not prompt for password

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Mike Grant <mike(dot)grant(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2000: psql does not prompt for password
Date: 2005-12-07 04:58:02
Message-ID: 200512070458.jB74w2r23736@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Mike Grant wrote:
> I get the same thing with 8.0.4, on Windows XP Professional.

I am still confused. I tried 'psql -W test' in the mingw shell window,
and in a 'cmd.exe' window, and both prompted me for a password. I even
tried a command.com window.

Are you using a Cygwin window perhaps?

---------------------------------------------------------------------------

>
> ~Mike
>
> Bruce Momjian wrote:
> > Todd wrote:
> > >
> > > The following bug has been logged online:
> > >
> > > Bug reference: 2000
> > > Logged by: Todd
> > > Email address: tdoolitt(at)comcast(dot)net
> > > PostgreSQL version: 8.1 Beta 4
> > > Operating system: Windows Xp home
> > > Description: psql does not prompt for password
> > > Details:
> > >
> > > psql -U postgres does not prompt for password and responds with...
> > >
> > > psql: FATAL: password authentication failed for user "postgres".
> > >
> > > even when I pass the -W option it doesn't prompt for password and gives me
> > > the error above. I deleted and recreated my cluster and get the same
> > > result. I can connect to the database using PgAdmin as user postgres.
> >
> > I have no idea what is causing this, but I have never heard of this
> > problem before.
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> > + If your life is a hard drive, | 13 Roberts Road
> > + Christ can be your backup. | Newtown Square, Pennsylvania 19073
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: don't forget to increase your free space map settings
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Evan Carroll 2005-12-07 06:03:19 BUG #2097: Union bug.
Previous Message Yoshihisa Nakano 2005-12-07 03:28:14 BUG #2096: bug in a SPI sample document