Re: Support logical replication of global object commands - Mailing list pgsql-hackers

From Zheng Li
Subject Re: Support logical replication of global object commands
Date
Msg-id CAAD30ULcOLfRgZUKtCo0ZPeJfD2wAXxXHY=tbWXZ5HpNssNAGw@mail.gmail.com
Whole thread Raw
In response to Re: Support logical replication of global object commands  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: Support logical replication of global object commands
List pgsql-hackers
> > > Actually, I intend something for global objects. But the main thing
> > > that is worrying me about this is that we don't have a clean way to
> > > untie global object replication from database-specific object
> > > replication.
> >
> > I think ultimately we need a clean and efficient way to publish (and
> > subscribe to) any changes in all databases, preferably in one logical
> > replication slot.
> >
>
> Agreed. I was thinking currently for logical replication both
> walsender and slot are database-specific. So we need a way to
> distinguish the WAL for global objects and then avoid filtering based
> on the slot's database during decoding.

But which WALSender should handle the WAL for global objects if we
don't filter by database? Is there any specific problem you see for
decoding global objects commands in a database specific WALSender?

> I also thought about whether
> we want to have a WALSender that is not connected to a database for
> the replication of global objects but I couldn't come up with a reason
> for doing so. Do you have any thoughts on this matter?

Regards,
Zane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Move defaults toward ICU in 16?
Next
From: Andres Freund
Date:
Subject: Re: Move defaults toward ICU in 16?