Обсуждение: telnet to port 5432 failed

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Have Database server running in RHE3. postgresql.conf was changed to set tcp_ip=true. Pg_hba.conf
waschanged to allow my windows machine to access the database. Running “telnet localhost 5432” in linux shows connected
tolocalhost. From my windows end, I can telnet to linux box successfully, it gives the error of “could not open the
connectionto host on port 5432” when I run “telnet linux_ip 5432”</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">What could be the problem?</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="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">Cynthia</span></font></div>

On Thu, 23 Sep 2004, Qi, Xlaoyan wrote:

> Have Database server running in RHE3. postgresql.conf was changed to set
> tcp_ip=true. Pg_hba.conf was changed to allow my windows machine to
> access the database. Running "telnet localhost 5432" in linux shows
> connected to localhost. From my windows end, I can telnet to linux box
> successfully, it gives the error of "could not open the connection to
> host on port 5432" when I run "telnet linux_ip 5432"
>

Perhaps a firewall?  Setting the virtual_host parameter in
postgresql.conf?

Can you connect from the windows to the linux machine for any other
services it offers (not postgresql)?

Kris Jurka

5432 is default port for postgresql. I guess it has been occupied by
someone else. Try to run postgresql at some other ports. Remember to
modify your pg_hba.conf to put database server IP there. Your database then should be
//host:port/dbname.

It works for me.

Yi


On Thu, 23 Sep 2004, Qi, Xlaoyan wrote:

> Have Database server running in RHE3. postgresql.conf was changed to set
> tcp_ip=true. Pg_hba.conf was changed to allow my windows machine to
> access the database. Running "telnet localhost 5432" in linux shows
> connected to localhost. From my windows end, I can telnet to linux box
> successfully, it gives the error of "could not open the connection to
> host on port 5432" when I run "telnet linux_ip 5432"
>
> What could be the problem?
>
> Thanks.
>
>
>
> Cynthia
>
>