Re: Moving from Linux to Linux?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Moving from Linux to Linux?
Дата
Msg-id CANzqJaCfAc-5v==VHEEizejAbg3OXfjN25Psz2sHRad_OQeajg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Moving from Linux to Linux?  (Paul Foerster <paul.foerster@gmail.com>)
Ответы Re: Moving from Linux to Linux?
Список pgsql-general
On Wed, Mar 12, 2025 at 12:48 PM 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 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!

В списке pgsql-general по дате отправления: