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

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