Обсуждение: 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.