Re: Alter system and reload causes bogus complaints about setting changes - Mailing list pgsql-bugs

From Amit Kapila
Subject Re: Alter system and reload causes bogus complaints about setting changes
Date
Msg-id CAA4eK1JhqQtW8kZY1ndgea9BX_GSL6JpmbAMZCeT7HBuxtdTFQ@mail.gmail.com
Whole thread Raw
In response to Re: Alter system and reload causes bogus complaints about setting changes  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-bugs
On Fri, Jul 4, 2014 at 11:24 AM, Mark Kirkwood <
mark.kirkwood@catalyst.net.nz> wrote:
> On 04/07/14 15:11, Amit Kapila wrote:
>> True, but as I explained in that thread as well that this is an
>> existing behaviour which is also visible via Alter System, so
>> changing an existing mechanism requires non-trivial fix (eliminating
>> duplicate entries during processing of config file) which I think
>> can be risky doing at this time in terms of impact, however we
>> can try to minimise the inconvenience user can face due to this feature.
>>
>
> However the existence of ALTER SYSTEM has made the likelihood of this
error much more likely, and also more confusing. Previously users *knew*
they were editing an additional include conf file or similar so the advice
'eliminate clashes' was fine - the new functionality hides this (which is
great) but obfuscates the error and makes the error message wrong (not so
good). So some additional clarification is really required.

Sure, as suggested upthread, I think we can add a note so that
users can atleast aware of such a behaviour for now and for 9.5,
I will try to see if I can eliminate this problem.

> I have just had a similar conversation with some people here about ALTER
SYSTEM in 9.4 - they *loved* the feature, but were bemused (at the very
least) by the error message.

Good to hear.

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Alter system and reload causes bogus complaints about setting changes
Next
From: Sandeep Thakkar
Date:
Subject: Re: unattended install error