Re: [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/
>
>