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 <[EMAIL PROTECTED]> 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