Re: Postgres 7.3 - pg_hba.conf entry for host nof found (it'sthere!)

[letters at hotpop dot com]

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