Thread: 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
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