Re: Moving from Linux to Linux?

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Paul Foerster <paul(dot)foerster(at)gmail(dot)com>
Cc: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, Pgsql-General List <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Moving from Linux to Linux?
Date: 2025-03-12 11:16:43
Message-ID: 7FC835F0-FE59-45B3-8866-83E8549191D7@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Mar 12, 2025, at 11:01, Paul Foerster <paul(dot)foerster(at)gmail(dot)com> wrote:
> DDL during logical replication unfortunately is a show-stopper.

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Artur Zakirov 2025-03-12 11:54:25 Re: ERROR: could not read block 0 in file when creating an index out of a function
Previous Message Paul Foerster 2025-03-12 11:01:09 Re: Moving from Linux to Linux?