Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E11AB9FB266 for ; Thu, 26 Oct 2006 10:07:20 -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 67277-08-3 for ; Thu, 26 Oct 2006 10:07:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from piglet.vanilla.net (piglet.vanilla.net [193.129.122.201]) by postgresql.org (Postfix) with ESMTP id 939D99FB2FE for ; Thu, 26 Oct 2006 10:07:10 -0300 (ADT) Received: from [10.0.0.13] (82-32-91-140.cable.ubr02.chap.blueyonder.co.uk [82.32.91.140]) (authenticated bits=0) by piglet.vanilla.net (8.13.1/8.13.1) with ESMTP id k9QD6jIq055531 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NO); Thu, 26 Oct 2006 14:06:46 +0100 (BST) (envelope-from ben@vanilla.net) In-Reply-To: <1161867721.4540b1c933417@wwwmail.joensuu.fi> References: <1161867721.4540b1c933417@wwwmail.joensuu.fi> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <60FA14B7-0C97-47FF-90BC-5B3DA77DC5C3@vanilla.net> Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: Ben Suffolk Subject: Re: TCP/IP connection problem Date: Thu, 26 Oct 2006 14:06:44 +0100 To: Jari Vauhkonen X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: ClamAV 0.88.4/2105/Thu Oct 26 09:14:55 2006 on piglet.vanilla.net X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/175 X-Sequence-Number: 23478 > -- 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. Regards Ben