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-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

Reply via email to