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
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 по дате отправления: