add the following to pg_hba.conf
host all all 192.0.0.0/8 md5
this will let every PC on you network access the PC
or you could add one entry for each host you would like to have access
host all all 192.0.0.101/32 md5
host all all 192.0.0.102/32 md5
If you don't want to use a password, change md5 to trust.
finally you must modify the postgresql.conf file like so:
(this is what it looks like by default)
#listen_addresses = 'localhost' # what IP interface(s) to listen on;
# defaults to localhost, '*' = any
change it to this:
listen_addresses = '*' # what IP interface(s) to listen on;
# defaults to localhost, '*' = any
notice the listen_addresses is uncommented.
That's all you need to do.
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql 8.x
http://www.amsoftwaredesign.com
typing80wpm@aol.com wrote:
> I just installed the windows postgresql on one of the five machines in
> our office, which happens to be 192.0.0.9 according to ipconfig. I
> have installed pg explorer on another machine which happens to be
> 192.0.0.101 .... What changes do I have to make in the various .conf
> files for the postgresql server, (and in pg explorer) so that I can
> connect to the server from the other workstation, hence proving to
> myself that I could use postgres on our small office network. Thanks
> for your help!
>
>