public inbox for [email protected]  

help / color / mirror / Atom feed
From: Ron Johnson <[email protected]>
To: Pgsql-General List <[email protected]>
Subject: Re: Moving from Linux to Linux?
Date: Wed, 12 Mar 2025 12:59:20 -0400
Message-ID: <CANzqJaCfAc-5v==VHEEizejAbg3OXfjN25Psz2sHRad_OQeajg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<CANzqJaCj4uf-7_ErTP9eHn_rxomRHMDbKAm7M15eAWiRbxZgmA@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<[email protected]>

On Wed, Mar 12, 2025 at 12:48 PM Paul Foerster <[email protected]>
wrote:

> Hi Christophe,
>
> > On 12 Mar 2025, at 12:16, Christophe Pettus <[email protected]> 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!


view thread (18+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Moving from Linux to Linux?
  In-Reply-To: <CANzqJaCfAc-5v==VHEEizejAbg3OXfjN25Psz2sHRad_OQeajg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox