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

From David Rovner
Subject persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start
Date
Msg-id F543E86A0B415E41806A68AA76E3C7F4019EC5C9@mailman.teve.inc
Whole thread Raw
List pgsql-admin

[repost]

 

Hello,

 

I have searched the archives database, with no luck.

 

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:

 

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

 

I rename the data directory, and do a new “service postgresql initdb”. Still the error is persistent. Shutdown, no change.

 

As if there is some lingering filelock somewhere???

 

Please help. I am considering re-installing, but would rather not….

 

Thanks,

 

Dave Rovner

Princeton Server Group

Princeton NJ

pgsql-admin by date:

Previous
From: "Milen A. Radev"
Date:
Subject: Re: Schema objects
Next
From: "David Rovner"
Date:
Subject: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start