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

From Paul Foerster
Subject Re: Moving from Linux to Linux?
Date
Msg-id B78EC89A-032D-40DB-88AE-C213CEA20FDE@gmail.com
Whole thread Raw
In response to Re: Moving from Linux to Linux?  (Christophe Pettus <xof@thebuild.com>)
Responses Re: Moving from Linux to Linux?
List pgsql-general
Hi Christophe,

> On 12 Mar 2025, at 12:16, Christophe Pettus <xof@thebuild.com> wrote:
>
> 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. 

Yes, I know, but this is a non issue in real life with dozens of databases per instance and a few hundred developers
doingtheir work. 

So, logical replication online for me is more of an academic case study. In real life I need downtime.

Cheers,
Paul


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Duplicate Key Values
Next
From: Ron Johnson
Date:
Subject: Re: Moving from Linux to Linux?