From: Lamar Owen <lamar.owen@wgcr.org>
To: Bill Barnes <bbarnes@operamail.com>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] pgaccess on win95 connection
Date: Mon, 29 Nov 1999 19:58:00 -0500
Message-ID: <38432118.6BE2A13@wgcr.org> (raw)
References: <3849708B@operamail.com>
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
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: lamar.owen@wgcr.org, bbarnes@operamail.com
Subject: Re: [INTERFACES] pgaccess on win95 connection
In-Reply-To: <38432118.6BE2A13@wgcr.org>
* 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