public inbox for [email protected]
help / color / mirror / Atom feedFrom: Thomas Boussekey <[email protected]>
To: Ron Johnson <[email protected]>
Cc: Pgsql-General List <[email protected]>
Subject: Re: Moving from Linux to Linux?
Date: Tue, 11 Mar 2025 21:49:05 +0100
Message-ID: <CALUeYmf1mfs1DDo0kuAZU+n5MeW4hN2AfVE1emDDsVJNu_+FJQ@mail.gmail.com> (raw)
In-Reply-To: <CANzqJaCj4uf-7_ErTP9eHn_rxomRHMDbKAm7M15eAWiRbxZgmA@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<CANzqJaCj4uf-7_ErTP9eHn_rxomRHMDbKAm7M15eAWiRbxZgmA@mail.gmail.com>
Le mar. 11 mars 2025 à 20:35, Ron Johnson <[email protected]> a
écrit :
> On Tue, Mar 11, 2025 at 2:35 PM Paul Foerster <[email protected]>
> wrote:
>
>> Hi Devrim, Thomas, Adrian, Ron, Joe,
>>
>> answering to myself as answering to five postings in one go is
>> impossible. 🤣
>>
>> > Are there any obstacles that definitely make that a no-go? Do I risk
>> corruption? It's both Linux, just a different distribution.
>>
>> The question was a bit of an idea. So the glibc version in not known yet,
>> but I'm highly confident that they will differ. A reindex could in theory
>> be possible in most cases, but is a definite show stopper on some of our
>> databases, because it would mean too much application downtime.
>>
>> So, it's either logical replication or close to impossible.
>>
>
> If you don't do much DDL, the LR should be quite workable.
>
Stop DDL during the copy process is mandatory, but there are so other
restrictions to consider also (large objects, sequences...), see this page
for an exhaustive list:
https://www.postgresql.org/docs/current/logical-replication-restrictions.html
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>
view thread (18+ messages) latest in thread
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]
Subject: Re: Moving from Linux to Linux?
In-Reply-To: <CALUeYmf1mfs1DDo0kuAZU+n5MeW4hN2AfVE1emDDsVJNu_+FJQ@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