Re: Removal of archive in wal_level

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Removal of archive in wal_level
Date: 2013-11-04 17:07:07
Message-ID: CA+TgmoaTG9U4=A_bs8SbdEMM2+faPQhzUjhJ7F-nPFy+BNs_zA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 4, 2013 at 11:45 AM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> * Peter Eisentraut (peter_e(at)gmx(dot)net) wrote:
>> On 11/4/13, 8:58 AM, Robert Haas wrote:
>> > On Mon, Nov 4, 2013 at 5:57 AM, Michael Paquier
>> > <michael(dot)paquier(at)gmail(dot)com> wrote:
>> >>> Please find attached a patch doing what is written in the $subject.
>> >> With the documentation updated, this is even better...
>> >
>> > I'm unconvinced that there's any value in this.
>>
>> Yeah, the only thing this will accomplish is to annoy people who are
>> actually using that level. It would be more interesting if we could get
>> rid of the wal_level setting altogether, but of course there are valid
>> reasons against that.
>
> It would actually be valuable to 'upgrade' those people to
> hot_standby, which is what I had kind of been hoping would happen
> eventually. I agree that there's no use for 'archive' today, but rather
> than break existing configs that use it, just make 'archive' and
> 'hot_standby' mean the same thing. In the end, I'd probably vote to
> make 'hot_standby' the 'legacy/deprecated' term anyway.

That strikes me as a better idea than what the patch actually does,
but I still think it's nanny-ism. I don't believe we have the right
to second-guess the choices our users make in this area. We can make
recommendations in the documentation, but at the end of the day if
users choose to use archive rather than hot_standby, we should respect
that choice, not break it because we think we know better.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Browne 2013-11-04 18:49:59 Re: How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?
Previous Message Stephen Frost 2013-11-04 16:45:43 Re: Removal of archive in wal_level