Message-ID: <38432118.6BE2A13@wgcr.org>
Date: Mon, 29 Nov 1999 19:58:00 -0500
From: Lamar Owen <lamar.owen@wgcr.org>
Organization: WGCR Internet Radio
MIME-Version: 1.0
To: Bill Barnes <bbarnes@operamail.com>
CC: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] pgaccess on win95 connection
References: <3849708B@operamail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Bill Barnes wrote:
> >2.)    On the server machine, in the file '/var/lib/pgsql/pg_hba.conf', you
> >will need to add a line allowing access to the database from the IP
> >address or hostname of the Windows machine. If I remember correctly, you

> Found in this file 2 lines:
>   'local              all
>           trust'
>   'host              all              127.0.0.1         255.255.255.255.
> trust'
> While this is not the ultimate security :-) doesn't it render the host
> accessible.

No, it doesn't.  This only allows access to localhost.  Assume for a
minute that the Windows machine is address 10.21.34.98. You need a line:
host	all	10.21.34.98	255.255.255.255

To give access to all hosts on the 10.21.34.0 network access:
host	all	10.21.34.0	255.255.255.0

> Looks like I've got to do something here before I can go any farther.

Yes, it does.

> Thanks.  I will look for these.  And resurrect my Windows manuals.
> Started this effort with what I thought was lots of lead time.  But you know
> what a Linux adventure is like.  Consequently, I have less time now for both
> application development and basic research.  So, what's new?

I remember well my adventure setting up PostgreSQL (then at version
6.1.1) on Linux to back a web server.  The documentation wasn't as good
then, however.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11