Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D662A9FB349 for ; Thu, 26 Oct 2006 12:27:02 -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 08214-07 for ; Thu, 26 Oct 2006 12:26:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from lists.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id E950A9FA2A9 for ; Thu, 26 Oct 2006 12:26:56 -0300 (ADT) Received: from alvh.no-ip.org (201-220-123-102.bk10-dsl.surnet.cl [201.220.123.102]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id k9QFQFge002785; Thu, 26 Oct 2006 08:26:16 -0700 Received: by alvh.no-ip.org (Postfix, from userid 1000) id F2ED0C37184; Thu, 26 Oct 2006 12:26:11 -0300 (CLST) Date: Thu, 26 Oct 2006 12:26:11 -0300 From: Alvaro Herrera To: Jari Vauhkonen Cc: Ben Suffolk , pgsql-admin@postgresql.org Subject: Re: TCP/IP connection problem Message-ID: <20061026152611.GA31183@alvh.no-ip.org> Mail-Followup-To: Jari Vauhkonen , Ben Suffolk , pgsql-admin@postgresql.org References: <1161867721.4540b1c933417@wwwmail.joensuu.fi> <60FA14B7-0C97-47FF-90BC-5B3DA77DC5C3@vanilla.net> <1161876175.4540d2cf3f0b0@wwwmail.joensuu.fi> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1161876175.4540d2cf3f0b0@wwwmail.joensuu.fi> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.4, clamav-milter version 0.88.4 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Thu, 26 Oct 2006 08:26:16 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/177 X-Sequence-Number: 23480 Jari Vauhkonen wrote: > Quoting Ben Suffolk : > > > > -- configuring the postgresql.conf wit following lines: > > > #listen_addresses = '*' > > > #port = 5432 > > > #tcpip_socket = true > > > > Jari, > > > > You need to remove the # from the lines, a # comments the line out, > > so although you have set the port and changed the address it will not > > 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? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support