Обсуждение: Postgresql connect into windows server
Hello, All ! I have 2 machines with Gentoo Linux its ip is 192.168.17.109 and Windows XP ip is 192.168.17.124 Postgresql 9.0.1 was installed on both machines. If I connect from Windows machine onto Linux machine all works fine. pg_hba.conf on linux machine is local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust host all all 192.168.17.1/24 trust But if I connect from linux machine onto postgresql windows I receive error message Connection timed out. Is the server running on host "192.168.17.124" and accepting TCP/IP connections on port 5432?" Its pg_hba.conf is host all all 127.0.0.1/32 md5 host all all 192.168.17.109/32 trust host all all 192.168.17.1/24 trust postgresql.conf is listen_addresses = '*' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost', '*' = all # (change requires restart) port = 5432 # (change requires restart) max_connections = 100 But pg_admin on windows successfully works on both servers. Any ideas ? Thanks in advance. -- Best regards, Sincerely yours, Yuriy Rusinov.
On 12/13/11 9:27 PM, Yuriy Rusinov wrote: > But pg_admin on windows successfully works on both servers. > Any ideas ? is a windows firewall blocking incoming connections on port 5432/tcp ? -- john r pierce N 37, W 122 santa cruz ca mid-left coast
Hello ! >> >> But pg_admin on windows successfully works on both servers. >> Any ideas ? > > > is a windows firewall blocking incoming connections on port 5432/tcp ? > Possible yes, but which way I have to verify it ? -- Best regards, Sincerely yours, Yuriy Rusinov.
On Dec 14, 2011, at 0:40, Yuriy Rusinov <yrusinov@gmail.com> wrote: > Hello ! > >>> >>> But pg_admin on windows successfully works on both servers. >>> Any ideas ? >> >> >> is a windows firewall blocking incoming connections on port 5432/tcp ? >> > > Possible yes, but which way I have to verify it ? > > Turn off the firewall and see if it works...
Hello, All ! >> >>>> >>>> But pg_admin on windows successfully works on both servers. >>>> Any ideas ? >>> >>> >>> is a windows firewall blocking incoming connections on port 5432/tcp ? >>> >> >> Possible yes, but which way I have to verify it ? When I add rule for 5432/tcp port, all works fine. Thanks a lot. -- Best regards, Sincerely yours, Yuriy Rusinov.