pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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/
>
> 




view thread (21+ messages)  latest in thread

Message-ID: <022401c6e194$5881f880$6700a8c0@geier>
Permalink:  ../022401c6e194$5881f880$6700a8c0@geier/
Also on:    postgresql.org/message-id/022401c6e194$5881f880$6700a8c0@geier

 · 

reply

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