Re: ip connection on local p2p network

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!
>
>