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

From Christophe Pettus
Subject Re: Moving from Linux to Linux?
Date
Msg-id 7FC835F0-FE59-45B3-8866-83E8549191D7@thebuild.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?
List pgsql-general

> On Mar 12, 2025, at 11:01, Paul Foerster <paul.foerster@gmail.com> wrote:
> DDL during logical replication unfortunately is a show-stopper.

You *can* apply DDL while logical replication is going on, as long as you do so in a disciplined way.  This generally
meansapplying it to the subscriber before you apply it to the publisher, and making sure that any columns added to a
tableare either NULLable or have defaults. 




pgsql-general by date:

Previous
From: Paul Foerster
Date:
Subject: Re: Moving from Linux to Linux?
Next
From: Artur Zakirov
Date:
Subject: Re: ERROR: could not read block 0 in file when creating an index out of a function