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