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

From Ron Johnson
Subject Re: Moving from Linux to Linux?
Date
Msg-id CANzqJaCj4uf-7_ErTP9eHn_rxomRHMDbKAm7M15eAWiRbxZgmA@mail.gmail.com
Whole thread Raw
In response to Re: Moving from Linux to Linux?  (Paul Foerster <paul.foerster@gmail.com>)
Responses Re: Moving from Linux to Linux?
Re: Moving from Linux to Linux?
List pgsql-general
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.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: H
Date:
Subject: Re: Creating files with testdata
Next
From: Adrian Klaver
Date:
Subject: Re: Duplicate Key Values