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..
 
thanks,
kuru
 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
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]psqlpsql: 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..
 
thanks,
kuru
 __________________________________________________Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Tue, 21 Sep 2004 04:38:45 -0700 (PDT)
Sudhakar Kurumella <kurumella@yahoo.com>
psql: FATAL: Password authentication failed for user "Administrator"
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..
>  
> thanks,
> kuru
>  
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
-- 
Dave Cramer
519 939 0336
ICQ # 14675561
www.postgresintl.com


Tue, 21 Sep 2004 08:52:18 -0400
Dave Cramer <pg@fastcrypt.com>
Re: psql: FATAL:  Password authentication failed for
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@fastcrypt.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..
> 
> thanks,
> kuru
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
-- 
Dave Cramer
519 939 0336
ICQ # 14675561
www.postgresintl.com


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

		
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
I tried that, the error is the same but with user "postgres"
 
[D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgrespsql: 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 passwordpsql: FATAL:  Password authentication failed for user "postgres"
 
thanks,
kuru
 
Dave Cramer <pg@fastcrypt.com> wrote:
Use psql -U postgresDaveOn 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..> > thanks,> kuru> > > __________________________________________________> Do You Yahoo!?> Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com -- Dave Cramer519 939 0336ICQ # 14675561www.postgresintl.com---------------------------(end of broadcast)---------------------------TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
Tue, 21 Sep 2004 05:58:25 -0700 (PDT)
Sudhakar Kurumella <kurumella@yahoo.com>
Re: psql: FATAL:  Password authentication failed for

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@fastcrypt.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..
>     >
>
>

Tue, 21 Sep 2004 09:47:57 -0400
Andrew Dunstan <andrew@dunslane.net>
Re: psql: FATAL:  Password authentication failed for
I am trying to connect to database called "sos", i tried as you said:
 
[D:\]psql -U postgres template1
psql: FATAL:  Password authentication failed for user "postgres"
[D:\]psql -U postgres -W template1
psql: FATAL:  Password authentication failed for user "postgres"
[D:\]
 
I got the above error again.
 
thanks,
kuru

Andrew Dunstan <andrew@dunslane.net> wrote:

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 
/* 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..
> >
>
>

		
---------------------------------
Do you Yahoo!?
vote.yahoo.com - Register online to vote today!
I am trying to connect to database called "sos", i tried as you said:
 
[D:\]psql -U postgres template1psql: FATAL:  Password authentication failed for user "postgres"
[D:\]psql -U postgres -W template1psql: FATAL:  Password authentication failed for user "postgres"
[D:\]
 
I got the above error again.
 
thanks,
kuruAndrew Dunstan <andrew@dunslane.net> wrote:
Which database are you trying to connect to?try:psql -U postgres template1orpsql -U postgres -W template1and see what happenscheersandrewSudhakar 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 /* 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..> >>>
Do you Yahoo!?vote.yahoo.com - Register online to vote today!
Tue, 21 Sep 2004 07:21:54 -0700 (PDT)
Sudhakar Kurumella <kurumella@yahoo.com>
Re: psql: FATAL:  Password authentication failed for

You could enable local connections with no password, then connect with
your postgres user, change pwd, and then re-enable security.
use pg_ctl reload for reloading security settings.
Not nice, but quick :)



On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:

> I am trying to connect to database called "sos", i tried as you said:
>
> [D:\]psql -U postgres template1
> psql: FATAL:  Password authentication failed for user "postgres"
> [D:\]psql -U postgres -W template1
> psql: FATAL:  Password authentication failed for user "postgres"
> [D:\]
>
> I got the above error again.
>
> thanks,
> kuru
>
> Andrew Dunstan <andrew@dunslane.net> wrote:
>
> 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
> /* 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..
> > >
> >
> >
>
>
> ---------------------------------
> Do you Yahoo!?
> vote.yahoo.com - Register online to vote today!

Tue, 21 Sep 2004 17:04:03 +0200 (CEST)
Laszlo Hornyak <kocka@forgeahead.hu>
Re: psql: FATAL:  Password authentication failed for
Dear Laszlo,
 
Indeed that is tough, It is highly appreciated if you could explain a bit in detail. I tried with option "password no need" in my server, and also tried remove md5 from pg_hba.conf :

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
local   all         postgres                                                     md5
 
it is not working.
thanks
kuru
Laszlo Hornyak <kocka@forgeahead.hu> wrote:

You could enable local connections with no password, then connect with
your postgres user, change pwd, and then re-enable security.
use pg_ctl reload for reloading security settings.
Not nice, but quick :)



On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:

> I am trying to connect to database called "sos", i tried as you said:
>
> [D:\]psql -U postgres template1
> psql: FATAL: Password authentication failed for user "postgres"
> [D:\]psql -U postgres -W template1
> psql: FATAL: Password authentication failed for user "postgres"
> [D:\]
>
> I got the above error again.
>
> thanks,
> kuru
>
> Andrew Dunstan wrote:
>
> 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
> /* 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..
> > >
> >
> >
>
>
> ---------------------------------
> Do you Yahoo!?
> vote.yahoo.com - Register online to vote today!

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

		
---------------------------------
Do you Yahoo!?
vote.yahoo.com - Register online to vote today!
Dear Laszlo,
 
Indeed that is tough, It is highly appreciated if you could explain a bit in detail. I tried with option "password no need" in my server, and also tried remove md5 from pg_hba.conf :
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
local   all         postgres                                                     md5
 
it is not working.
thanks
kuruLaszlo Hornyak <kocka@forgeahead.hu> wrote:
You could enable local connections with no password, then connect withyour postgres user, change pwd, and then re-enable security.use pg_ctl reload for reloading security settings.Not nice, but quick :)On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:> I am trying to connect to database called "sos", i tried as you said:>> [D:\]psql -U postgres template1> psql: FATAL: Password authentication failed for user "postgres"> [D:\]psql -U postgres -W template1> psql: FATAL: Password authentication failed for user "postgres"> [D:\]>> I got the above error again.>> thanks,> kuru>> Andrew Dunstan wrote:>> 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> /* wrote:> >> > Use psql -U postgres> >> > Dave> > On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:> > > Hi,> > >> > > I am using postgr
 esql
 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..> > >> >> >>>> ---------------------------------> Do you Yahoo!?> vote.yahoo.com - Register online to vote today!---------------------------(end of broadcast)---------------------------TIP 8: explain analyze is your friend
Do you Yahoo!?vote.yahoo.com - Register online to vote today!
Tue, 21 Sep 2004 08:17:02 -0700 (PDT)
Sudhakar Kurumella <kurumella@yahoo.com>
Re: psql: FATAL:  Password authentication failed for

That doesn't answer the question of why he isn't even asked for a password.

cheers

andrew

Laszlo Hornyak wrote:

>You could enable local connections with no password, then connect with
>your postgres user, change pwd, and then re-enable security.
>use pg_ctl reload for reloading security settings.
>Not nice, but quick :)
>
>
>
>On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
>
>  
>
>>I am trying to connect to database called "sos", i tried as you said:
>>
>>[D:\]psql -U postgres template1
>>psql: FATAL:  Password authentication failed for user "postgres"
>>[D:\]psql -U postgres -W template1
>>psql: FATAL:  Password authentication failed for user "postgres"
>>[D:\]
>>
>>I got the above error again.
>>
>>thanks,
>>kuru
>>
>>Andrew Dunstan <andrew@dunslane.net> wrote:
>>
>>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
>>>      
>>>
>>/* 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..
>>>>
>>>>        
>>>>
>>>      
>>>
>>---------------------------------
>>Do you Yahoo!?
>>vote.yahoo.com - Register online to vote today!
>>    
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>  
>

Tue, 21 Sep 2004 11:18:34 -0400
Andrew Dunstan <andrew@dunslane.net>
Re: psql: FATAL:  Password authentication failed for

The "local" line has no effect on Windows - it only has relevance for 
Unix domain socket connections, which Windows does not support.

The line that affects local connections on Windows is "host all all 
127.0.0.1/32 ..."

(We really need to make that crystal clear in the pg_hba.conf ...)

cheers

andrew

Sudhakar Kurumella wrote:

> Dear Laszlo,
>  
> Indeed that is tough, It is highly appreciated if you could explain a 
> bit in detail. I tried with option "password no need" in my server, 
> and also tried remove md5 from pg_hba.conf :
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
> local   all         
> postgres                                                     md5
>  
> it is not working.
> thanks
> kuru
> */Laszlo Hornyak <kocka@forgeahead.hu>/* wrote:
>
>
>     You could enable local connections with no password, then connect with
>     your postgres user, change pwd, and then re-enable security.
>     use pg_ctl reload for reloading security settings.
>     Not nice, but quick :)
>
>
>
>     On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
>
>     > I am trying to connect to database called "sos", i tried as you
>     said:
>     >
>     > [D:\]psql -U postgres template1
>     > psql: FATAL: Password authentication failed for user "postgres"
>     > [D:\]psql -U postgres -W template1
>     > psql: FATAL: Password authentication failed for user "postgres"
>     > [D:\]
>     >
>     > I got the above error again.
>     >
>     > thanks,
>     > kuru
>     >
>     > Andrew Dunstan wrote:
>     >
>     > 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
>     > /* wrote:
>     > >
>     > > Use psql -U postgres
>     > >
>     > > Dave
>     > > On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:
>     > > > Hi,
>     > > >
>     > > > I am using postgr esql 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..
>     > > >
>     > >
>     > >
>     >
>     >
>     > ---------------------------------
>     > Do you Yahoo!?
>     > vote.yahoo.com - Register online to vote today!
>
>     ---------------------------(end of
>     broadcast)---------------------------
>     TIP 8: explain analyze is your friend
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> vote.yahoo.com <http://vote.yahoo.com> - Register online to vote today! 


Tue, 21 Sep 2004 11:33:17 -0400
Andrew Dunstan <andrew@dunslane.net>
Re: psql: FATAL:  Password authentication failed for


On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:

> Dear Laszlo,
>
> Indeed that is tough, It is highly appreciated if you could explain a bit in detail. I tried with option "password no need" in my server, and also tried remove md5 from pg_hba.conf :
>
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
> local   all         postgres                                                     md5
local	all postgres			trust

I never tried it on windows, I guess it is the same.
Well, yes, it is not an ansver, just a possible way to find out the
reason of the error.

Laszlo

>
> it is not working.
> thanks
> kuru
> Laszlo Hornyak <kocka@forgeahead.hu> wrote:
>
> You could enable local connections with no password, then connect with
> your postgres user, change pwd, and then re-enable security.
> use pg_ctl reload for reloading security settings.
> Not nice, but quick :)
>
>
>
> On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
>
> > I am trying to connect to database called "sos", i tried as you said:
> >
> > [D:\]psql -U postgres template1
> > psql: FATAL: Password authentication failed for user "postgres"
> > [D:\]psql -U postgres -W template1
> > psql: FATAL: Password authentication failed for user "postgres"
> > [D:\]
> >
> > I got the above error again.
> >
> > thanks,
> > kuru
> >
> > Andrew Dunstan wrote:
> >
> > 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
> > /* 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..
> > > >
> > >
> > >
> >
> >
> > ---------------------------------
> > Do you Yahoo!?
> > vote.yahoo.com - Register online to vote today!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>
> ---------------------------------
> Do you Yahoo!?
> vote.yahoo.com - Register online to vote today!

Tue, 21 Sep 2004 17:38:43 +0200 (CEST)
Laszlo Hornyak <kocka@forgeahead.hu>
Re: psql: FATAL:  Password authentication failed for
Is there any alternative for me ?...Any suggestinons would be highly appreciated.
 
thanks,
kuru

Andrew Dunstan <andrew@dunslane.net> wrote:

The "local" line has no effect on Windows - it only has relevance for 
Unix domain socket connections, which Windows does not support.

The line that affects local connections on Windows is "host all all 
127.0.0.1/32 ..."

(We really need to make that crystal clear in the pg_hba.conf ...)

cheers

andrew

Sudhakar Kurumella wrote:

> Dear Laszlo,
> 
> Indeed that is tough, It is highly appreciated if you could explain a 
> bit in detail. I tried with option "password no need" in my server, 
> and also tried remove md5 from pg_hba.conf :
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
> local all 
> postgres md5
> 
> it is not working.
> thanks
> kuru
> */Laszlo Hornyak /* wrote:
>
>
> You could enable local connections with no password, then connect with
> your postgres user, change pwd, and then re-enable security.
> use pg_ctl reload for reloading security settings.
> Not nice, but quick :)
>
>
>
> On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
>
> > I am trying to connect to database called "sos", i tried as you
> said:
> >
> > [D:\]psql -U postgres template1
> > psql: FATAL: Password authentication failed for user "postgres"
> > [D:\]psql -U postgres -W template1
> > psql: FATAL: Password authentication failed for user "postgres"
> > [D:\]
> >
> > I got the above error again.
> >
> > thanks,
> > kuru
> >
> > Andrew Dunstan wrote:
> >
> > 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
> > /* wrote:
> > >
> > > Use psql -U postgres
> > >
> > > Dave
> > > On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:
> > > > Hi,
> > > >
> > > > I am using postgr esql 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..
> > > >
> > >
> > >
> >
> >
> > ---------------------------------
> > Do you Yahoo!?
> > vote.yahoo.com - Register online to vote today!
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> vote.yahoo.com - Register online to vote today! 


		
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
Is there any alternative for me ?...Any suggestinons would be highly appreciated.
 
thanks,
kuruAndrew Dunstan <andrew@dunslane.net> wrote:
The "local" line has no effect on Windows - it only has relevance for Unix domain socket connections, which Windows does not support.The line that affects local connections on Windows is "host all all 127.0.0.1/32 ..."(We really need to make that crystal clear in the pg_hba.conf ...)cheersandrewSudhakar Kurumella wrote:> Dear Laszlo,> > Indeed that is tough, It is highly appreciated if you could explain a > bit in detail. I tried with option "password no need" in my server, > and also tried remove md5 from pg_hba.conf :> # TYPE DATABASE USER CIDR-ADDRESS METHOD> local all > postgres md5> > it is not working.> thanks> kuru> */Laszlo Hornyak /* wrote:>>> You could enable local connections with
  no
 password, then connect with> your postgres user, change pwd, and then re-enable security.> use pg_ctl reload for reloading security settings.> Not nice, but quick :)>>>> On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:>> > I am trying to connect to database called "sos", i tried as you> said:> >> > [D:\]psql -U postgres template1> > psql: FATAL: Password authentication failed for user "postgres"> > [D:\]psql -U postgres -W template1> > psql: FATAL: Password authentication failed for user "postgres"> > [D:\]> >> > I got the above error again.> >> > thanks,> > kuru> >> > Andrew Dunstan wrote:> >> > 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> > /* wrote:> > >> > > Use psql -U postgres> > >> > > Dave> &g
 t; >
 On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:> > > > Hi,> > > >> > > > I am using postgr esql 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:&
 gt; >
 > > 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..> > > >> > >> > >> >> >> > ---------------------------------> > Do you Yahoo!?> > vote.yahoo.com - Register online to vote today!>> ---------------------------(end of> broadcast)---------------------------> TIP 8: explain analyze is your friend>> ------------------------------------------------------------------------> Do you Yahoo!?> vote.yahoo.com - Register online to vote today! 
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
Tue, 21 Sep 2004 09:06:45 -0700 (PDT)
Sudhakar Kurumella <kurumella@yahoo.com>
Re: psql: FATAL:  Password authentication failed for

try

  host all all 127.0.0.1/32 trust

restart the server, then try to connect.

Sudhakar Kurumella wrote:

> Is there any alternative for me ?...Any suggestinons would be highly 
> appreciated.
>  
> thanks,
> kuru
>
> */Andrew Dunstan <andrew@dunslane.net>/* wrote:
>
>
>     The "local" line has no effect on Windows - it only has relevance for
>     Unix domain socket connections, which Windows does not support.
>
>     The line that affects local connections on Windows is "host all all
>     127.0.0.1/32 ..."
>
>     (We really need to make that crystal clear in the pg_hba.conf ...)
>
>     cheers
>
>     andrew
>
>     Sudhakar Kurumella wrote:
>
>     > Dear Laszlo,
>     >
>     > Indeed that is tough, It is highly appreciated if you could
>     explain a
>     > bit in detail. I tried with option "password no need" in my server,
>     > and also tried remove md5 from pg_hba.conf :
>     > # TYPE DATABASE USER CIDR-ADDRESS METHOD
>     > local all
>     > postgres md5
>     >
>     > it is not working.
>     > thanks
>     > kuru
>     > */Laszlo Hornyak /* wrote:
>     >
>     >
>     > You could enable local connections with no password, then
>     connect with
>     > your postgres user, change pwd, and then re-enable security.
>     > use pg_ctl reload for reloading security settings.
>     > Not nice, but quick :)
>     >
>     >
>     >
>     > On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
>     >
>     > > I am trying to connect to database called "sos", i tried as you
>     > said:
>     > >
>     > > [D:\]psql -U postgres template1
>     > > psql: FATAL: Password authentication failed for user "postgres"
>     > > [D:\]psql -U postgres -W template1
>     > > psql: FATAL: Password authentication failed for user "postgres"
>     > > [D:\]
>     > >
>     > > I got the above error again.
>     > >
>     > > thanks,
>     > > kuru
>     > >
>     > > Andrew Dunstan wrote:
>     > >
>     > > 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
>     > > /* wrote:
>     > > >
>     > > > Use psql -U postgres
>     > > >
>     > > > Dave
>     > &g t; > On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:
>     > > > > Hi,
>     > > > >
>     > > > > I am using postgr esql 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:
>     & gt; > > > 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..
>     > > > >
>     > > >
>     > > >
>     > >
>     > >
>     > > ---------------------------------
>     > > Do you Yahoo!?
>     > > vote.yahoo.com - Register online to vote today!
>     >
>     > ---------------------------(end of
>     > broadcast)---------------------------
>     > TIP 8: explain analyze is your friend
>     >
>     >
>     ------------------------------------------------------------------------
>     > Do you Yahoo!?
>     > vote.yahoo.com - Register online to vote today!
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Yahoo! Mail 
> <http://us.rd.yahoo.com/mail_us/taglines/50x/*http://promotions.yahoo.com/new_mail/static/efficiency.html> 
> - 50x more storage than other providers! 


Tue, 21 Sep 2004 12:20:23 -0400
Andrew Dunstan <andrew@dunslane.net>
Re: psql: FATAL:  Password authentication failed for
Dear Andrew,
 
Thanks a LOT!!
 
It is working:
 
[D:\]psql -U postgres sos
Welcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.
Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit
Warning: Console codepage (437) differs from windows codepage (1252)
         8-bit characters will not work correctly. See PostgreSQL
         documentation "Installation on Windows" for details.
sos=#


Andrew Dunstan <andrew@dunslane.net> wrote:

try

host all all 127.0.0.1/32 trust

restart the server, then try to connect.

Sudhakar Kurumella wrote:

> Is there any alternative for me ?...Any suggestinons would be highly 
> appreciated.
> 
> thanks,
> kuru
>
> */Andrew Dunstan /* wrote:
>
>
> The "local" line has no effect on Windows - it only has relevance for
> Unix domain socket connections, which Windows does not support.
>
> The line that affects local connections on Windows is "host all all
> 127.0.0.1/32 ..."
>
> (We really need to make that crystal clear in the pg_hba.conf ...)
>
> cheers
>
> andrew
>
> Sudhakar Kurumella wrote:
>
> > Dear Laszlo,
> >
> > Indeed that is tough, It is highly appreciated if you could
> explain a
> > bit in detail. I tried with option "password no need" in my server,
> > and also tried remove md5 from pg_hba.conf :
> > # TYPE DATABASE USER CIDR-ADDRESS METHOD
> > local all
> > postgres md5
> >
> > it is not working.
> > thanks
> > kuru
> > */Laszlo Hornyak /* wrote:
> >
> >
> > You could enable local connections with no password, then
> connect with
> > your postgres user, change pwd, and then re-enable security.
> > use pg_ctl reload for reloading security settings.
> > Not nice, but quick :)
> >
> >
> >
> > On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
> >
> > > I am trying to connect to database called "sos", i tried as you
> > said:
> > >
> > > [D:\]psql -U postgres template1
> > > psql: FATAL: Password authentication failed for user "postgres"
> > > [D:\]psql -U postgres -W template1
> > > psql: FATAL: Password authentication failed for user "postgres"
> > > [D:\]
> > >
> > > I got the above error again.
> > >
> > > thanks,
> > > kuru
> > >
> > > Andrew Dunstan wrote:
> > >
> > > 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
> > > /* wrote:
> > > >
> > > > Use psql -U postgres
> > > >
> > > > Dave
> > &g t; > On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:
> > > > > Hi,
> > > > >
> > > > > I am using postgr esql 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:
> & gt; > > > 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..
> > > > >
> > > >
> > > >
> > >
> > >
> > > ---------------------------------
> > > Do you Yahoo!?
> > > vote.yahoo.com - Register online to vote today!
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> >
> >
> ------------------------------------------------------------------------
> > Do you Yahoo!?
> > vote.yahoo.com - Register online to vote today!
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Yahoo! Mail 
> 
> - 50x more storage than other providers! 


		
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
Dear Andrew,
 
Thanks a LOT!!
 
It is working:
 
[D:\]psql -U postgres sosWelcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.
Type:  \copyright for distribution terms       \h for help with SQL commands       \? for help with psql commands       \g or terminate with semicolon to execute query       \q to quit
Warning: Console codepage (437) differs from windows codepage (1252)         8-bit characters will not work correctly. See PostgreSQL         documentation "Installation on Windows" for details.
sos=#Andrew Dunstan <andrew@dunslane.net> wrote:
tryhost all all 127.0.0.1/32 trustrestart the server, then try to connect.Sudhakar Kurumella wrote:> Is there any alternative for me ?...Any suggestinons would be highly > appreciated.> > thanks,> kuru>> */Andrew Dunstan /* wrote:>>> The "local" line has no effect on Windows - it only has relevance for> Unix domain socket connections, which Windows does not support.>> The line that affects local connections on Windows is "host all all> 127.0.0.1/32 ...">> (We really need to make that crystal clear in the pg_hba.conf ...)>> cheers>> andrew>> Sudhakar Kurumella wrote:>> > Dear Laszlo,> >> > Indeed that is tough, It is highly appreciated if
  you
 could> explain a> > bit in detail. I tried with option "password no need" in my server,> > and also tried remove md5 from pg_hba.conf :> > # TYPE DATABASE USER CIDR-ADDRESS METHOD> > local all> > postgres md5> >> > it is not working.> > thanks> > kuru> > */Laszlo Hornyak /* wrote:> >> >> > You could enable local connections with no password, then> connect with> > your postgres user, change pwd, and then re-enable security.> > use pg_ctl reload for reloading security settings.> > Not nice, but quick :)> >> >> >> > On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:> >> > > I am trying to connect to database called "sos", i tried as you> > said:> > >> > > [D:\]psql -U postgres template1> > > psql: FAT
 AL:
 Password authentication failed for user "postgres"> > > [D:\]psql -U postgres -W template1> > > psql: FATAL: Password authentication failed for user "postgres"> > > [D:\]> > >> > > I got the above error again.> > >> > > thanks,> > > kuru> > >> > > Andrew Dunstan wrote:> > >> > > 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> > > /* wrote:> > > >> > > > Use psql -U postgres> > > >> > > > Dave> > &g t; > On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:> > > > > Hi,> > > > >> > > > > I am using postgr esql 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:> & gt; > > > 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..> > > > >> > > >> > > >> > >> > >> > > ---------------------------------> > > Do you Yahoo!?> > > vote.yahoo.com - Register online to vote today!> >> > ---------------------------(end of> > broadcast)---------------------------> > TIP 8: explain analyze is your friend> >> >> ------------------------------------------------------------------------> > Do you Yahoo!?> > vote.yahoo.com - Register online to vote today!>>
 ------------------------------------------------------------------------> Do you Yahoo!?> Yahoo! Mail > > - 50x more storage than other providers! 
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
Tue, 21 Sep 2004 09:27:05 -0700 (PDT)
Sudhakar Kurumella <kurumella@yahoo.com>
Re: psql: FATAL:  Password authentication failed for