Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 4FEF29FA318 for ; Thu, 26 Oct 2006 12:53:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 37550-03 for ; Thu, 26 Oct 2006 15:52:20 +0000 (UTC) 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 3657E9FA38F for ; Thu, 26 Oct 2006 12:52:19 -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 k9QFqN5B024513; Thu, 26 Oct 2006 18:52:23 +0300 Received: (from www@localhost) by wwwmail3.joensuu.fi (8.12.10/8.12.10/Submit) id k9QFqNd5024512; Thu, 26 Oct 2006 18:52:23 +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 18:52:23 +0300 Message-ID: <1161877943.4540d9b7b6215@wwwmail.joensuu.fi> Date: Thu, 26 Oct 2006 18:52:23 +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> 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.201 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200610/182 X-Sequence-Number: 23485 Quoting Ben Suffolk : > >>>> actually have done anything. > >>> > >>> thank you for your reply. A truly amateurish mistake by me :) > >>> > >>> BUT fixing that one did no good. The problem remains. > >> > >> Did you restart the server after changing those lines? > >> > >> -- > > > > Yes. > > When you try and connect check /var/log/messages for any errors, and > let us know what (if any) errors are reported. > 1) These are the latest messages ( /var/log/messages ) Only my test of closing down & reopening postgresql. Oct 26 18:33:25 joymap su(pam_unix)[4901]: session opened for user postgres by root(uid=0) Oct 26 18:33:25 joymap su(pam_unix)[4901]: session closed for user postgres Oct 26 18:33:33 joymap postgresql: postmaster shutdown succeeded Oct 26 18:33:35 joymap su(pam_unix)[4951]: session opened for user postgres by root(uid=0) Oct 26 18:33:35 joymap su(pam_unix)[4951]: session closed for user postgres 2) Enrico's firewall propotion: There is a firewall in WinXP ( F-Secure ). I allready tried disabling it. I have also configured the Red Hat security level. Right now it allows all traffic thru eth0. 3) I managed to get a connection-lookalike: netstat print: tcp 0 0 :postgres :2429 TIME_WAIT What next?