MIME-Version: 1.0
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>
 <B78EC89A-032D-40DB-88AE-C213CEA20FDE@gmail.com>
In-Reply-To: <B78EC89A-032D-40DB-88AE-C213CEA20FDE@gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 12 Mar 2025 12:59:20 -0400
Message-ID: <CANzqJaCfAc-5v==VHEEizejAbg3OXfjN25Psz2sHRad_OQeajg@mail.gmail.com>
Subject: Re: Moving from Linux to Linux?
To: Pgsql-General List <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000010239006302821ec"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCfAc-5v%3D%3DVHEEizejAbg3OXfjN25Psz2sHRad_OQeajg%40mail.gmail.com>
Precedence: bulk

--00000000000010239006302821ec
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Mar 12, 2025 at 12:48=E2=80=AFPM Paul Foerster <paul.foerster@gmail=
.com>
wrote:

> 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 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 database=
s
> 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.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--00000000000010239006302821ec
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Mar 12, 2025 at 12:48=E2=80=AFPM =
Paul Foerster &lt;<a href=3D"mailto:paul.foerster@gmail.com">paul.foerster@=
gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_contain=
er"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bor=
der-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Christophe,<br>
<br>
&gt; On 12 Mar 2025, at 12:16, Christophe Pettus &lt;<a href=3D"mailto:xof@=
thebuild.com" target=3D"_blank">xof@thebuild.com</a>&gt; wrote:<br>
&gt; <br>
&gt; You *can* apply DDL while logical replication is going on, as long as =
you do so in a disciplined way.=C2=A0 This generally means applying it to t=
he subscriber before you apply it to the publisher, and making sure that an=
y columns added to a table are either NULLable or have defaults.<br>
<br>
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.<br></blockquote=
><div><br></div><div></div></div><div>Developers making DDL changes on prod=
uction databases?</div><div><br></div><div>Or are there prod and dev databa=
ses on the same instance?=C2=A0 If so, then know that you don&#39;t have to=
 logically replicate the whole instance.</div><div><br></div><span class=3D=
"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_sign=
ature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Do=
n&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster=
!</div></div></div></div></div></div>

--00000000000010239006302821ec--