Обсуждение: password reset

Hi group,
thanks for your previous response about the DB storage in postgres.

now, I have a question for a password related issue.As you can see I have problems with my pwd.
Either I forgot or misconfigured while installing the DB.I have loged in to XP as the user "vgopal" and it's the Admin account for XP.

C:\Program Files\PostgreSQL\8.1\bin>psql
Password:
psql: FATAL:  password authentication failed for user "vgopal"

what are the options do I have?
1.reset pwd.! how?
2.I can't even create another user/role
(createuser: could not connect to database postgres: FATAL:  password authentication failed for user "vgopal")

Thanks in advance.
BRs,
--Venu

On Tue, 23 May 2006 17:03:14 +0200
"venu Vempati" <venu.vempati@gmail.com> wrote:

> Hi group,
> thanks for your previous response about the DB storage in postgres.
>
> now, I have a question for a password related issue.As you can see I have
> problems with my pwd.
> Either I forgot or misconfigured while installing the DB.I have loged in to
> XP as the user "vgopal" and it's the Admin account for XP.
>
> C:\Program Files\PostgreSQL\8.1\bin>psql
> Password:
> psql: FATAL:  password authentication failed for user "vgopal"
>
> what are the options do I have?
> 1.reset pwd.! how?
> 2.I can't even create another user/role
> (createuser: could not connect to database postgres: FATAL:  password
> authentication failed for user "vgopal")

You can edit the pg_hba.conf file in PostgreSQL's data directory to change
authentication to "trust" for the local machine.  They'll you'll be able to
log in without a password and you can reset your password, then switch
the pg_hba.conf setting back.

Note that you'll need to restart PostgreSQL for changes to pg_hba.conf to
take effect.

--
Bill Moran
Collaborative Fusion Inc.

On Tue, May 23, 2006 at 05:03:14PM +0200, venu Vempati wrote:
> Hi group,
> thanks for your previous response about the DB storage in postgres.
>
> now, I have a question for a password related issue.As you can see I have
> problems with my pwd.
> Either I forgot or misconfigured while installing the DB.I have loged in to
> XP as the user "vgopal" and it's the Admin account for XP.
>
> C:\Program Files\PostgreSQL\8.1\bin>psql
> Password:
> psql: FATAL:  password authentication failed for user "vgopal"

Easiest thing would be to edit pg_hba.conf and set localhost access to
trust:

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               trust
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461