| From: | Paul Foerster <paul(dot)foerster(at)gmail(dot)com> |
|---|---|
| To: | Christophe Pettus <xof(at)thebuild(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 16:48:00 |
| Message-ID: | B78EC89A-032D-40DB-88AE-C213CEA20FDE@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
So, logical replication online for me is more of an academic case study. In real life I need downtime.
Cheers,
Paul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2025-03-12 16:59:20 | Re: Moving from Linux to Linux? |
| Previous Message | Adrian Klaver | 2025-03-12 16:01:10 | Re: Duplicate Key Values |