X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7B9059FA5BA for ; Thu, 15 Jun 2006 11:13:13 -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 02447-07 for ; Thu, 15 Jun 2006 11:13:08 -0300 (ADT) X-Greylist: delayed 00:07:24.22817 by SQLgrey- Received: from fallback.suscom.net (fallback.suscom.net [64.78.119.248]) by postgresql.org (Postfix) with ESMTP id 3F0B29F9CAA for ; Thu, 15 Jun 2006 11:13:09 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by fallback.suscom.net (Postfix) with ESMTP id 4A66A790175 for ; Thu, 15 Jun 2006 14:07:41 -0400 (EDT) Received: from fallback.suscom.net ([127.0.0.1]) by localhost (fallback.suscom.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09362-10 for ; Thu, 15 Jun 2006 14:07:39 -0400 (EDT) Received: from smtp4.suscom.net (smtp4.suscom.net [64.78.119.249]) by fallback.suscom.net (Postfix) with ESMTP id C224679020B for ; Thu, 15 Jun 2006 14:07:39 -0400 (EDT) Received: from localhost (unknown [127.0.0.1]) by smtp4.suscom.net (Postfix) with ESMTP id 35F73150074 for ; Thu, 15 Jun 2006 10:05:40 -0400 (EDT) Received: from smtp4.suscom.net ([127.0.0.1]) by localhost (smtp4.suscom.net [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 16164-01-36 for ; Thu, 15 Jun 2006 10:05:27 -0400 (EDT) Received: from [192.168.29.51] (ip7.244.23.209.suscom.net [209.23.244.7]) by smtp4.suscom.net (Postfix) with SMTP id CEA5E150075 for ; Thu, 15 Jun 2006 10:05:27 -0400 (EDT) Mime-Version: 1.0 (Apple Message framework v750) Content-Transfer-Encoding: 7bit Message-Id: <7F9DD4F9-A334-4A52-8501-1DA780CD4D2E@knauth.org> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-sql@postgresql.org From: Geoffrey Knauth Subject: listen_addresses = '*' ok, specific address(es) no Date: Thu, 15 Jun 2006 10:05:26 -0400 X-Mailer: Apple Mail (2.750) X-Virus-Scanned: amavisd-new at suscom.net X-Virus-Scanned: amavisd-new at suscom.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/179 X-Sequence-Number: 25415 I'm running PostgreSQL 8.1.3. In my postgresql.conf, the following works: listen_addresses = '*' but the following does not: listen_addresses = '192.168.1.33' I get an error: WARNING: could not create listen socket for "192.168.1.33" FATAL: could not create any TCP/IP sockets I'm running Mac OS X 10.4.6 on PPC, if that makes a difference. For now, listen_addresses = '*' works for me, but I was curious why I couldn't use the more restrictive listen_addresses. Geoffrey -- Geoffrey S. Knauth | http://knauth.org/gsk