Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Rovner" <DRovner(at)princetonservergroup(dot)com>
Cc: "Steve Crawford" <scrawford(at)pinpointresearch(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start
Date: 2007-10-10 14:01:33
Message-ID: 15555.1192024893@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"David Rovner" <DRovner(at)princetonservergroup(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Rovner 2007-10-10 14:09:16 Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start
Previous Message David Rovner 2007-10-10 13:29:42 Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start