Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AD3AA9FB478 for ; Thu, 26 Oct 2006 14:05:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 62845-02-5 for ; Thu, 26 Oct 2006 14:05:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wwwmail3.joensuu.fi (wwwmail3.Joensuu.FI [193.167.41.4]) by postgresql.org (Postfix) with ESMTP id 2C9099FB49E for ; Thu, 26 Oct 2006 13:35:57 -0300 (ADT) Received: from wwwmail3.joensuu.fi (localhost.localdomain [127.0.0.1]) by wwwmail3.joensuu.fi (8.12.10/8.12.10) with ESMTP id k9QGZx5B026307; Thu, 26 Oct 2006 19:35:59 +0300 Received: (from www@localhost) by wwwmail3.joensuu.fi (8.12.10/8.12.10/Submit) id k9QGZxWI026306; Thu, 26 Oct 2006 19:35:59 +0300 X-Authentication-Warning: wwwmail3.joensuu.fi: www set sender to jari.vauhkonen@joensuu.fi using -f Received: from metsapc123.joensuu.fi (metsapc123.joensuu.fi [193.167.44.123]) by wwwmail.joensuu.fi (IMP) with HTTP for ; Thu, 26 Oct 2006 19:35:59 +0300 Message-ID: <1161880559.4540e3ef28106@wwwmail.joensuu.fi> Date: Thu, 26 Oct 2006 19:35:59 +0300 From: Jari Vauhkonen To: Ben Suffolk Cc: pgsql-admin@postgresql.org Subject: Re: TCP/IP connection problem References: <1161867721.4540b1c933417@wwwmail.joensuu.fi> <60FA14B7-0C97-47FF-90BC-5B3DA77DC5C3@vanilla.net> <1161876175.4540d2cf3f0b0@wwwmail.joensuu.fi> <20061026152611.GA31183@alvh.no-ip.org> <1161876543.4540d43fe1969@wwwmail.joensuu.fi> <1161877943.4540d9b7b6215@wwwmail.joensuu.fi> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200610/188 X-Sequence-Number: 23491 Quoting Ben Suffolk : > > > I suggest you try and connect from the pgsql machine locally using > tcp :- > > > psql -h = same.host.as.configured.from.windows.box -p = 5432 db user > > Then we can see if the problem still lies with pgsql, or with the > firewall. > Ben, All right. Now it works. I tested your suggestion and found out from logfiles that my pg_hba.conf file was quite corrupted ( i.e. invalid IP masks ) . I re-arranged the file, tested, re-arranged again... and finally, it works. Thanks to everyone who helped. I hope all of you didn't get too annoyed with all these "PRESS ANYKEY" - "Hey, where's the anykey???" -styled questions of mine. Jari