Re: password reset

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461