Postgresql connect into windows server

From: Yuriy Rusinov <yrusinov(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql connect into windows server
Date: 2011-12-14 05:27:58
Message-ID: CAA5U4syx_m-k7X8fDr+gYGdCSJmx5Fgnv6v98PX184yVUgEZUQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-12-14 05:32:28 Re: Postgresql connect into windows server
Previous Message Craig Ringer 2011-12-14 05:22:32 Re: Having Issue Getting the Postgresql Service to Start