On Wed, Mar 12, 2025 at 12:48 PM Paul Foerster <paul.foerster@xxxxxxxxx> wrote:
Hi Christophe,
> On 12 Mar 2025, at 12:16, Christophe Pettus <xof@xxxxxxxxxxxx> wrote:
>
> You *can* apply DDL while logical replication is going on, as long as you do so in a disciplined way. This generally means applying it to the subscriber before you apply it to the publisher, and making sure that any columns added to a table are either NULLable or have defaults.
Yes, I know, but this is a non issue in real life with dozens of databases per instance and a few hundred developers doing their work.
Developers making DDL changes on production databases?
Or are there prod and dev databases on the same instance? If so, then know that you don't have to logically replicate the whole instance.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
