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: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] 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- > [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > To: "Alvaro Herrera" <[EMAIL PROTECTED]> > Cc: "Jeanna Geier" <[EMAIL PROTECTED]>; "Tom Lane" > <[EMAIL PROTECTED]>; <pgsql-admin@postgresql.org>; <pgsql- > [EMAIL PROTECTED]> > 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend