Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe@cygwin.com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin@cygwin.com>
List-Help: <mailto:cygwin-help@cygwin.com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner@cygwin.com
Mail-Followup-To: cygwin@cygwin.com
Delivered-To: mailing list cygwin@cygwin.com
To: cygwin@cygwin.com
From: letters@hotpop.com
Subject: Re: Postgres 7.3 - pg_hba.conf entry for host nof found (it's
 there!)
Keywords: postgresql,hba,conf,usr,share,cygwin
Date: Sun, 18 May 2003 21:10:28 +0300
In-Reply-To: <20030513173223.GA1764@tishler.net> (Jason Tishler's message of
 "Tue, 13 May 2003 13:32:23 -0400")
Message-ID: <znlkcei3.fsf@blue.sea.net>
User-Agent: Gnus/5.090017 (Oort Gnus v0.17) Emacs/20.7 (windows-nt)
 (i386-*-nt5.0.2195)
References: <jn7k8udd77.fsf@blue.sea.net> <20030513173223.GA1764@tishler.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

* Tue 2003-05-13 Jason Tishler <jason@tishler.net> list.cygwin
* Message-Id: 
| 
| On Tue, May 13, 2003 at 07:27:24PM +0300, letters@hotpop.com wrote:
| > bash$ cat /usr/share/postgresql/pg_hba.conf
| > 
| > # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
| > 
| > [snip]
| > host    all         all         195.148.57.116    255.255.255.255   trust
| 
| The above should enable the connection.  I just tried and it worked for
| me.

| I suggest posting to <pgsql-cygwin@postgresql.org> -- you may get
| better help there.

Thanks, I just subscribed to several lists. It's very nice that you offer news server
access and "no mail" option. I can now use my Emacs to handle the newsserver for
posting to the lists.

For the record, the cucial factor was this line in my previous post.
http://cygwin.com/ml/cygwin/2003-05/msg00829.html

|  bash$ cat /usr/share/postgresql/pg_hba.conf

It was pure luck that I noticed this. I just ahppened to find some post with Google,
where the location of the pg_hba.conf file was important enought.

The configuration as you saw, was perfect, but the correct location is:

    /usr/share/postgresql/data/pg_hba.conf
                         ======

I filed a request to psql-bugs to add this note to the documentation. It's so
easy to miss.

Jari


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

