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@xxxxxxxxxxxxxxxxxxxxxx>
To: "Alvaro Herrera" <alvherre@xxxxxxxxxxxxxxxxx>
Cc: "Jeanna Geier" <jgeier@xxxxxxxxxxxx>; "Tom Lane" <tgl@xxxxxxxxxxxxx>;
<pgsql-admin@xxxxxxxxxxxxxx>; <pgsql-hackers@xxxxxxxxxxxxxx>
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/
