Re: password reset - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: password reset
Date
Msg-id 20060523153336.GF64371@pervasive.com
Whole thread Raw
In response to password reset  ("venu Vempati" <venu.vempati@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: functions and plans
Next
From: Marc Munro
Date:
Subject: Spontaneous character encoding change?