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

Re: psql: FATAL: Password authentication failed for

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Sudhakar Kurumella <kurumella(at)yahoo(dot)com>
Cc: pg(at)fastcrypt(dot)com,"pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql: FATAL: Password authentication failed for
Date: 2004-09-21 13:47:57
Message-ID: 4150310D.6050006@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers
Which database are you trying to connect to?

try:
  psql -U postgres template1
or
  psql -U postgres -W template1
and see what happens

cheers

andrew

Sudhakar Kurumella wrote:

> I tried that, the error is the same but with user "postgres"
>  
> [D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres
> psql: FATAL:  Password authentication failed for user "postgres"
>  
> It is not taking my password if i give option with "-W" as well.
>  
> [D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres -W password
> psql: FATAL:  Password authentication failed for user "postgres"
>  
> thanks,
> kuru
>  
>
>
> */Dave Cramer <pg(at)fastcrypt(dot)com>/* wrote:
>
>     Use psql -U postgres
>
>     Dave
>     On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:
>     > Hi,
>     >
>     > I am using postgresql windows based "8.0-beta2-dev3". I have
>     provided
>     > default user and password while installing. When i am trying to
>     > connecto to psql through dos command prompt, i am getting following
>     > error:
>     >
>     > [D:\Postgresql\8.0-beta2-dev3\bin]psql
>     > psql: FATAL: Password authentication failed for user "Administrator"
>     >
>     > I dont have user named "Administrator", i have only user "postgres"
>     > and my "pg_hba.conf" details are:
>     >
>     > # TYPE DATABASE USER CIDR-ADDRESS METHOD
>     > local all postgres md5
>     > # IPv4-style local connections:
>     > host all all 127.0.0.1/32 md5
>     > # IPv6-style local connections:
>     > #host all all ::1/128 md5
>     >
>     > My question is how to connect postgres through the dos command
>     prompt,
>     > to use commands such as pg_dump etc..
>     >
>
>

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-09-21 13:52:50
Subject: Re: SSL Support
Previous:From: Tom LaneDate: 2004-09-21 13:47:05
Subject: Re: Disabling bgwriter on my notebook

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