Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues

This brings up something that I may have asked before, but I may also
have just thought I should: Should/could we have the error message
somehow reflect if the connection used pgpass.conf to pick up the
password?

//Magnus

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org [mailto:pgsql-hackers-
> owner(at)postgresql(dot)org] On Behalf Of Jeanna Geier
> Sent: Tuesday, September 26, 2006 7:51 PM
> To: Jeff Frost; Alvaro Herrera
> Cc: Tom Lane; pgsql-admin(at)postgresql(dot)org; pgsql-
> hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] [ADMIN] pg_hba.conf: 'trust' vs. 'md5'
> Issues
>
> Thank you, Thank you, Thank you!! :o)
>
> Jeff - Thanks in particular for your help on this, it is greatly
> appreciated!
>
> It was a hidden folder, but not anymore!! I found the file and re-
> set the password for the 'postgres' user and can now connect using
> my 'md5' hostssl
> connection:
>
> hostssl all all 127.0.0.1/32 md5
> ______________________________
>
> C:\msys\1.0\local\pgsql\bin>psql -d apt -U postgres
> Password:
> Welcome to psql 8.0.8, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
>
> Warning: Console code page (437) differs from Windows code page
> (1252)
> 8-bit characters may not work correctly. See psql
> reference
> page "Notes for Windows users" for details.
>
> apt=#
>
> Again, thanks for everyone's time and effort on this! This mailing
> list is top-notch!!
> -Jeanna
>
> ----- Original Message -----
> From: "Jeff Frost" <jeff(at)frostconsultingllc(dot)com>
> To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
> Cc: "Jeanna Geier" <jgeier(at)apt-cafm(dot)com>; "Tom Lane"
> <tgl(at)sss(dot)pgh(dot)pa(dot)us>; <pgsql-admin(at)postgresql(dot)org>; <pgsql-
> hackers(at)postgresql(dot)org>
> Sent: Tuesday, September 26, 2006 12:35 PM
> Subject: Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues
>
>
> > On Tue, 26 Sep 2006, Alvaro Herrera wrote:
> >
> >> Jeanna Geier wrote:
> >>> Searched again for 'pgpass' and for the 'Application Data'
> directory
> >>> with no luck...
> >>
> >> The file is called "pgpass.conf" on Windows. As for the
> "Application
> >> Data", it may be called differently if your Windows is localized
> --
> >> try looking for %APPDATA%. (I think I'd do this by opening a
> >> terminal window and "echo %APPDATA%" or "cd %APPDATA%").
> >
> > You can also just click start, run then type %appdata% and
> windows
> > will open an explorer window in that directory. I guess it's
> also
> > possible you need to turn on the view hidden and system
> directories in
> > the explorer options to see/find in that directory, but I'm not
> sure.
> >
> > --
> > Jeff 'Frosty' Frost - AFM #996 - Frost Consulting, LLC Racing
> > http://www.frostconsultingllc.com/ http://www.motonation.com/
> > http://www.suomy-usa.com/ http://www.motionpro.com/
> > http://www.motorexusa.com/ http://www.lockhartphillipsusa.com/
> > http://www.zoomzoomtrackdays.com/ http://www.braking.com/
> >
> >
>
>
> ---------------------------(end of broadcast)----------------------
> -----
> TIP 9: In versions below 8.0, the planner will ignore your desire
> to
> choose an index scan if your joining column's datatypes do
> not
> match