From: | "David Rovner" <DRovner(at)princetonservergroup(dot)com> |
---|---|
To: | "Steve Crawford" <scrawford(at)pinpointresearch(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start |
Date: | 2007-10-10 13:29:42 |
Message-ID: | F543E86A0B415E41806A68AA76E3C7F401A0FE5A@mailman.teve.inc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
David Rovner wrote:
>>...
>> After some network configuration changes (IP changes and some editing
to
>> config files which may have been interrupted buy shutdowns), I cannot
>> get past this error:
>That's a bit vague. What changed externally with your network? What
>files were you changing and what were you changing in them? What do you
>mean by "may have been interrupted buy shutdowns" - were the changes
>made or not? Did you restart the server and was it a full reboot or
just
>postgresql?
The IP, the subnet, and nameserver address changed. The admin (not
responsible for postgres) doing the changes has left the company (3 days
ago). I am testing postgres for use in a slony replication scheme. The
postgresql.conf and the pg_hba.conf files were being modified (this may
be irrelevant, I don't know). I have done restarts on postgres, and
complete shutdown. No change. I have renamed the db directory (this is a
test database) in order to force an initdb. And still no change.
>> 'psql: FATAL: "listen_addresses" cannot be changed after server start
>Where do you see this error? The statement is true - listen addresses
is
>a parameter that can only be set when the PostgreSQL server starts.
>Trying to change the parameter from, say, psql by running
>"set listen_addresses to '*';" will yield this error. Could there be a
>script that generates such a command?
I cannot execute any psql commands from root.
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.
>Cheers,
>Steve
Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-10-10 14:01:33 | Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start |
Previous Message | Josh Trutwin | 2007-10-10 02:54:09 | Re: Schema objects |