X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E3BAE8B9F5C for ; Mon, 14 Feb 2005 19:32:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55126-01 for ; Mon, 14 Feb 2005 19:32:37 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202]) by svr1.postgresql.org (Postfix) with ESMTP id 818F98B9F43 for ; Mon, 14 Feb 2005 19:32:36 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 58so1873719wri for ; Mon, 14 Feb 2005 11:32:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=nPhLdxjckxrotyKssgOmwZrBQ9iBGXD3eL24R4oDHSOaDJzWwBW49EzdfoFOpY2fMfqJL72OPyRW4ULafK9XsZad1mewmV/Is65mLQb96j49xA5LAZyoem+NVe3jtz/k+EwXNuHuYr9kjQ9iPmheV8+HB2/qUrp8ZEropvBK4E0= Received: by 10.54.27.76 with SMTP id a76mr107249wra; Mon, 14 Feb 2005 11:32:36 -0800 (PST) Received: by 10.54.57.52 with HTTP; Mon, 14 Feb 2005 11:32:35 -0800 (PST) Message-ID: <32c009ea0502141132140a2852@mail.gmail.com> Date: Mon, 14 Feb 2005 21:32:35 +0200 From: "Milen A. Radev" Reply-To: milen@radev.net To: pgsql-admin@postgresql.org Subject: Re: Problem binding postmaster to several interfaces In-Reply-To: <29460.1108401273@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <32c009ea050214042443b5cb84@mail.gmail.com> <29460.1108401273@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/145 X-Sequence-Number: 16313 On Mon, 14 Feb 2005 12:14:33 -0500, Tom Lane wrote: > "Milen A. Radev" writes: > > The current value of my "listen_addresses" setting is: > > listen_addresses = '192.168.0.1, 127.0.0.1' > > Nothing wrong with that. > > > but using "netstat -tupan" I still see: > > > tcp 0 0 0.0.0.0:5432 0.0.0.0:* > > LISTEN 10042/postmaster > > Are you by any chance using "-i" on the postmaster command line? That > overrides whatever you put for listen_addresses in the config file. Yep, that was. I use custom script for supervising postmaster with daemontools. And I failed to notice this change in the behaviour in v8.0. Thanks a lot. > > regards, tom lane > -- Milen A. Radev