Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group