Content-Type: multipart/alternative;
 boundary="------------MSVLziBNERDOmelaoFUy0iuH"
Message-ID: <b718d444-3f9a-4e0b-bc82-485fb044c828@splendiddata.com>
Date: Thu, 3 Sep 2026 21:35:44 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: BUG #19647: Difference in pg_basebackup behaviour between
 PostgreSQL <= 16 and >= 17 with pgactive extension
To: Jacob Champion <jacob.champion@enterprisedb.com>
Cc: pgsql-bugs@lists.postgresql.org
References: <19647-d18354ebe2134a6d@postgresql.org>
 <CAOYmi+=QyQHvH2Ehqb+Je3nvv-+Qg6Xp8fG+cNs-KwAoHvNyBA@mail.gmail.com>
 <b39d0277-de91-4fa1-b912-e3c8ee38ccf1@splendiddata.com>
 <CAOYmi+myfnx3eC-jpTxGgtTPL5eMitu_nV9PkyqDS8W4puoNcw@mail.gmail.com>
 <cd4f60fe-c8e7-4c15-ae98-6056242d0081@splendiddata.com>
 <CAOYmi+=prw7DdrMf2-k8E2jhbi6dQ2v03xJJYnC0ZwBe4GLwPg@mail.gmail.com>
Content-Language: en-US
From: Edwin Polkerman <edwin.polkerman@splendiddata.com>
Organization: Splendid Data Nederland B.V.
In-Reply-To: 
 <CAOYmi+=prw7DdrMf2-k8E2jhbi6dQ2v03xJJYnC0ZwBe4GLwPg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/b718d444-3f9a-4e0b-bc82-485fb044c828%40splendiddata.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------MSVLziBNERDOmelaoFUy0iuH
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi Jacob,

> We try to avoid big behavior changes in minor version updates.
Ah of course, that 's quite understandable... PG17 was the new major but 
the others were minor releases  :-)

Thank you very much for opening the enhancement request in -hackers!!

Kind regards,

Edwin

On 9/3/26 18:49, Jacob Champion wrote:
> On Thu, Sep 3, 2026 at 4:55 AM Edwin Polkerman
> <edwin.polkerman@splendiddata.com> wrote:
>> Keeps me only wondering why the behaviour change in pg_basebackup is not implemented for PG14 to 16 as well.
> We try to avoid big behavior changes in minor version updates.
>
>> b) pg_basebackup ignores checksum issues on files not owned/managed by postgresql but pg_checksums will still complain about them in the data location.
>>
>> Or is that what you mean for 'b)' below, an enhancement request for pg_checksums to treat checksums the way pg_basebackup does (pg >= 17)?
> Correct.
>
>> I will file a bug report for this issue in github for the third-party extension pgactive. Please let me know if you want me to report an enhancement request or thet you take care about that
> I'm happy to shepherd the conversation over to -hackers, and will do
> that shortly. (I'm probably not the right person to drive it.)
>
> --Jacob
-- 

Splendid Data Nederland B.V.
Binnenhof 62A
1412 LC NAARDEN
+31 85 773 19 99
+31 6 5118 8231

*Follow us on LinkedIn <https://www.linkedin.com/company/3327997/admin/>*
--------------MSVLziBNERDOmelaoFUy0iuH
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p><font face="Liberation Sans">Hi Jacob,</font></p>
    <p><font face="Liberation Sans">
        <blockquote type="cite">
          <pre wrap="" class="moz-quote-pre">We try to avoid big behavior changes in minor version updates.</pre>
        </blockquote>
        Ah of course, that 's quite understandable... PG17 was the new
        major but the others were minor releases  :-)</font></p>
    <p><font face="Liberation Sans">Thank you very much for opening the
        enhancement request in -hackers!!</font></p>
    <p><font face="Liberation Sans">Kind regards,</font></p>
    <p><font face="Liberation Sans">Edwin</font></p>
    <div class="moz-cite-prefix">On 9/3/26 18:49, Jacob Champion wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAOYmi+=prw7DdrMf2-k8E2jhbi6dQ2v03xJJYnC0ZwBe4GLwPg@mail.gmail.com">
      <pre wrap="" class="moz-quote-pre">On Thu, Sep 3, 2026 at 4:55 AM Edwin Polkerman
<a class="moz-txt-link-rfc2396E" href="mailto:edwin.polkerman@splendiddata.com">&lt;edwin.polkerman@splendiddata.com&gt;</a> wrote:
</pre>
      <blockquote type="cite">
        <pre wrap="" class="moz-quote-pre">Keeps me only wondering why the behaviour change in pg_basebackup is not implemented for PG14 to 16 as well.
</pre>
      </blockquote>
      <pre wrap="" class="moz-quote-pre">
We try to avoid big behavior changes in minor version updates.

</pre>
      <blockquote type="cite">
        <pre wrap="" class="moz-quote-pre">b) pg_basebackup ignores checksum issues on files not owned/managed by postgresql but pg_checksums will still complain about them in the data location.

Or is that what you mean for 'b)' below, an enhancement request for pg_checksums to treat checksums the way pg_basebackup does (pg &gt;= 17)?
</pre>
      </blockquote>
      <pre wrap="" class="moz-quote-pre">
Correct.

</pre>
      <blockquote type="cite">
        <pre wrap="" class="moz-quote-pre">I will file a bug report for this issue in github for the third-party extension pgactive. Please let me know if you want me to report an enhancement request or thet you take care about that
</pre>
      </blockquote>
      <pre wrap="" class="moz-quote-pre">
I'm happy to shepherd the conversation over to -hackers, and will do
that shortly. (I'm probably not the right person to drive it.)

--Jacob
</pre>
    </blockquote>
    <div class="moz-signature">-- <br>
      <br>
      <!-- <div style="color:rgb(0,0,0);font-family:Calibri;font-size:medium"><img src="/home/epolkerman/Nextcloud/Edwin/Documents/SplendidData_logo/logotype-splendiddata-v2.0-01.png" width="200" height="56"></div> -->
      <div
        style="color:rgb(0,0,0);font-family:Liberation;font-size:medium">
        <div style="color:rgb(32,33,36)"><font face="Liberation Sans"
            size="2" color="#274e13">Splendid Data Nederland B.V.</font></div>
        <div style="color:rgb(32,33,36)"><font face="Liberation Sans"
            size="2" color="#274e13">Binnenhof 62A</font></div>
        <div style="color:rgb(32,33,36)"><font face="Liberation Sans"
            size="2" color="#274e13">1412 LC NAARDEN</font></div>
        <div style="color:rgb(32,33,36)"><font face="Liberation Sans"
            size="2" color="#274e13">+31 85 773 19 99</font></div>
        <div><font face="Liberation Sans" size="2" color="#7f7f7f">+31 6
            5118 8231</font></div>
        <div><font face="Liberation Sans" size="2" color="#7f7f7f"><br>
          </font></div>
        <div><font face="Liberation Sans" size="2" color="#7f7f7f"><b>Follow
              us on <a
                href="https://www.linkedin.com/company/3327997/admin/"
                target="_blank">LinkedIn</a></b></font></div>
      </div>
    </div>
  </body>
</html>

--------------MSVLziBNERDOmelaoFUy0iuH--