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 E2B8C9FA5BA for ; Thu, 15 Jun 2006 11:40:26 -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 05323-09 for ; Thu, 15 Jun 2006 11:40:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 8C3729F9CAA for ; Thu, 15 Jun 2006 11:40:21 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k5FEeIt0027883; Thu, 15 Jun 2006 10:40:18 -0400 (EDT) To: Geoffrey Knauth cc: pgsql-sql@postgresql.org Subject: Re: listen_addresses = '*' ok, specific address(es) no In-reply-to: <7F9DD4F9-A334-4A52-8501-1DA780CD4D2E@knauth.org> References: <7F9DD4F9-A334-4A52-8501-1DA780CD4D2E@knauth.org> Comments: In-reply-to Geoffrey Knauth message dated "Thu, 15 Jun 2006 10:05:26 -0400" Date: Thu, 15 Jun 2006 10:40:18 -0400 Message-ID: <27882.1150382418@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/181 X-Sequence-Number: 25417 Geoffrey Knauth writes: > 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 There should be more info than that --- AFAICS all the failure paths in that code emit LOG messages. Perhaps you have log_min_messages set too high to allow the info to come out? regards, tom lane