ip connection on local p2p network

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

Shouldn't you be using 192.168.x.x addresses
internally? I don't believe 192.0.x.x is a valid
range for the non-routable non-public ip ranges.

Assuming a single NIC in the server machine, change
listen_addresses to "*" in postgresql.conf to listen
on all interfaces. You may want to tailor the
specific addresses to listen on instead if you have
more than one network.

You'll need to add a line to pg_hba.conf. As an
example, assuming you have 192.168.0.0/255.255.255.0
you'd add a line like "host all all 192.168.0.0/8
md5". That would enable non-ssl connections for all
users/databases and use md5 challenge/response for
password authentication over the wire.

Regards,

Shelby Cain

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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: