password reset

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