Re: Moving from Linux to Linux?

Поиск
Список
Период
Сортировка
От Thomas Boussekey
Тема Re: Moving from Linux to Linux?
Дата
Msg-id CALUeYmf1mfs1DDo0kuAZU+n5MeW4hN2AfVE1emDDsVJNu_+FJQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Moving from Linux to Linux?  (Ron Johnson <ronljohnsonjr@gmail.com>)
Список 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 по дате отправления: