From: Jeanna Geier <jgeier@apt-cafm.com>
To: Jeff Frost <jeff@frostconsultingllc.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: Re: pg_hba.conf: 'trust' vs. 'md5' Issues
Date: Tue, 26 Sep 2006 12:51:06 -0500
Message-ID: <022401c6e194$5881f880$6700a8c0@geier> (raw)
References: <26303.1159285959@sss.pgh.pa.us>
<Pine.LNX.4.64.0609260854280.32444@discord.home.frostconsultingllc.com>
<Pine.LNX.4.64.0609260900150.32444@discord.home.frostconsultingllc.com>
<26555.1159286780@sss.pgh.pa.us>
<Pine.LNX.4.64.0609260910030.32444@discord.home.frostconsultingllc.com>
<26939.1159288367@sss.pgh.pa.us>
<Pine.LNX.4.64.0609260938110.32444@discord.home.frostconsultingllc.com>
<01e601c6e18f$02c9f280$6700a8c0@geier>
<Pine.LNX.4.64.0609261015010.32444@discord.home.frostconsultingllc.com>
<01f801c6e190$9cac36f0$6700a8c0@geier>
<20060926173032.GA17177@alvh.no-ip.org>
<Pine.LNX.4.64.0609261033410.32444@discord.home.frostconsultingllc.com>
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/
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jgeier@apt-cafm.com, jeff@frostconsultingllc.com, alvherre@commandprompt.com, tgl@sss.pgh.pa.us, pgsql-hackers@postgresql.org
Subject: Re: pg_hba.conf: 'trust' vs. 'md5' Issues
In-Reply-To: <022401c6e194$5881f880$6700a8c0@geier>
References: <26303.1159285959@sss.pgh.pa.us> <Pine.LNX.4.64.0609260854280.32444@discord.home.frostconsultingllc.com> <Pine.LNX.4.64.0609260900150.32444@discord.home.frostconsultingllc.com> <26555.1159286780@sss.pgh.pa.us> <Pine.LNX.4.64.0609260910030.32444@discord.home.frostconsultingllc.com> <26939.1159288367@sss.pgh.pa.us> <Pine.LNX.4.64.0609260938110.32444@discord.home.frostconsultingllc.com> <01e601c6e18f$02c9f280$6700a8c0@geier> <Pine.LNX.4.64.0609261015010.32444@discord.home.frostconsultingllc.com> <01f801c6e190$9cac36f0$6700a8c0@geier> <20060926173032.GA17177@alvh.no-ip.org> <Pine.LNX.4.64.0609261033410.32444@discord.home.frostconsultingllc.com> <022401c6e194$5881f880$6700a8c0@geier>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox