Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start - Mailing list pgsql-admin

From Tom Lane
Subject Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start
Date
Msg-id 15555.1192024893@sss.pgh.pa.us
Whole thread Raw
In response to Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start  ("David Rovner" <DRovner@princetonservergroup.com>)
Responses Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start  ("David Rovner" <DRovner@princetonservergroup.com>)
Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start  ("David Rovner" <DRovner@princetonservergroup.com>)
List pgsql-admin
"David Rovner" <DRovner@princetonservergroup.com> 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

pgsql-admin by date:

Previous
From: "David Rovner"
Date:
Subject: Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start
Next
From: "David Rovner"
Date:
Subject: Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start