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

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!

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 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!

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:

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!

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

cheers

andrew

Laszlo Hornyak 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:

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

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!

try

host all all 127.0.0.1/32 trust

restart the server, then try to connect.

Sudhakar Kurumella wrote:

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!