Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.400.131.1.6\))
Subject: Re: Moving from Linux to Linux?
From: Paul Foerster <paul.foerster@gmail.com>
In-Reply-To: <7FC835F0-FE59-45B3-8866-83E8549191D7@thebuild.com>
Date: Wed, 12 Mar 2025 17:48:00 +0100
Cc: Ron Johnson <ronljohnsonjr@gmail.com>,
 Pgsql-General List <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <B78EC89A-032D-40DB-88AE-C213CEA20FDE@gmail.com>
References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com>
 <E0EC05FB-783D-4A24-81B9-0C345A5EC45A@gmail.com>
 <CANzqJaCj4uf-7_ErTP9eHn_rxomRHMDbKAm7M15eAWiRbxZgmA@mail.gmail.com>
 <1DA96F05-D9BF-4D68-80D3-3F3F99691C8D@gmail.com>
 <7FC835F0-FE59-45B3-8866-83E8549191D7@thebuild.com>
To: Christophe Pettus <xof@thebuild.com>
Archived-At: <https://www.postgresql.org/message-id/B78EC89A-032D-40DB-88AE-C213CEA20FDE%40gmail.com>
Precedence: bulk

Hi Christophe,

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

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

Cheers,
Paul=