Horton

Re: Moving from Linux to Linux?

Christophe Pettus <xof@thebuild.com>

View thread View on postgr.es
From: Christophe Pettus <xof@thebuild.com>
To: Paul Foerster <paul.foerster@gmail.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>, Pgsql-General List <pgsql-general@lists.postgresql.org>
Date: 2025-03-12T11:16:43Z
Lists: 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 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.