Thread: psql: FATAL: Password authentication failed for user "Administrator"
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"
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
# 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
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"
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"
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 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.. > > > >
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"
psql: FATAL: Password authentication failed for user "postgres"
[D:\]psql -U postgres -W template1
psql: FATAL: Password authentication failed for user "postgres"
psql: FATAL: Password authentication failed for user "postgres"
[D:\]
I got the above error again.
thanks,
kuru
Andrew Dunstan <andrew@dunslane.net> wrote:
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: > 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!
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:
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 - 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: >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 > > >
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!
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!
Is there any alternative for me ?...Any suggestinons would be highly appreciated.
thanks,
kuru
Andrew Dunstan <andrew@dunslane.net> wrote:
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 - 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: > 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!
Dear Andrew,
Thanks a LOT!!
It is working:
[D:\]psql -U postgres sos
Welcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.
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
\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.
8-bit characters will not work correctly. See PostgreSQL
documentation "Installation on Windows" for details.
sos=#
Andrew Dunstan <andrew@dunslane.net> wrote:
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: 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!