Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4183A9FB52E for ; Wed, 10 Oct 2007 11:01:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 85731-06 for ; Wed, 10 Oct 2007 11:01:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 7729F9FB3B3 for ; Wed, 10 Oct 2007 11:01:39 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l9AE1Yhq015556; Wed, 10 Oct 2007 10:01:35 -0400 (EDT) To: "David Rovner" cc: "Steve Crawford" , pgsql-admin@postgresql.org Subject: Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start In-reply-to: References: Comments: In-reply-to "David Rovner" message dated "Wed, 10 Oct 2007 09:29:42 -0400" Date: Wed, 10 Oct 2007 10:01:33 -0400 Message-ID: <15555.1192024893@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/70 X-Sequence-Number: 26984 "David Rovner" writes: > I see this error at the command prompt in root executing anything that > starts with "psql". The argument list does not matter. "psql" with no > arguments returns this error as well. PGOPTIONS environment variable, perhaps? It's hard to imagine why anyone would try to set listen_addresses that way, but ... $ PGOPTIONS='--listen_addresses=*' psql psql: FATAL: parameter "listen_addresses" cannot be changed after server start $ regards, tom lane