Обсуждение: Network access problem

<div class="Section1"><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span style="font-size:
10.0pt;font-family:"Trebuchet MS"">Hello,</span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS""> </span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS"">I have installed PostGreSql on my machine. Then I changed “postgresql.conf” file to
allowdatabase access over a network.</span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS""> </span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS"">I modified #listen_addresses from localhost to *</span></font><p
class="MsoNormal"><fontface="Trebuchet MS" size="2"><span style="font-size: 
10.0pt;font-family:"Trebuchet MS""> </span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS"">#listen_addresses = ‘*’   # what IP interface(s) to listen on; </span></font><p
class="MsoNormal"><fontface="Trebuchet MS" size="2"><span style="font-size: 
10.0pt;font-family:"Trebuchet MS"">                                                # defaults to localhost, '*' =
any</span></font><pclass="MsoNormal"><font face="Trebuchet MS" size="2"><span style="font-size: 
10.0pt;font-family:"Trebuchet MS"">port = 5432</span></font><p class="MsoNormal"><font face="Trebuchet MS"
size="2"><spanstyle="font-size: 
10.0pt;font-family:"Trebuchet MS""> </span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS""> </span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS"">Still my database is not accessible on a network.</span></font><p
class="MsoNormal"><fontface="Trebuchet MS" size="2"><span style="font-size: 
10.0pt;font-family:"Trebuchet MS""> </span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS"">I m using PgSqlClient ADO.NET compliant driver. </span></font><p
class="MsoNormal"><fontface="Trebuchet MS" size="2"><span style="font-size: 
10.0pt;font-family:"Trebuchet MS""> </span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS"">The application is working fine locally. I m able to connect to database  but over a
networkit fails.</span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span style="font-size: 
10.0pt;font-family:"Trebuchet MS""> </span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS"">Do I need to do modify any other configuration settings?</span></font><p
class="MsoNormal"><fontface="Trebuchet MS" size="2"><span style="font-size: 
10.0pt;font-family:"Trebuchet MS""> </span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS"">Please let me know if there are any other configuration changes. </span></font><p
class="MsoNormal"><fontface="Trebuchet MS" size="2"><span style="font-size: 
10.0pt;font-family:"Trebuchet MS""> </span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span
style="font-size:
10.0pt;font-family:"Trebuchet MS"">I am using this on Windows 2000.</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Thanks,</span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span style="font-size:
10.0pt;font-family:"Trebuchet MS"">..<br /> Yogesh</span></font><p class="MsoNormal"><font face="Times New Roman"
size="3"><spanstyle="font-size: 
12.0pt"> </span></font><p class="MsoNormal"><font face="Trebuchet MS" size="2"><span style="font-size:
10.0pt;font-family:"Trebuchet MS"">call @ 55020371 ext 229</span></font><p class="MsoNormal"><font face="Times New
Roman"size="3"><span style="font-size: 
12.0pt"> </span></font></div><p><p>DISCLAIMER:<br />This message contains privileged and confidential information and
isintended only for the individual named.If you are not the intended recipient you should not
disseminate,distribute,store,print,copy or deliver this message.Please notify the sender immediately by e-mail if you
havereceived this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to
besecure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or
containviruses.The sender therefore does not accept liability for any errors or omissions in the contents of this
messagewhich arise as a result of e-mail transmission. If verification is required please request a hard-copy version.  

hi!

please also try uncommenting the listen_addresses line, ie. to:
listen_addresses = '*'

then reload the configuration or restart the server and try again.

regards,
M

Joshi.Yogesh@iflexsolutions.com wrote:
> I have installed PostGreSql on my machine. Then I changed 
> “postgresql.conf” file to allow database access over a network.
> 
>  
> 
> I modified #listen_addresses from localhost to *
> #listen_addresses = ‘*’   # what IP interface(s) to listen on;
>                                                 # defaults to localhost, 
> '*' = any
> port = 5432
> 
> Still my database is not accessible on a network.
> 
> I m using PgSqlClient ADO.NET compliant driver.
> 
> The application is working fine locally. I m able to connect to 
> database  but over a network it fails.
> 
> Do I need to do modify any other configuration settings?
> 
> Please let me know if there are any other configuration changes.
> 
> I am using this on Windows 2000.