Re: WAL Archiving and base backup

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: WAL Archiving and base backup
Date: 2022-01-16 00:31:42
Message-ID: d2b119bf-1a54-8f7b-4569-50dbd8f2ffc8@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/15/22 16:23, Mladen Gogala wrote:
> On 1/14/22 16:00, David G. Johnston wrote:
>> I still don't really understand what is so great about it.  About its
>> only redeeming feature is a declaration that "it is in core" and that
>> newcomers can just default to it without thinking.  I'd rather just
>> play favorites and write "use pgbackrest" in our documentation.  Or
>> some hybrid approach where we don't just pick one but instead guide
>> people to the community solutions that are out there.  I don't think I
>> really want the people responsible for core to spend time on writing
>> end-user backup tooling. Their time is much more valuably spent
>> working on the core product.
>>
>> David J.
>>
> Well, the "without thinking" part of your post can be rephrased as "ease
> of use". Do database administrators really need to think about which
> backup software to use? What kind of knowledge will such an evaluation
> provide? All commercial databases have some form of backup software
> included into the core database. After all, backup and restore are
> extremely important functions which IMHO should be provided along with
> the database software.

That is easy to say the reality is:

Previous CommitFest:

https://commitfest.postgresql.org/35/

Note the number of 'Moved to next CF'

Current CommitFest ending 1/31/2022:

https://commitfest.postgresql.org/36/

Note number of 'Needs review'

This is for the current Core software. Adding more to that will just add
to the above 'Moved to next CF' and 'Needs review'.

>
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2022-01-16 00:41:12 Re: Assistance with an out of shared memory error
Previous Message Mladen Gogala 2022-01-16 00:23:04 Re: WAL Archiving and base backup