Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues
От | Magnus Hagander |
---|---|
Тема | Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues |
Дата | |
Msg-id | 6BCB9D8A16AC4241919521715F4D8BCEA35735@algol.sollentuna.se обсуждение исходный текст |
Ответ на | Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues ("Jeanna Geier" <jgeier@apt-cafm.com>) |
Список | 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
В списке pgsql-hackers по дате отправления: