Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues - Mailing list pgsql-hackers

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@postgresql.org [mailto:pgsql-hackers-
> owner@postgresql.org] On Behalf Of Jeanna Geier
> Sent: Tuesday, September 26, 2006 7:51 PM
> To: Jeff Frost; Alvaro Herrera
> Cc: Tom Lane; pgsql-admin@postgresql.org; pgsql-
> hackers@postgresql.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@frostconsultingllc.com>
> To: "Alvaro Herrera" <alvherre@commandprompt.com>
> Cc: "Jeanna Geier" <jgeier@apt-cafm.com>; "Tom Lane"
> <tgl@sss.pgh.pa.us>; <pgsql-admin@postgresql.org>; <pgsql-
> hackers@postgresql.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