agora inbox for pgsql-bugs@postgresql.org
help / color / mirror / Atom feedFrom: Edwin Polkerman <edwin.polkerman@splendiddata.com>
To: Jacob Champion <jacob.champion@enterprisedb.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19647: Difference in pg_basebackup behaviour between PostgreSQL <= 16 and >= 17 with pgactive extension
Date: Wed, 2 Sep 2026 22:43:15 +0200
Message-ID: <b39d0277-de91-4fa1-b912-e3c8ee38ccf1@splendiddata.com> (raw)
In-Reply-To: <CAOYmi+=QyQHvH2Ehqb+Je3nvv-+Qg6Xp8fG+cNs-KwAoHvNyBA@mail.gmail.com>
References: <19647-d18354ebe2134a6d@postgresql.org>
<CAOYmi+=QyQHvH2Ehqb+Je3nvv-+Qg6Xp8fG+cNs-KwAoHvNyBA@mail.gmail.com>
Hi Jacob,
Yes, the 18.6 and 17.11 global/ directory contains this file as well.
Doing a pg_checksums on the data directory gives exactly the same result
as for the PostgreSQL 16.15, 15.19 and 14.24:
pg_checksums -c /var/pgpure/postgres/18/cluster2/
pg_checksums: error: invalid segment number 0 in file name
"/var/pgpure/postgres/18/cluster2//global/pgactive.stat"
The file pgactive.stat is placed in the globals directory when the
database server is stopped / started after installation of the extension
and setup of the replication group. I think it is used for internal
bookkeeping for replication statussen with the other node(s) in the
replication group when the node is shutdown.
Because of the difference in behaviour of pg_basebackup what dazzled me,
it made me decide to create the issue in the pgql-bugs mailing list.
Please let me know if it is not PostgreSQL related and if it should be
created in github at AWS/pgactive
Kind regards,
Edwin
On 9/2/26 20:51, Jacob Champion wrote:
> On Tue, Sep 1, 2026 at 6:16 AM PG Bug reporting form
> <noreply@postgresql.org> wrote:
>> For PostgreSQL 18.6 and 17.11 the backup completes without any problems.
> Do the global/ directories for the 17 and 18 clusters contain a
> pgactive.stat file?
>
> Without knowing anything about pgactive in particular (it's a
> third-party extension)... It sure looks like that extension, or else
> something related to it, has put a random file into the DB internals
> in a way that won't pass our checksum verification. It needs to go
> somewhere else.
>
> --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/>*
view thread (7+ messages) latest in thread
Message-ID: <b39d0277-de91-4fa1-b912-e3c8ee38ccf1@splendiddata.com>
Permalink: ../b39d0277-de91-4fa1-b912-e3c8ee38ccf1@splendiddata.com/
Also on: postgresql.org/message-id/b39d0277-de91-4fa1-b912-e3c8ee38ccf1@splendiddata.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: edwin.polkerman@splendiddata.com, jacob.champion@enterprisedb.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19647: Difference in pg_basebackup behaviour between PostgreSQL <= 16 and >= 17 with pgactive extension
In-Reply-To: <b39d0277-de91-4fa1-b912-e3c8ee38ccf1@splendiddata.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox