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