RE: [INTERFACES] pgaccess on win95 connection - Mailing list pgsql-interfaces

>
>Ok.  It looks to me like you are trying to do the following:
>
>You have a Mandrake 6.1 machine on your LAN running PostgreSQL.  You
>further have a Windows machine on your LAN, from which you want to
>connect to PostgreSQL running on the Mandrake 6.1 machine.
>
>To do this:
>1.)    In the pgaccess connection box, you will need to enter the hostname
>or IP address of the server machine, not 'localhost'.
>
>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
>can cause the postmaster to reread the pg_hba.conf file with a SIGHUP
>sent to the postmaster process -- however, since it is apparent that you
>are not very familiar with Unix-like systems, I recommend that you
>restart the postmaster by executing, as root,
>'/etc/rc.d/init.d/postgresql restart' -- this will completely restart
>the postmaster.

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.

The problem may be in Windows. 'ping' reports the target machine unreachable.
Tried to ping my ISP and get the same response.
Looks like I've got to do something here before I can go any farther.

>Now try the connect again.
>
>You can test whether the server is up or not by, in Windows, going to a
>DOS prompt and executing 'ping' with the server's IP address.
>
>You will also need to get a book on Unix administration; the O'Reilly
>classic 'Essential System Administration' is a good start (www.ora.com).
>Administering the PostgreSQL database requires a good knowledge of basic
>system administration procedures -- and this O'Reilly book is one of the
>best introductory sysadmin books you will find.  I also recommend
>reading Bruce's book when it is complete -- the current draft is
>available on the www.postgresql.org site.
>
>And there's always the PostgreSQL documentation, which is installed by
>default in the RPM installation in the directory
>'/usr/doc/postgresql-6.5.3' -- since you are using Mandrake 6.1, just
>point kfm over there, and browse around -- there is a complete copy of
>the documentation there.
>
>Hope that helps.

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?

Thanks
Bill Barnes
>
>--
>Lamar Owen
>WGCR Internet Radio
>1 Peter 4:11

------------------------------------------------------------
This e-mail has been sent to  you  courtesy of OperaMail,  a
free  web-based  service  from  Opera  Software,  makers  of
the award-winning Web Browser - http://www.operasoftware.com
------------------------------------------------------------


************