public inbox for [email protected]
help / color / mirror / Atom feedFrom: Gregory Smith <[email protected]>
To: Scot Kreienkamp <[email protected]>
Cc: Devrim Gündüz <[email protected]>
Cc: [email protected] <[email protected]>
Cc: Bala M <[email protected]>
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Date: Fri, 24 Oct 2025 01:34:43 -0400
Message-ID: <CAHLJuCV5uoEjH+S7Wub7eRc7thcXtVZZNvYc1RyEC19Rx3V7Mw@mail.gmail.com> (raw)
In-Reply-To: <SJ0PR15MB5245B6F64A2004F30004184E9AF0A@SJ0PR15MB5245.namprd15.prod.outlook.com>
References: <CAJ4rSwspyYBppQS701C=BVFX2yrP1JErgDCZXbC15BQh2zAS1Q@mail.gmail.com>
<a2cd8084-b93e-4da0-8999-569a6e58ef6b.8f62f83c-ab51-428e-98d1-ab1abb243a49.a730880f-5287-4439-a814-c8637b50f48b@emailsignatures365.codetwo.com>
<a2cd8084-b93e-4da0-8999-569a6e58ef6b.b1460fbe-55a2-4060-995f-39f4e2f3c7f9.1e3d3594-62a3-42b0-897b-6389e0f7ff72@emailsignatures365.codetwo.com>
<[email protected]>
<SJ0PR15MB5245B6F64A2004F30004184E9AF0A@SJ0PR15MB5245.namprd15.prod.outlook.com>
On Thu, Oct 23, 2025 at 4:24 PM Scot Kreienkamp <
[email protected]> wrote:
>
> I always assumed streaming would “just work” as long as it’s the same
> major PG version and Linux-to-Linux regardless of OS/glibc version....It
> never occurred to me that there could be an OS influencing factor like the
> glibc version for streaming replication.
>
In addition to the locale checking when things are accessed, when you bring
up a database cluster it checks some pg_controldata entries to make sure
they match what the server's source code was built with. If any of them
are off, it won't run against those databases.
As a simple example that happens sometimes, if your main Linux PG install
increased the block size changed at compile time, a different PG binary
built with the default sizes will fail trying to read data from the
modified one. Because all these compile options have to match, sometimes
you can't migrate a database built with one Linux distribution to another.
When that happens it's sometimes possible to hack together a custom build
that matches the origin primary better, but now you're into packaging your
own PG binaries.
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
In-Reply-To: <CAHLJuCV5uoEjH+S7Wub7eRc7thcXtVZZNvYc1RyEC19Rx3V7Mw@mail.gmail.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