Re: Moving from Linux to Linux? - Mailing list pgsql-general

From Thomas Boussekey
Subject Re: Moving from Linux to Linux?
Date
Msg-id CALUeYmf1mfs1DDo0kuAZU+n5MeW4hN2AfVE1emDDsVJNu_+FJQ@mail.gmail.com
Whole thread Raw
In response to Re: Moving from Linux to Linux?  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-general


Le mar. 11 mars 2025 à 20:35, Ron Johnson <ronljohnsonjr@gmail.com> a écrit :
On Tue, Mar 11, 2025 at 2:35 PM Paul Foerster <paul.foerster@gmail.com> 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!

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Duplicate Key Values
Next
From: Siraj G
Date:
Subject: hide data from admins