Re: Moving from Linux to Linux?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-General List <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Moving from Linux to Linux?
Date: 2025-03-12 16:59:20
Message-ID: CANzqJaCfAc-5v==VHEEizejAbg3OXfjN25Psz2sHRad_OQeajg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 12, 2025 at 12:48 PM Paul Foerster <paul(dot)foerster(at)gmail(dot)com>
wrote:

> Hi Christophe,
>
> > On 12 Mar 2025, at 12:16, Christophe Pettus <xof(at)thebuild(dot)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 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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Foerster 2025-03-12 20:16:18 Re: Moving from Linux to Linux?
Previous Message Paul Foerster 2025-03-12 16:48:00 Re: Moving from Linux to Linux?