Search Postgresql Archives

Re: ip connection on local p2p network

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



--- typing80wpm@xxxxxxx 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 

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux