Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 146409FA344 for ; Thu, 26 Oct 2006 10:02:13 -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 94921-08 for ; Thu, 26 Oct 2006 13:02:00 +0000 (UTC) X-Greylist: delayed 00:09:28.829276 by SQLgrey- Received: from wwwmail3.joensuu.fi (wwwmail3.joensuu.fi [193.167.41.4]) by postgresql.org (Postfix) with ESMTP id D9A3A9FA332 for ; Thu, 26 Oct 2006 10:01:59 -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 k9QD215B016449 for ; Thu, 26 Oct 2006 16:02:01 +0300 Received: (from www@localhost) by wwwmail3.joensuu.fi (8.12.10/8.12.10/Submit) id k9QD21fg016448 for pgsql-admin@postgresql.org; Thu, 26 Oct 2006 16:02:01 +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 16:02:01 +0300 Message-ID: <1161867721.4540b1c933417@wwwmail.joensuu.fi> Date: Thu, 26 Oct 2006 16:02:01 +0300 From: Jari Vauhkonen To: pgsql-admin@postgresql.org Subject: TCP/IP connection problem 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/174 X-Sequence-Number: 23477 Hello, I have tried to set up a PostgreSQL server with no success. Connections from other-than-local hosts won't work. I've tried to connect from Windows XP using PgWorkSheet && pgAccess. I have studied the internet for similar problems without an answer. the following has been done: -- PSQL & PSQL-server installation -- configuring the pg_hba.conf with following lines: host all 127.0.0.1 255.255.255.255 trust host all 255.255.255.255 trustlocal all trust host koli 255.255.255.255 trust -- configuring the postgresql.conf wit following lines: #listen_addresses = '*' #port = 5432 #tcpip_socket = true -- starting the postmaster with command /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data & -- installing the PSQL ODBC driver for Windows I wonder if the problem is related to the operating system's TCP/IP settings? I tried netstat to find out if the port 5432 is used, but it seems that it isn't. What should I do? Remember, I'm quite a newbie with linux-style operating systems so keep it simple. Thanks already, Jari