Re: Add server error

<br /><br /><div class="gmail_quote">On Wed, Dec 23, 2009 at 15:39, Nicole Lim <span dir="ltr"><<a
href="mailto:nicole.lim@ocean-is.com">nicole.lim@ocean-is.com</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Hi there,<br /><br />
Ihave problem to add server by using the IP address like 192.168.xxx.xxx. It says the server refused to listen. I
followedthe guide by adding the line at the pg-hba but still the same.<br /> Also, when I'm using the psqlodbc from the
clientmachine, I can't connect. I can only connect using the Odbc when I'm at the local.<br /><br /> Hope you can give
mesome insight.<br /><br /> Thanks,<br /> Nicole.<br /><font color="#888888"></font><br /></blockquote></div><br
/>Checkfile postgresql.conf on the server. There are 2 settings,  listen_addresses and port, which define where the
serverwill be listening to connections. Default is localhost on port 5432.<br /> You should change it to:<br /><br
/><divstyle="margin-left: 40px;">listen_addresses = '*'    # means listen on every IP<br />port = 5432                 
#change only if its being used already by other apps<br /></div><br /> Afterwards, verify the line you added to
pg_hba.conflooks like this:<br /><br /><div style="margin-left: 40px;">host    all         all         <a
href="http://192.168.0.0/16">192.168.0.0/16</a>          md5<br /></div><br />This will enable a client from network
192.168.x.xto connect with any user to any database. MD5 password check will be enforced.<br /><br />Regards,<br
/>Fernando.<br/>